[Home] [Help]
21:
22: PS_NODE_TYPE_REFERENCE CONSTANT PLS_INTEGER := 263;
23: PS_NODE_TYPE_BOM_MODEL CONSTANT PLS_INTEGER := 436;
24: PS_NODE_TYPE_BOM_OPTIONCLASS CONSTANT PLS_INTEGER := 437;
25: PS_NODE_TYPE_BOM_STANDARD CONSTANT PLS_INTEGER := 438;
26: SRC_APPL_ID_BOM CONSTANT PLS_INTEGER := 702;
27:
28: ENGINE_TYPE_FCE CONSTANT VARCHAR2(1) := 'F';
29:
17516: -- to take care of item of ps_node_type=263 with src_application not null
17517:
17518: BEGIN
17519: IF ((cz_pb_mgr.v_ps_type_old_tbl(i) = PS_NODE_TYPE_BOM_MODEL)
17520: OR(cz_pb_mgr.v_ps_type_old_tbl(i) = PS_NODE_TYPE_BOM_OPTIONCLASS) OR(cz_pb_mgr.v_ps_type_old_tbl(i) = PS_NODE_TYPE_BOM_STANDARD)
17521: OR(cz_pb_mgr.v_ps_type_old_tbl(i) = PS_NODE_TYPE_REFERENCE AND cz_pb_mgr.v_ps_src_appl_id_old_tbl(i) = SRC_APPL_ID_BOM))
17522: THEN
17523: SELECT item_id, item_type_id
17524: ,DECODE(cz_pb_mgr.bomsynch_flag
23993: mm_v_tbl_sync_prop(s_prop_id) := t_prop_id;
23994:
23995: --Because the property does not exist on the target, we will be creating a new property and so we need both
23996: --numeric value and numeric default value. These two values are special because of their use for translatable
23997: --properties. All other property attributes are handled in a standard way and don't need any special tables.
23998:
23999: IF(cz_pb_mgr.v_prop_vals_data_typ_ref(j) = 8)THEN /*Translatable properties*/
24000:
24001: --First for the numeric value of the translatable property.