SAMPLE_FNC_MS_DERIV - Intergraph Smart Materials - Version 10.2 - Customization & Programming - Hexagon

Intergraph Smart Materials Customization (10.2)

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

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)