APPS.CZ_PS_COPY dependencies on CZ_EXPRESSION_NODES

Line 64: Sequences(6).name:='CZ_EXPRESSION_NODES_S';

60: Sequences(2).name:='CZ_FILTER_SETS_S';
61: Sequences(3).name:='CZ_SUB_CON_SETS_S';
62: Sequences(4).name:='CZ_EXPRESSIONS_S';
63: Sequences(5).name:='CZ_RULES_S';
64: Sequences(6).name:='CZ_EXPRESSION_NODES_S';
65: Sequences(7).name:='CZ_POPULATORS_S';
66: Sequences(8).name:='CZ_RULE_FOLDERS_S';
67: Sequences(9).name:='CZ_GRID_DEFS_S';
68: Sequences(10).name:='CZ_GRID_COLS_S';

Line 1026: FOR i IN (SELECT expr_node_id FROM CZ_EXPRESSION_NODES

1022:
1023: ind:=FlowId_EXPRESSION.First;
1024: LOOP
1025: BEGIN
1026: FOR i IN (SELECT expr_node_id FROM CZ_EXPRESSION_NODES
1027: WHERE express_id=ind AND deleted_flag=NO_FLAG
1028: ORDER BY expr_node_id)
1029: LOOP
1030: get_Next_Val(new_id,'CZ_EXPRESSION_NODES_S');

Line 1030: get_Next_Val(new_id,'CZ_EXPRESSION_NODES_S');

1026: FOR i IN (SELECT expr_node_id FROM CZ_EXPRESSION_NODES
1027: WHERE express_id=ind AND deleted_flag=NO_FLAG
1028: ORDER BY expr_node_id)
1029: LOOP
1030: get_Next_Val(new_id,'CZ_EXPRESSION_NODES_S');
1031: FlowId_EXPRESSION_NODE(i.expr_node_id):=new_id;
1032: END LOOP;
1033:
1034: FOR i IN (SELECT * FROM CZ_EXPRESSION_NODES

Line 1034: FOR i IN (SELECT * FROM CZ_EXPRESSION_NODES

1030: get_Next_Val(new_id,'CZ_EXPRESSION_NODES_S');
1031: FlowId_EXPRESSION_NODE(i.expr_node_id):=new_id;
1032: END LOOP;
1033:
1034: FOR i IN (SELECT * FROM CZ_EXPRESSION_NODES
1035: WHERE express_id=ind AND deleted_flag=NO_FLAG
1036: ORDER BY expr_node_id)
1037: LOOP
1038: BEGIN

Line 1081: INSERT INTO CZ_EXPRESSION_NODES(

1077: new_model_ref_expl_id:=NULL;
1078: END IF;
1079:
1080: new_child:=FlowId_EXPRESSION_NODE(i.expr_node_id);
1081: INSERT INTO CZ_EXPRESSION_NODES(
1082: EXPR_NODE_ID,
1083: EXPRESS_ID,
1084: SEQ_NBR,
1085: ITEM_TYPE_ID,