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 |