DBA Data[Home] [Help]

APPS.CZ_PS_COPY dependencies on CZ_GRID_DEFS

Line 67: Sequences(9).name:='CZ_GRID_DEFS_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';
68: Sequences(10).name:='CZ_GRID_COLS_S';
69: Sequences(11).name:='CZ_GRID_CELLS_S';
70: Sequences(12).name:='CZ_UI_DEFS_S';
71: Sequences(13).name:='CZ_UI_NODES_S';

Line 1196: FOR i IN (SELECT * FROM CZ_GRID_DEFS

1192: new_id INTEGER;
1193:
1194: BEGIN
1195:
1196: FOR i IN (SELECT * FROM CZ_GRID_DEFS
1197: WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1198: LOOP
1199:
1200: get_Next_Val(new_id,'CZ_GRID_DEFS_S');

Line 1200: get_Next_Val(new_id,'CZ_GRID_DEFS_S');

1196: FOR i IN (SELECT * FROM CZ_GRID_DEFS
1197: WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1198: LOOP
1199:
1200: get_Next_Val(new_id,'CZ_GRID_DEFS_S');
1201:
1202: INSERT INTO CZ_GRID_DEFS(
1203: GRID_ID,
1204: DEVL_PROJECT_ID,

Line 1202: INSERT INTO CZ_GRID_DEFS(

1198: LOOP
1199:
1200: get_Next_Val(new_id,'CZ_GRID_DEFS_S');
1201:
1202: INSERT INTO CZ_GRID_DEFS(
1203: GRID_ID,
1204: DEVL_PROJECT_ID,
1205: NAME,
1206: DESC_TEXT,

Line 2772: FOR i IN (SELECT * FROM CZ_GRID_DEFS

2768:
2769: OLD_PROJECT_ID:=NEW_PROJECT_ID;
2770:
2771: IF var_grid_id IS NOT NULL THEN
2772: FOR i IN (SELECT * FROM CZ_GRID_DEFS
2773: WHERE grid_id=var_grid_id AND deleted_flag=NO_FLAG)
2774: LOOP
2775: get_Next_Val(new_grid_id,'CZ_GRID_DEFS_S');
2776: INSERT INTO CZ_GRID_DEFS(

Line 2775: get_Next_Val(new_grid_id,'CZ_GRID_DEFS_S');

2771: IF var_grid_id IS NOT NULL THEN
2772: FOR i IN (SELECT * FROM CZ_GRID_DEFS
2773: WHERE grid_id=var_grid_id AND deleted_flag=NO_FLAG)
2774: LOOP
2775: get_Next_Val(new_grid_id,'CZ_GRID_DEFS_S');
2776: INSERT INTO CZ_GRID_DEFS(
2777: GRID_ID,
2778: DEVL_PROJECT_ID,
2779: NAME,

Line 2776: INSERT INTO CZ_GRID_DEFS(

2772: FOR i IN (SELECT * FROM CZ_GRID_DEFS
2773: WHERE grid_id=var_grid_id AND deleted_flag=NO_FLAG)
2774: LOOP
2775: get_Next_Val(new_grid_id,'CZ_GRID_DEFS_S');
2776: INSERT INTO CZ_GRID_DEFS(
2777: GRID_ID,
2778: DEVL_PROJECT_ID,
2779: NAME,
2780: DESC_TEXT,