Description: |
This is a sample of function that can be used to build function-based derivation rules for milestone labels. They will be recognized by the LOV on the function code field in Window 2 of P.10.61 Milestone Labels and in Planning Setup, because of its specific signature. Sample function sample_fnc_ms_deriv illustrates the signature that is mandatory for a function that is to be used by function based derivation rules for untyped milestone labels (this is, milestone labels the type of which remains unspecified in P.10.61 Milestone Labels and in Planning Setup). Parameters: p_ms_id IN m_milestones.ms_id%TYPE The primary key value of the milestone for which a date is to be calculated. p_plan_item_type IN VARCHAR2 Type of the underlying planning item. For planned requisitions (database table m_eng_comm_items) the value '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. p_mssp_id IN m_milestones.mssp_id%TYPE The primary key value of the supplement milestone plan that the milestone denoted by p_ms_id belongs to. If passed as NULL, then p_ms_id is part of the overall milestone plan of the planning item denoted by p_plan_item_type and p_plan_item_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: |
TRUNC(SYSDATE) |