DBA Data[Home] [Help]

APPS.CZ_PS_COPY dependencies on CZ_DES_CHART_COLUMNS

Line 3007: FOR i IN(SELECT * FROM CZ_DES_CHART_COLUMNS WHERE rule_id IN

3003: new_model_ref_expl_id INTEGER;
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))

Line 3043: INSERT INTO CZ_DES_CHART_COLUMNS

3039: WHEN NO_DATA_FOUND THEN
3040: new_model_ref_expl_id:=i.model_ref_expl_id;
3041: END;
3042:
3043: INSERT INTO CZ_DES_CHART_COLUMNS
3044: (RULE_ID,
3045: OPTION_ID,
3046: COLUMN_WIDTH,
3047: FEATURE_ID,

Line 3055: FROM CZ_DES_CHART_COLUMNS

3051: new_option_id,
3052: i.COLUMN_WIDTH,
3053: new_feature_id,
3054: new_model_ref_expl_id
3055: FROM CZ_DES_CHART_COLUMNS
3056: WHERE rule_id=i.rule_id AND option_id=i.option_id;
3057:
3058: PACK;
3059: