[Home] [Help]
526: var_quoteable_flag CZ_ITEM_MASTERS.quoteable_flag%TYPE;
527: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
528: var_node_name CZ_PS_NODES.name%TYPE;
529: var_key CZ_PS_NODES.user_str03%TYPE;
530: var_fk_key CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
531: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;
532: var_minimum CZ_PS_NODES.minimum%TYPE;
533: var_maximum CZ_PS_NODES.maximum%TYPE;
534: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
654: SELECT devl_project_id INTO var_project_id FROM CZ_PS_NODES
655: WHERE ps_node_id=var_ps_node_id;
656:
657: --
658: -- Allocate run_id for CZ_IMP_PS_NODES
659: --
660: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO p_run_id FROM dual;
661:
662: --
853: IF ps_node_already_exists AND exists_in_t_names THEN
854:
855: -- Need to update the previous entry
856: LOG_REPORT('CZ_POPULATORS_PKG.preview','Updating previous entry');
857: UPDATE CZ_IMP_PS_NODES
858: SET PROPERTY_BACKPTR = var_property_ptr,ITEM_TYPE_BACKPTR = var_item_type_ptr,INTL_TEXT_ID = var_new_text_id,
859: ITEM_ID = var_item_id,USER_STR03 = var_key,FSK_PSNODE_3_EXT = var_fk_key,
860: PRIMARY_UOM_CODE = var_primary_uom_code,
861: QUOTEABLE_FLAG = var_quoteable_flag,
874: t_names(t_names.Count+1):=var_name;
875: var_tree_seq:=var_tree_seq+1;
876: LOG_REPORT('CZ_POPULATORS_PKG.preview','Inserting entry :'||var_name);
877:
878: INSERT INTO CZ_IMP_PS_NODES
879: (RUN_ID,
880: PS_NODE_ID,
881: PARENT_ID,
882: DEVL_PROJECT_ID,
1043: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
1044:
1045: --
1046: -- populate PS Tree :
1047: -- insert/update data from CZ_IMP_PS_NODES into CZ_PS_NODES
1048: --
1049: PROCEDURE Execute_unsec
1050: (p_populator_id IN INTEGER,
1051: p_run_id IN OUT NOCOPY INTEGER,
1105: WHERE parent_id=var_parent_id
1106: AND deleted_flag='0' AND
1107: USER_STR03 NOT IN
1108: (SELECT USER_STR03
1109: FROM CZ_IMP_PS_NODES WHERE run_id=p_run_id) AND FROM_POPULATOR_ID=p_populator_id
1110: RETURNING devl_project_id,ps_node_id,intl_text_id
1111: BULK COLLECT INTO t_devl_project,t_ps_node_id,t_intl_text_id;
1112:
1113: --
1129: WHERE intl_text_id=t_intl_text_id(i);
1130: END IF;
1131:
1132:
1133: CZ_IMP_PS_NODE.KRS_PS_NODE(p_run_id,
1134: 100,
1135: 1000,
1136: var_inserts,
1137: var_updates,
1137: var_updates,
1138: var_failed,
1139: var_dups,
1140: mXFR_PROJECT_GROUP);
1141: CZ_IMP_PS_NODE.XFR_PS_NODE(p_run_id,
1142: 100,
1143: 1000,
1144: var_inserts,
1145: var_updates,
1166: NOT IN
1167: (SELECT NVL(PROPERTY_BACKPTR,NULL_VALUE),
1168: NVL(ITEM_TYPE_BACKPTR,NULL_VALUE),NVL(ITEM_ID,NULL_VALUE),
1169: NVL(PS_NODE_TYPE,NULL_VALUE)
1170: FROM CZ_IMP_PS_NODES WHERE run_id=p_run_id) AND FROM_POPULATOR_ID=p_populator_id
1171: RETURNING devl_project_id,ps_node_id,intl_text_id
1172: BULK COLLECT INTO t_devl_project,t_ps_node_id,t_intl_text_id;
1173:
1174: --
1199:
1200: --
1201: -- general loop : --
1202: -- update PS Tree Node if there is a correlated node in CZ_PS_NODES --
1203: -- otherwise just insert from CZ_IMP_PS_NODES into CZ_PS_NODES --
1204: -- the following CZ_PS_NODES columns are used for checking : --
1205: -- FROM_POPULATOR_ID --
1206: -- PROPERTY_BACKPTR --
1207: -- ITEM_TYPE_BACKPTR --
1209: -- PS_NODE_TYPE --
1210: --
1211: FOR i IN(SELECT INTL_TEXT_ID,FROM_POPULATOR_ID,PROPERTY_BACKPTR,
1212: ITEM_TYPE_BACKPTR,ITEM_ID,PS_NODE_TYPE,FEATURE_TYPE,QUOTEABLE_FLAG,NAME
1213: FROM CZ_IMP_PS_NODES WHERE run_id=p_run_id)
1214: LOOP
1215:
1216: var_name := i.name;
1217:
1311: var_new_ps_id,
1312: INSTANTIABLE_FLAG,
1313: var_component_id,
1314: COUNTED_OPTIONS_FLAG
1315: FROM CZ_IMP_PS_NODES
1316: WHERE run_id=p_run_id AND
1317: NVL(FROM_POPULATOR_ID,NULL_VALUE)=NVL(i.FROM_POPULATOR_ID,NULL_VALUE) AND
1318: NVL(PROPERTY_BACKPTR,NULL_VALUE)=NVL(i.PROPERTY_BACKPTR,NULL_VALUE) AND
1319: NVL(ITEM_TYPE_BACKPTR,NULL_VALUE)=NVL(i.ITEM_TYPE_BACKPTR,NULL_VALUE) AND