CALC_MASTER_MS_DATE - Intergraph Smart Materials - Version 10.1 - Customization & Programming - Hexagon

Intergraph Smart Materials Customization (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.1

Description:

The calc_master_ms_date function is used to calculate the date specified by parameter p_date_type of the master milestone denoted by parameter p_ms_id (which must be a typed milestone, naturally) in case a derivation rule is in place for the given date type (which then populates the detail milestones of this master milestone).

The default implementation it returns the minimum of the date of interest of the associated detail milestones (NULL is returned in case the corresponding dates of all the detail milestones of p_ms_id are NULL).

Parameters:

p_ms_id          IN m_milestones.ms_id%TYPE

The primary key value of the milestone for which the actual date is to be recalculated.

p_plan_item_type IN VARCHAR2

Type of the underlying planning item. For planned requisitions (database table m_eng_comm_items) 'ECI' is passed, for planned tagged items (database table m_eng_non_comm_items) the value is 'ENCI'.

p_date_type      IN VARCHAR2

Type of date that is to be calculated. Possible values are 'SCHEDULED' which refers to the planned date of the milestone denoted by p_ms_id, 'PLANNED' which refers to its forecasted date (sic!), and 'ACTUAL' which refers to its actual date.

p_plan_item_id   IN NUMBER

Primary key value of the underlying planning item. Depending on the value of parameter p_plan_item_type, this refers to m_eng_comm_items.eci_id or m_eng_non_comm_items.enci_id.

p_mset_id        IN m_ms_sets.mset_id%TYPE

The primary key value of the milestone set (see P.10.62 Milestone Sets or Planning Setup) assigned to the planning item (which includes the milestone label of the milestone denoted by parameter p_ms_id).

p_mc_id          IN m_ms_configs.mc_id%TYPE

The primary key value of the milestone label (see P.10.61 Milestone Labels or Planning Setup) that defines the characteristics of the milestone denoted by parameter p_ms_id.

Type:

Function

Usage:

Planning, P.60.01, P.60.03, P.60.05

Event:

Click Calculate Forecasted or Calc All Forecasted on P.60.01, P.60.03, or P.60.05, or select Recalculate Planning Dates or Recalculate Forecasted Dates on the Planning screen. Particularly on every database commit that updates a date column of a ‘trackable’ table in the database.

Default:

MIN(m_ms_details.actual_date) WHERE m_ms_details.actual_date IS NOT NULL