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 144: SELECT CZ_PS_NODES_S.NEXTVAL INTO mNext_PS_Node_Id FROM dual;

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

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

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

Line 338: var_name CZ_PS_NODES.name%TYPE;

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

Line 346: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

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

Line 347: var_model_id CZ_PS_NODES.devl_project_id%TYPE;

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

Line 468: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES

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

Line 508: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

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

Line 516: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;

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

Line 517: var_project_id CZ_PS_NODES.devl_project_id%TYPE;

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

Line 518: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;

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

Line 519: var_new_text_id CZ_PS_NODES.intl_text_id%TYPE;

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

Line 520: var_feature_type CZ_PS_NODES.feature_type%TYPE;

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

Line 521: var_property_ptr CZ_PS_NODES.property_backptr%TYPE;

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

Line 522: var_item_type_ptr CZ_PS_NODES.item_type_backptr%TYPE;

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

Line 523: var_name CZ_PS_NODES.name%TYPE;

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

Line 530: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;

526: var_item_type_id CZ_ITEM_TYPES.item_type_id%TYPE;
527: var_item_id CZ_ITEM_MASTERS.item_id%TYPE;
528: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
529: var_quoteable_flag CZ_ITEM_MASTERS.quoteable_flag%TYPE;
530: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
531: var_node_name CZ_PS_NODES.name%TYPE;
532: var_key CZ_PS_NODES.user_str03%TYPE;
533: var_fk_key CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
534: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;

Line 531: var_node_name CZ_PS_NODES.name%TYPE;

527: var_item_id CZ_ITEM_MASTERS.item_id%TYPE;
528: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
529: var_quoteable_flag CZ_ITEM_MASTERS.quoteable_flag%TYPE;
530: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
531: var_node_name CZ_PS_NODES.name%TYPE;
532: var_key CZ_PS_NODES.user_str03%TYPE;
533: var_fk_key CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
534: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;
535: var_minimum CZ_PS_NODES.minimum%TYPE;

Line 532: var_key CZ_PS_NODES.user_str03%TYPE;

528: var_primary_uom_code CZ_ITEM_MASTERS.primary_uom_code%TYPE;
529: var_quoteable_flag CZ_ITEM_MASTERS.quoteable_flag%TYPE;
530: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
531: var_node_name CZ_PS_NODES.name%TYPE;
532: var_key CZ_PS_NODES.user_str03%TYPE;
533: var_fk_key CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
534: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;
535: var_minimum CZ_PS_NODES.minimum%TYPE;
536: var_maximum CZ_PS_NODES.maximum%TYPE;

Line 534: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;

530: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
531: var_node_name CZ_PS_NODES.name%TYPE;
532: var_key CZ_PS_NODES.user_str03%TYPE;
533: var_fk_key CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
534: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;
535: var_minimum CZ_PS_NODES.minimum%TYPE;
536: var_maximum CZ_PS_NODES.maximum%TYPE;
537: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
538: var_level NUMBER;

Line 535: var_minimum CZ_PS_NODES.minimum%TYPE;

531: var_node_name CZ_PS_NODES.name%TYPE;
532: var_key CZ_PS_NODES.user_str03%TYPE;
533: var_fk_key CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
534: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;
535: var_minimum CZ_PS_NODES.minimum%TYPE;
536: var_maximum CZ_PS_NODES.maximum%TYPE;
537: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
538: var_level NUMBER;
539: var_cursor NUMBER;

Line 536: var_maximum CZ_PS_NODES.maximum%TYPE;

532: var_key CZ_PS_NODES.user_str03%TYPE;
533: var_fk_key CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
534: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;
535: var_minimum CZ_PS_NODES.minimum%TYPE;
536: var_maximum CZ_PS_NODES.maximum%TYPE;
537: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
538: var_level NUMBER;
539: var_cursor NUMBER;
540: var_exec NUMBER;

Line 577: rec_ps_node CZ_PS_NODES.ps_node_id%TYPE;

573: p_item_type_ptr IN INTEGER,
574: p_item_id IN INTEGER,
575: p_ps_node_type IN INTEGER
576: ) RETURN BOOLEAN IS
577: rec_ps_node CZ_PS_NODES.ps_node_id%TYPE;
578: v_found BOOLEAN;
579: CURSOR cur_ps_node IS
580: SELECT ps_node_id
581: FROM cz_ps_nodes

Line 581: FROM cz_ps_nodes

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

Line 658: SELECT devl_project_id INTO var_project_id FROM CZ_PS_NODES

654:
655: --
656: -- find devl_project_id of populator's owner --
657: --
658: SELECT devl_project_id INTO var_project_id FROM CZ_PS_NODES
659: WHERE ps_node_id=var_ps_node_id;
660:
661: --
662: -- Allocate run_id for CZ_IMP_PS_NODES

Line 773: FROM CZ_PS_NODES

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

Line 1031: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES

1027: -- by calling sequirity package
1028: --
1029: IF mDB_SETTING_USE_SECURITY THEN
1030:
1031: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
1032: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
1033: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
1034:
1035: lock_Model(l_model_id, l_locked_entities_tbl);

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

1054: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
1055:
1056: --
1057: -- populate PS Tree :
1058: -- insert/update data from CZ_IMP_PS_NODES into CZ_PS_NODES
1059: --
1060: PROCEDURE Execute_unsec
1061: (p_populator_id IN INTEGER,
1062: p_run_id IN OUT NOCOPY INTEGER,

Line 1077: var_name CZ_PS_NODES.name%TYPE;

1073: var_nochange INTEGER;/*Meant for nochange in disposition*/
1074: var_tree_seq INTEGER;
1075: var_name_counter INTEGER;
1076: var_pop_name CZ_POPULATORS.name%TYPE;
1077: var_name CZ_PS_NODES.name%TYPE;
1078: var_view CZ_POPULATORS.view_name%TYPE;
1079: var_sql CZ_POPULATORS.query_syntax%TYPE;
1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1081: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;

Line 1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;

1076: var_pop_name CZ_POPULATORS.name%TYPE;
1077: var_name CZ_PS_NODES.name%TYPE;
1078: var_view CZ_POPULATORS.view_name%TYPE;
1079: var_sql CZ_POPULATORS.query_syntax%TYPE;
1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1081: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1082: var_component_id CZ_PS_NODES.component_id%TYPE;
1083: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;
1084: STOP_IT EXCEPTION;

Line 1081: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;

1077: var_name CZ_PS_NODES.name%TYPE;
1078: var_view CZ_POPULATORS.view_name%TYPE;
1079: var_sql CZ_POPULATORS.query_syntax%TYPE;
1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1081: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1082: var_component_id CZ_PS_NODES.component_id%TYPE;
1083: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;
1084: STOP_IT EXCEPTION;
1085:

Line 1082: var_component_id CZ_PS_NODES.component_id%TYPE;

1078: var_view CZ_POPULATORS.view_name%TYPE;
1079: var_sql CZ_POPULATORS.query_syntax%TYPE;
1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1081: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1082: var_component_id CZ_PS_NODES.component_id%TYPE;
1083: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;
1084: STOP_IT EXCEPTION;
1085:
1086: BEGIN

Line 1083: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;

1079: var_sql CZ_POPULATORS.query_syntax%TYPE;
1080: var_devl_project_id CZ_PS_NODES.devl_project_id%TYPE;
1081: var_parent_id CZ_PS_NODES.ps_node_id%TYPE;
1082: var_component_id CZ_PS_NODES.component_id%TYPE;
1083: var_new_ps_id CZ_PS_NODES.ps_node_id%TYPE;
1084: STOP_IT EXCEPTION;
1085:
1086: BEGIN
1087:

Line 1108: SELECT component_id INTO var_component_id FROM CZ_PS_NODES

1104: --
1105: SELECT owned_by_node_id,name INTO var_parent_id,var_pop_name
1106: FROM CZ_POPULATORS WHERE populator_id=p_populator_id;
1107:
1108: SELECT component_id INTO var_component_id FROM CZ_PS_NODES
1109: WHERE ps_node_id=var_parent_id;
1110:
1111: IF mUSE_IMPORT IN('1','Y','YES') THEN
1112: --

Line 1116: UPDATE CZ_PS_NODES SET deleted_flag='1'

1112: --
1113: -- delete those PS Tree nodes which don't satisfy --
1114: -- a Populator condition anymore --
1115: --
1116: UPDATE CZ_PS_NODES SET deleted_flag='1'
1117: WHERE parent_id=var_parent_id
1118: AND deleted_flag='0' AND
1119: USER_STR03 NOT IN
1120: (SELECT USER_STR03

Line 1174: UPDATE CZ_PS_NODES SET deleted_flag='1'

1170: --
1171: -- delete those PS Tree nodes which don't satisfy --
1172: -- a Populator condition anymore --
1173: --
1174: UPDATE CZ_PS_NODES SET deleted_flag='1'
1175: WHERE parent_id=var_parent_id
1176: AND deleted_flag='0' AND
1177: (NVL(PROPERTY_BACKPTR,NULL_VALUE),
1178: NVL(ITEM_TYPE_BACKPTR,NULL_VALUE),NVL(ITEM_ID,NULL_VALUE),

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

1207:
1208: --
1209: -- find MAX tree_seq under ps_node_id of owner of Populator --
1210: --
1211: SELECT NVL(MAX(tree_seq),0) INTO var_tree_seq FROM CZ_PS_NODES
1212: WHERE parent_id=var_parent_id AND deleted_flag='0';
1213:
1214: --
1215: -- general loop : --

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

1212: WHERE parent_id=var_parent_id AND deleted_flag='0';
1213:
1214: --
1215: -- general loop : --
1216: -- update PS Tree Node if there is a correlated node in CZ_PS_NODES --
1217: -- otherwise just insert from CZ_IMP_PS_NODES into CZ_PS_NODES --
1218: -- the following CZ_PS_NODES columns are used for checking : --
1219: -- FROM_POPULATOR_ID --
1220: -- PROPERTY_BACKPTR --

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

1213:
1214: --
1215: -- general loop : --
1216: -- update PS Tree Node if there is a correlated node in CZ_PS_NODES --
1217: -- otherwise just insert from CZ_IMP_PS_NODES into CZ_PS_NODES --
1218: -- the following CZ_PS_NODES columns are used for checking : --
1219: -- FROM_POPULATOR_ID --
1220: -- PROPERTY_BACKPTR --
1221: -- ITEM_TYPE_BACKPTR --

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

1214: --
1215: -- general loop : --
1216: -- update PS Tree Node if there is a correlated node in CZ_PS_NODES --
1217: -- otherwise just insert from CZ_IMP_PS_NODES into CZ_PS_NODES --
1218: -- the following CZ_PS_NODES columns are used for checking : --
1219: -- FROM_POPULATOR_ID --
1220: -- PROPERTY_BACKPTR --
1221: -- ITEM_TYPE_BACKPTR --
1222: -- ITEM_ID --

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

1228: LOOP
1229:
1230: var_name := i.name;
1231:
1232: SELECT COUNT(*) INTO var_name_counter FROM CZ_PS_NODES
1233: WHERE parent_id=var_parent_id AND deleted_flag='0' AND
1234: (name=i.name OR name like 'Copy (%) of '||i.name);
1235:
1236: IF var_name_counter>1 THEN

Line 1240: UPDATE CZ_PS_NODES

1236: IF var_name_counter>1 THEN
1237: var_name := 'Copy ('||TO_CHAR(var_name_counter+1)||') of '||i.name;
1238: END IF;
1239:
1240: UPDATE CZ_PS_NODES
1241: SET name=var_name,intl_text_id=i.intl_text_id,
1242: feature_type=i.feature_type,quoteable_flag=i.quoteable_flag
1243: WHERE parent_id=var_parent_id AND
1244: FROM_POPULATOR_ID=p_populator_id AND

Line 1257: INSERT INTO CZ_PS_NODES

1253: END IF;
1254:
1255: var_new_ps_id := get_Next_Seq_Id(mPS_NODE_SEQUENCE);
1256: var_tree_seq := var_tree_seq + 1;
1257: INSERT INTO CZ_PS_NODES
1258: (PS_NODE_ID,
1259: PARENT_ID,
1260: DEVL_PROJECT_ID,
1261: NAME,

Line 1393: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES

1389: -- by calling sequirity package
1390: --
1391: IF mDB_SETTING_USE_SECURITY THEN
1392:
1393: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
1394: WHERE ps_node_id IN(SELECT owned_by_node_id FROM CZ_POPULATORS
1395: WHERE populator_id=p_populator_id) AND deleted_flag='0' AND rownum<2;
1396:
1397: lock_Model(l_model_id, l_locked_entities_tbl);

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

1448: WHEN NO_DATA_FOUND THEN
1449: RAISE MODEL_DOES_NOT_EXIST;
1450: END;
1451:
1452: FOR i IN(SELECT populator_id FROM CZ_POPULATORS a,CZ_PS_NODES b
1453: WHERE a.owned_by_node_id=b.ps_node_id AND b.devl_project_id=p_model_id AND
1454: a.deleted_flag='0' AND b.deleted_flag='0')
1455: LOOP
1456: var_counter:=var_counter+1;