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_PS_COPY dependencies on CZ_RULES

Line 63: Sequences(5).name:='CZ_RULES_S';

59: Sequences(1).name:='CZ_PS_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';

Line 1876: FOR i IN (SELECT * FROM CZ_RULES

1872: new_msg_id INTEGER;
1873:
1874: BEGIN
1875:
1876: FOR i IN (SELECT * FROM CZ_RULES
1877: WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1878: LOOP
1879: BEGIN
1880: get_Next_Val(new_id,'CZ_RULES_S');

Line 1880: get_Next_Val(new_id,'CZ_RULES_S');

1876: FOR i IN (SELECT * FROM CZ_RULES
1877: WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1878: LOOP
1879: BEGIN
1880: get_Next_Val(new_id,'CZ_RULES_S');
1881: FlowId_RULE(i.rule_id):=new_id;
1882:
1883: IF i.reason_id IS NOT NULL THEN
1884: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');

Line 1941: INSERT INTO CZ_RULES(

1937: ELSE
1938: new_rule_folder_id:=FlowId_RULE_FOLDER(i.rule_folder_id);
1939: END IF;
1940:
1941: INSERT INTO CZ_RULES(
1942: RULE_ID,
1943: SUB_CONS_ID,
1944: REASON_ID,
1945: AMOUNT_ID,

Line 2032: FOR i IN(SELECT b.* FROM CZ_RULES a,CZ_COMBO_FEATURES b

2028: new_model_ref_expl_id INTEGER;
2029:
2030: BEGIN
2031:
2032: FOR i IN(SELECT b.* FROM CZ_RULES a,CZ_COMBO_FEATURES b
2033: WHERE a.devl_project_id=OLD_PROJECT_ID AND a.rule_id=b.rule_id
2034: AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
2035: LOOP
2036: BEGIN

Line 2115: FOR i IN (SELECT b.* FROM CZ_RULES a,CZ_DES_CHART_CELLS b

2111: new_ref_id INTEGER;
2112:
2113: BEGIN
2114:
2115: FOR i IN (SELECT b.* FROM CZ_RULES a,CZ_DES_CHART_CELLS b
2116: WHERE a.devl_project_id=OLD_PROJECT_ID AND a.rule_id=b.rule_id
2117: AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
2118: LOOP
2119: BEGIN

Line 2186: FOR i IN (SELECT b.* FROM CZ_RULES a,CZ_DES_CHART_FEATURES b WHERE

2182: END;
2183:
2184: END LOOP;
2185:
2186: FOR i IN (SELECT b.* FROM CZ_RULES a,CZ_DES_CHART_FEATURES b WHERE
2187: a.devl_project_id=OLD_PROJECT_ID AND a.rule_id=b.rule_id
2188: AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
2189: LOOP
2190: BEGIN

Line 2623: UPDATE CZ_RULES SET ANTECEDENT_ID=new_id WHERE rule_id=p_rule_id;

2619:
2620: FlowId_EXPRESSION(i.express_id):=new_id;
2621:
2622: IF p_mode='ANTECEDENT_ID' THEN
2623: UPDATE CZ_RULES SET ANTECEDENT_ID=new_id WHERE rule_id=p_rule_id;
2624: END IF;
2625: IF p_mode='CONSEQUENT_ID' THEN
2626: UPDATE CZ_RULES SET CONSEQUENT_ID=new_id WHERE rule_id=p_rule_id;
2627: END IF;

Line 2626: UPDATE CZ_RULES SET CONSEQUENT_ID=new_id WHERE rule_id=p_rule_id;

2622: IF p_mode='ANTECEDENT_ID' THEN
2623: UPDATE CZ_RULES SET ANTECEDENT_ID=new_id WHERE rule_id=p_rule_id;
2624: END IF;
2625: IF p_mode='CONSEQUENT_ID' THEN
2626: UPDATE CZ_RULES SET CONSEQUENT_ID=new_id WHERE rule_id=p_rule_id;
2627: END IF;
2628: IF p_mode='AMOUNT_ID' THEN
2629: UPDATE CZ_RULES SET AMOUNT_ID=new_id WHERE rule_id=p_rule_id;
2630: END IF;

Line 2629: UPDATE CZ_RULES SET AMOUNT_ID=new_id WHERE rule_id=p_rule_id;

2625: IF p_mode='CONSEQUENT_ID' THEN
2626: UPDATE CZ_RULES SET CONSEQUENT_ID=new_id WHERE rule_id=p_rule_id;
2627: END IF;
2628: IF p_mode='AMOUNT_ID' THEN
2629: UPDATE CZ_RULES SET AMOUNT_ID=new_id WHERE rule_id=p_rule_id;
2630: END IF;
2631:
2632: END LOOP;
2633:

Line 2766: FROM CZ_RULES

2762: SELECT grid_id,devl_project_id,rule_folder_id,
2763: antecedent_id,consequent_id,amount_id
2764: INTO var_grid_id,NEW_PROJECT_ID,var_folder_id,
2765: var_antecedent_id,var_consequent_id,var_amount_id
2766: FROM CZ_RULES
2767: WHERE rule_id=p_rule_id AND deleted_flag=NO_FLAG;
2768:
2769: OLD_PROJECT_ID:=NEW_PROJECT_ID;
2770:

Line 2807: get_Next_Val(new_rule_id,'CZ_RULES_S');

2803: WHEN OTHERS THEN
2804: NULL;
2805: END;
2806:
2807: get_Next_Val(new_rule_id,'CZ_RULES_S');
2808:
2809: FOR i IN (SELECT * FROM CZ_RULES
2810: WHERE rule_id=p_rule_id AND deleted_flag=NO_FLAG)
2811: LOOP

Line 2809: FOR i IN (SELECT * FROM CZ_RULES

2805: END;
2806:
2807: get_Next_Val(new_rule_id,'CZ_RULES_S');
2808:
2809: FOR i IN (SELECT * FROM CZ_RULES
2810: WHERE rule_id=p_rule_id AND deleted_flag=NO_FLAG)
2811: LOOP
2812:
2813: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');

Line 2830: SELECT NVL(MAX(SEQ_NBR),0)+1 INTO new_SEQ_NBR FROM CZ_RULES

2826: new_RULE_FOLDER_ID:=p_rule_folder_id;
2827: new_EFFECTIVITY_SET_ID:=NULL;
2828: new_EFFECTIVE_FROM:=CZ_UTILS.EPOCH_END_;
2829: new_EFFECTIVE_UNTIL:=CZ_UTILS.EPOCH_BEGIN_;
2830: SELECT NVL(MAX(SEQ_NBR),0)+1 INTO new_SEQ_NBR FROM CZ_RULES
2831: WHERE rule_folder_id=p_rule_folder_id AND deleted_flag=NO_FLAG;
2832: ELSE
2833: new_RULE_FOLDER_ID:=i.RULE_FOLDER_ID;
2834: new_EFFECTIVITY_SET_ID:=i.EFFECTIVITY_SET_ID;

Line 2840: INSERT INTO CZ_RULES(

2836: new_EFFECTIVE_UNTIL:=i.EFFECTIVE_UNTIL;
2837: new_SEQ_NBR:=i.SEQ_NBR;
2838: END IF;
2839:
2840: INSERT INTO CZ_RULES(
2841: RULE_ID,
2842: SUB_CONS_ID,
2843: REASON_ID,
2844: AMOUNT_ID,

Line 3008: (SELECT rule_id FROM CZ_RULES WHERE devl_project_id=OLD_PROJECT_ID

3004:
3005: BEGIN
3006:
3007: FOR i IN(SELECT * FROM CZ_DES_CHART_COLUMNS WHERE rule_id IN
3008: (SELECT rule_id FROM CZ_RULES WHERE devl_project_id=OLD_PROJECT_ID
3009: AND deleted_flag=NO_FLAG) AND option_id IN
3010: (SELECT ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=OLD_PROJECT_ID
3011: AND deleted_flag=NO_FLAG))
3012: LOOP

Line 3131: FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)

3127: FROM CZ_RULE_FOLDERS WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG;
3128:
3129: PACK;
3130:
3131: FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)
3132: LOOP
3133: Copy_RULES_subschema(i.rule_id,new_rule_id, '0', NULL, '0');
3134: UPDATE CZ_RULES SET rule_folder_id=p_new_rule_seq_id
3135: WHERE rule_id=new_rule_id;

Line 3134: UPDATE CZ_RULES SET rule_folder_id=p_new_rule_seq_id

3130:
3131: FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)
3132: LOOP
3133: Copy_RULES_subschema(i.rule_id,new_rule_id, '0', NULL, '0');
3134: UPDATE CZ_RULES SET rule_folder_id=p_new_rule_seq_id
3135: WHERE rule_id=new_rule_id;
3136:
3137: PACK;
3138:

Line 3161: FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)

3157: new_rule_id INTEGER;
3158:
3159: BEGIN
3160:
3161: FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)
3162: LOOP
3163: Copy_RULES_subschema(i.rule_id,new_rule_id, '0', NULL, '0');
3164: UPDATE CZ_RULES SET rule_folder_id=p_new_rule_seq_id
3165: WHERE rule_id=new_rule_id;

Line 3164: UPDATE CZ_RULES SET rule_folder_id=p_new_rule_seq_id

3160:
3161: FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)
3162: LOOP
3163: Copy_RULES_subschema(i.rule_id,new_rule_id, '0', NULL, '0');
3164: UPDATE CZ_RULES SET rule_folder_id=p_new_rule_seq_id
3165: WHERE rule_id=new_rule_id;
3166: END LOOP;
3167:
3168: EXCEPTION