APPS.CZ_PS_COPY dependencies on CZ_COMBO_FEATURES

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 2064: INSERT INTO CZ_COMBO_FEATURES

2060: ELSE
2061: new_model_ref_expl_id:=NULL;
2062: END IF;
2063:
2064: INSERT INTO CZ_COMBO_FEATURES
2065: (FEATURE_ID,
2066: GRID_COL_ID,
2067: RULE_ID,
2068: COL_TYPE,

Line 2927: FOR i IN (SELECT * FROM CZ_COMBO_FEATURES

2923: PACK;
2924:
2925: END LOOP;
2926:
2927: FOR i IN (SELECT * FROM CZ_COMBO_FEATURES
2928: WHERE rule_id=p_rule_id AND deleted_flag=NO_FLAG)
2929: LOOP
2930: IF i.grid_col_id IS NOT NULL THEN
2931: new_grid_col_id:=FlowId_GRID_COL(i.grid_col_id);

Line 2935: INSERT INTO CZ_COMBO_FEATURES

2931: new_grid_col_id:=FlowId_GRID_COL(i.grid_col_id);
2932: ELSE
2933: new_grid_col_id:=NULL;
2934: END IF;
2935: INSERT INTO CZ_COMBO_FEATURES
2936: (FEATURE_ID,
2937: GRID_COL_ID,
2938: RULE_ID,
2939: COL_TYPE,