DBA Data[Home] [Help]

APPS.CZ_PS_COPY dependencies on CZ_DES_CHART_FEATURES

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 2208: INSERT INTO CZ_DES_CHART_FEATURES

2204: WHEN NO_DATA_FOUND THEN
2205: new_ref_id:=i.model_ref_expl_id;
2206: END;
2207:
2208: INSERT INTO CZ_DES_CHART_FEATURES
2209: (RULE_ID,
2210: FEATURE_ID,
2211: FEATURE_TYPE ,
2212: MODEL_REF_EXPL_ID,

Line 2673: INSERT INTO CZ_DES_CHART_FEATURES

2669: CHECKOUT_USER
2670: FROM CZ_DES_CHART_CELLS
2671: WHERE rule_id=p_old_rule_id AND deleted_flag=NO_FLAG;
2672:
2673: INSERT INTO CZ_DES_CHART_FEATURES
2674: (RULE_ID,
2675: FEATURE_ID,
2676: FEATURE_TYPE ,
2677: MODEL_REF_EXPL_ID,

Line 2689: FROM CZ_DES_CHART_FEATURES

2685: MODEL_REF_EXPL_ID,
2686: DELETED_FLAG,
2687: SECURITY_MASK,
2688: CHECKOUT_USER
2689: FROM CZ_DES_CHART_FEATURES
2690: WHERE rule_id=p_old_rule_id AND deleted_flag=NO_FLAG;
2691:
2692: PACK;
2693: