eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_POPULATORS_PKG dependencies on CZ_PS_NODES

Line 40: mPS_NODE_SEQUENCE VARCHAR2(255) := 'CZ_PS_NODES_S';

36: mCOUNTER INTEGER:=0;
37:
38: FAILED_TO_LOCK_MODEL EXCEPTION;
39:
40: mPS_NODE_SEQUENCE VARCHAR2(255) := 'CZ_PS_NODES_S';
41: mINTL_TEXT_SEQUENCE VARCHAR2(255) := 'CZ_INTL_TEXTS_S';
42:
43: mINCREMENT NUMBER := 20;
44:

Line 141: SELECT CZ_PS_NODES_S.NEXTVAL INTO mNext_PS_Node_Id FROM dual;

137:
138: Get_Seq_Increment;
139:
140: IF p_seq_name=mPS_NODE_SEQUENCE THEN
141: SELECT CZ_PS_NODES_S.NEXTVAL INTO mNext_PS_Node_Id FROM dual;
142: mBase_PS_Node_Id:=mNext_PS_Node_Id;
143: ELSIF p_seq_name=mINTL_TEXT_SEQUENCE THEN
144: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO mNext_Text_Id FROM dual;
145: mBase_Text_Id := mNext_Text_Id;

Line 160: SELECT CZ_PS_NODES_S.nextval INTO mBase_PS_Node_Id FROM dual;

156: IF p_seq_name=mPS_NODE_SEQUENCE THEN
157: IF (mNext_PS_Node_Id < mBase_PS_Node_Id+mINCREMENT-1) THEN
158: mNext_PS_Node_Id := mNext_PS_Node_Id + 1;
159: ELSE
160: SELECT CZ_PS_NODES_S.nextval INTO mBase_PS_Node_Id FROM dual;
161: mNext_PS_Node_Id:=mBase_PS_Node_Id;
162: END IF;
163: RETURN mNext_PS_Node_Id;
164: ELSIF p_seq_name=mINTL_TEXT_SEQUENCE THEN

Line 335: var_name CZ_PS_NODES.name%TYPE;

331: var_source_type CZ_FILTER_SETS.source_type%TYPE;
332: var_rule_id CZ_FILTER_SETS.express_id%TYPE;
333: var_operator CZ_EXPRESSION_NODES.expr_subtype%TYPE;
334: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;
335: var_name CZ_PS_NODES.name%TYPE;
336: var_pop_name CZ_POPULATORS.name%TYPE;
337: var_property_id CZ_PROPERTIES.property_id%TYPE;
338: var_item_type_id CZ_ITEM_TYPES.item_type_id%TYPE;
339: var_item_id CZ_ITEM_MASTERS.item_id%TYPE;

Line 343: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

339: var_item_id CZ_ITEM_MASTERS.item_id%TYPE;
340: var_desc_text CZ_ITEM_MASTERS.desc_text%TYPE;
341: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
342: var_quoteable_flag CZ_ITEM_MASTERS.quoteable_flag%TYPE;
343: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
344: var_model_id CZ_PS_NODES.devl_project_id%TYPE;
345: var_ps_node_id CZ_POPULATORS.owned_by_node_id%TYPE;
346: var_level INTEGER;
347: var_current VARCHAR2(1);

Line 344: var_model_id CZ_PS_NODES.devl_project_id%TYPE;

340: var_desc_text CZ_ITEM_MASTERS.desc_text%TYPE;
341: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
342: var_quoteable_flag CZ_ITEM_MASTERS.quoteable_flag%TYPE;
343: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
344: var_model_id CZ_PS_NODES.devl_project_id%TYPE;
345: var_ps_node_id CZ_POPULATORS.owned_by_node_id%TYPE;
346: var_level INTEGER;
347: var_current VARCHAR2(1);
348: var_filter VARCHAR2(4000);

Line 465: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES

461: -- by calling sequirity package
462: --
463: IF mDB_SETTING_USE_SECURITY THEN
464:
465: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
466: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
467: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
468:
469: lock_Model(l_model_id, l_locked_entities_tbl);

Line 505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

501: var_pop_name CZ_POPULATORS.name%TYPE;
502: var_view_name CZ_POPULATORS.view_name%TYPE;
503: var_last_update CZ_POPULATORS.last_update_date%TYPE;
504: var_result_type CZ_POPULATORS.result_type%TYPE;
505: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
506: var_sql CZ_POPULATORS.query_syntax%TYPE;
507: var_has_level CZ_POPULATORS.has_level%TYPE;
508: var_has_item CZ_POPULATORS.has_item%TYPE;
509: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;

Line 513: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;

509: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;
510: var_has_property CZ_POPULATORS.has_property%TYPE;
511: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
512: var_express_id CZ_EXPRESSIONS.express_id%TYPE;
513: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
514: var_project_id CZ_PS_NODES.devl_project_id%TYPE;
515: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;
517: var_feature_type CZ_PS_NODES.feature_type%TYPE;

Line 514: var_project_id CZ_PS_NODES.devl_project_id%TYPE;

510: var_has_property CZ_POPULATORS.has_property%TYPE;
511: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
512: var_express_id CZ_EXPRESSIONS.express_id%TYPE;
513: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
514: var_project_id CZ_PS_NODES.devl_project_id%TYPE;
515: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;
517: var_feature_type CZ_PS_NODES.feature_type%TYPE;
518: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;

Line 515: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;

511: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
512: var_express_id CZ_EXPRESSIONS.express_id%TYPE;
513: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
514: var_project_id CZ_PS_NODES.devl_project_id%TYPE;
515: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;
517: var_feature_type CZ_PS_NODES.feature_type%TYPE;
518: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;
519: var_item_type_ptr CZ_PS_NODES.item_type_backptr%TYPE;

Line 516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;

512: var_express_id CZ_EXPRESSIONS.express_id%TYPE;
513: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
514: var_project_id CZ_PS_NODES.devl_project_id%TYPE;
515: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;
517: var_feature_type CZ_PS_NODES.feature_type%TYPE;
518: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;
519: var_item_type_ptr CZ_PS_NODES.item_type_backptr%TYPE;
520: var_name CZ_PS_NODES.name%TYPE;

Line 517: var_feature_type CZ_PS_NODES.feature_type%TYPE;

513: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
514: var_project_id CZ_PS_NODES.devl_project_id%TYPE;
515: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;
517: var_feature_type CZ_PS_NODES.feature_type%TYPE;
518: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;
519: var_item_type_ptr CZ_PS_NODES.item_type_backptr%TYPE;
520: var_name CZ_PS_NODES.name%TYPE;
521: var_desc_text CZ_ITEM_TYPES.desc_text%TYPE;

Line 518: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;

514: var_project_id CZ_PS_NODES.devl_project_id%TYPE;
515: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;
517: var_feature_type CZ_PS_NODES.feature_type%TYPE;
518: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;
519: var_item_type_ptr CZ_PS_NODES.item_type_backptr%TYPE;
520: var_name CZ_PS_NODES.name%TYPE;
521: var_desc_text CZ_ITEM_TYPES.desc_text%TYPE;
522: var_property_id CZ_PROPERTIES.property_id%TYPE;

Line 519: var_item_type_ptr CZ_PS_NODES.item_type_backptr%TYPE;

515: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;
517: var_feature_type CZ_PS_NODES.feature_type%TYPE;
518: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;
519: var_item_type_ptr CZ_PS_NODES.item_type_backptr%TYPE;
520: var_name CZ_PS_NODES.name%TYPE;
521: var_desc_text CZ_ITEM_TYPES.desc_text%TYPE;
522: var_property_id CZ_PROPERTIES.property_id%TYPE;
523: var_item_type_id CZ_ITEM_TYPES.item_type_id%TYPE;

Line 520: var_name CZ_PS_NODES.name%TYPE;

516: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;
517: var_feature_type CZ_PS_NODES.feature_type%TYPE;
518: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;
519: var_item_type_ptr CZ_PS_NODES.item_type_backptr%TYPE;
520: var_name CZ_PS_NODES.name%TYPE;
521: var_desc_text CZ_ITEM_TYPES.desc_text%TYPE;
522: var_property_id CZ_PROPERTIES.property_id%TYPE;
523: var_item_type_id CZ_ITEM_TYPES.item_type_id%TYPE;
524: var_item_id CZ_ITEM_MASTERS.item_id%TYPE;

Line 527: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;

523: var_item_type_id CZ_ITEM_TYPES.item_type_id%TYPE;
524: var_item_id CZ_ITEM_MASTERS.item_id%TYPE;
525: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
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;

Line 528: var_node_name CZ_PS_NODES.name%TYPE;

524: var_item_id CZ_ITEM_MASTERS.item_id%TYPE;
525: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
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;

Line 529: var_key CZ_PS_NODES.user_str03%TYPE;

525: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
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;

Line 531: var_instantiable_flag CZ_PS_NODES.instantiable_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;
535: var_level NUMBER;

Line 532: var_minimum CZ_PS_NODES.minimum%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;
535: var_level NUMBER;
536: var_cursor NUMBER;

Line 533: var_maximum CZ_PS_NODES.maximum%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;
535: var_level NUMBER;
536: var_cursor NUMBER;
537: var_exec NUMBER;

Line 573: rec_ps_node CZ_PS_NODES.ps_node_id%TYPE;

569: p_item_type_ptr IN INTEGER,
570: p_item_id IN INTEGER,
571: p_ps_node_type IN INTEGER
572: ) RETURN BOOLEAN IS
573: rec_ps_node CZ_PS_NODES.ps_node_id%TYPE;
574: v_found BOOLEAN;
575: CURSOR cur_ps_node IS
576: SELECT ps_node_id
577: FROM cz_ps_nodes

Line 577: FROM cz_ps_nodes

573: rec_ps_node CZ_PS_NODES.ps_node_id%TYPE;
574: v_found BOOLEAN;
575: CURSOR cur_ps_node IS
576: SELECT ps_node_id
577: FROM cz_ps_nodes
578: WHERE parent_id=p_parent_ps_node_id
579: AND from_populator_id=p_populator_id
580: AND NVL(property_backptr,NULL_VALUE)=NVL(p_property_ptr,NULL_VALUE)
581: AND NVL(item_type_backptr,NULL_VALUE)=NVL(p_item_type_ptr,NULL_VALUE)

Line 654: SELECT devl_project_id INTO var_project_id FROM CZ_PS_NODES

650:
651: --
652: -- find devl_project_id of populator's owner --
653: --
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

Line 769: FROM CZ_PS_NODES

765: --Bug6826702 : Moved code piece down
766:
767: BEGIN
768: SELECT intl_text_id INTO var_new_text_id
769: FROM CZ_PS_NODES
770: WHERE parent_id=var_ps_node_id AND
771: FROM_POPULATOR_ID=p_populator_id AND
772: NVL(PROPERTY_BACKPTR,NULL_VALUE)=NVL(var_property_ptr,NULL_VALUE) AND
773: NVL(ITEM_TYPE_BACKPTR,NULL_VALUE)=NVL(var_item_type_ptr,NULL_VALUE) AND

Line 1020: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES

1016: -- by calling sequirity package
1017: --
1018: IF mDB_SETTING_USE_SECURITY THEN
1019:
1020: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
1021: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
1022: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
1023:
1024: lock_Model(l_model_id, l_locked_entities_tbl);

Line 1047: -- insert/update data from CZ_IMP_PS_NODES into CZ_PS_NODES

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,

Line 1065: var_name CZ_PS_NODES.name%TYPE;

1061: var_dups INTEGER;
1062: var_tree_seq INTEGER;
1063: var_name_counter INTEGER;
1064: var_pop_name CZ_POPULATORS.name%TYPE;
1065: var_name CZ_PS_NODES.name%TYPE;
1066: var_view CZ_POPULATORS.view_name%TYPE;
1067: var_sql CZ_POPULATORS.query_syntax%TYPE;
1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1069: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;

Line 1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;

1064: var_pop_name CZ_POPULATORS.name%TYPE;
1065: var_name CZ_PS_NODES.name%TYPE;
1066: var_view CZ_POPULATORS.view_name%TYPE;
1067: var_sql CZ_POPULATORS.query_syntax%TYPE;
1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1069: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1070: var_component_id CZ_PS_NODES.component_id%TYPE;
1071: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;
1072: STOP_IT EXCEPTION;

Line 1069: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;

1065: var_name CZ_PS_NODES.name%TYPE;
1066: var_view CZ_POPULATORS.view_name%TYPE;
1067: var_sql CZ_POPULATORS.query_syntax%TYPE;
1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1069: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1070: var_component_id CZ_PS_NODES.component_id%TYPE;
1071: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;
1072: STOP_IT EXCEPTION;
1073:

Line 1070: var_component_id CZ_PS_NODES.component_id%TYPE;

1066: var_view CZ_POPULATORS.view_name%TYPE;
1067: var_sql CZ_POPULATORS.query_syntax%TYPE;
1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1069: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1070: var_component_id CZ_PS_NODES.component_id%TYPE;
1071: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;
1072: STOP_IT EXCEPTION;
1073:
1074: BEGIN

Line 1071: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;

1067: var_sql CZ_POPULATORS.query_syntax%TYPE;
1068: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1069: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1070: var_component_id CZ_PS_NODES.component_id%TYPE;
1071: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;
1072: STOP_IT EXCEPTION;
1073:
1074: BEGIN
1075:

Line 1096: SELECT component_id INTO var_component_id FROM CZ_PS_NODES

1092: --
1093: SELECT owned_by_node_id,name INTO var_parent_id,var_pop_name
1094: FROM CZ_POPULATORS WHERE populator_id=p_populator_id;
1095:
1096: SELECT component_id INTO var_component_id FROM CZ_PS_NODES
1097: WHERE ps_node_id=var_parent_id;
1098:
1099: IF mUSE_IMPORT IN('1','Y','YES') THEN
1100: --

Line 1104: UPDATE CZ_PS_NODES SET deleted_flag='1'

1100: --
1101: -- delete those PS Tree nodes which don't satisfy --
1102: -- a Populator condition anymore --
1103: --
1104: UPDATE CZ_PS_NODES SET deleted_flag='1'
1105: WHERE parent_id=var_parent_id
1106: AND deleted_flag='0' AND
1107: USER_STR03 NOT IN
1108: (SELECT USER_STR03

Line 1160: UPDATE CZ_PS_NODES SET deleted_flag='1'

1156: --
1157: -- delete those PS Tree nodes which don't satisfy --
1158: -- a Populator condition anymore --
1159: --
1160: UPDATE CZ_PS_NODES SET deleted_flag='1'
1161: WHERE parent_id=var_parent_id
1162: AND deleted_flag='0' AND
1163: (NVL(PROPERTY_BACKPTR,NULL_VALUE),
1164: NVL(ITEM_TYPE_BACKPTR,NULL_VALUE),NVL(ITEM_ID,NULL_VALUE),

Line 1197: SELECT NVL(MAX(tree_seq),0) INTO var_tree_seq FROM CZ_PS_NODES

1193:
1194: --
1195: -- find MAX tree_seq under ps_node_id of owner of Populator --
1196: --
1197: SELECT NVL(MAX(tree_seq),0) INTO var_tree_seq FROM CZ_PS_NODES
1198: WHERE parent_id=var_parent_id AND deleted_flag='0';
1199:
1200: --
1201: -- general loop : --

Line 1202: -- update PS Tree Node if there is a correlated node in CZ_PS_NODES --

1198: WHERE parent_id=var_parent_id AND deleted_flag='0';
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 --

Line 1203: -- otherwise just insert from CZ_IMP_PS_NODES into CZ_PS_NODES --

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 --

Line 1204: -- the following CZ_PS_NODES columns are used for checking : --

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 --
1208: -- ITEM_ID --

Line 1218: SELECT COUNT(*) INTO var_name_counter FROM CZ_PS_NODES

1214: LOOP
1215:
1216: var_name := i.name;
1217:
1218: SELECT COUNT(*) INTO var_name_counter FROM CZ_PS_NODES
1219: WHERE parent_id=var_parent_id AND deleted_flag='0' AND
1220: (name=i.name OR name like 'Copy (%) of '||i.name);
1221:
1222: IF var_name_counter>1 THEN

Line 1226: UPDATE CZ_PS_NODES

1222: IF var_name_counter>1 THEN
1223: var_name := 'Copy ('||TO_CHAR(var_name_counter+1)||') of '||i.name;
1224: END IF;
1225:
1226: UPDATE CZ_PS_NODES
1227: SET name=var_name,intl_text_id=i.intl_text_id,
1228: feature_type=i.feature_type,quoteable_flag=i.quoteable_flag
1229: WHERE parent_id=var_parent_id AND
1230: FROM_POPULATOR_ID=p_populator_id AND

Line 1243: INSERT INTO CZ_PS_NODES

1239: END IF;
1240:
1241: var_new_ps_id := get_Next_Seq_Id(mPS_NODE_SEQUENCE);
1242: var_tree_seq := var_tree_seq + 1;
1243: INSERT INTO CZ_PS_NODES
1244: (PS_NODE_ID,
1245: PARENT_ID,
1246: DEVL_PROJECT_ID,
1247: NAME,

Line 1367: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES

1363: -- by calling sequirity package
1364: --
1365: IF mDB_SETTING_USE_SECURITY THEN
1366:
1367: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
1368: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
1369: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
1370:
1371: lock_Model(l_model_id, l_locked_entities_tbl);

Line 1426: FOR i IN(SELECT populator_id FROM CZ_POPULATORS a,CZ_PS_NODES b

1422: WHEN NO_DATA_FOUND THEN
1423: RAISE MODEL_DOES_NOT_EXIST;
1424: END;
1425:
1426: FOR i IN(SELECT populator_id FROM CZ_POPULATORS a,CZ_PS_NODES b
1427: WHERE a.owned_by_node_id=b.ps_node_id AND b.devl_project_id=p_model_id AND
1428: a.deleted_flag='0' AND b.deleted_flag='0')
1429: LOOP
1430: var_counter:=var_counter+1;