DBA Data[Home] [Help]

APPS.CZ_PS_COPY dependencies on CZ_DES_CHART_CELLS

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 2154: INSERT INTO CZ_DES_CHART_CELLS

2150: new_secondary_feature_id:=NULL;
2151: new_secondary_feat_expl_id:=NULL;
2152: END IF;
2153:
2154: INSERT INTO CZ_DES_CHART_CELLS
2155: (RULE_ID,
2156: PRIMARY_OPT_ID,
2157: SECONDARY_OPT_ID,
2158: MARK_CHAR,

Line 2650: INSERT INTO CZ_DES_CHART_CELLS

2646: p_new_rule_id IN INTEGER) IS
2647:
2648: BEGIN
2649:
2650: INSERT INTO CZ_DES_CHART_CELLS
2651: (RULE_ID,
2652: PRIMARY_OPT_ID,
2653: SECONDARY_OPT_ID,
2654: MARK_CHAR,

Line 2670: FROM CZ_DES_CHART_CELLS

2666: SECONDARY_FEATURE_ID,
2667: DELETED_FLAG,
2668: SECURITY_MASK,
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,