eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_AC_OPS dependencies on ZPB_ANALYSIS_CYCLES

Line 30: ZPB_ANALYSIS_CYCLES zac,

26: --Cursor modified for missing objects
27: CURSOR c_active_instance IS
28: SELECT zaci.instance_ac_id, zac.current_instance_id, t.wf_process_name, t.item_key, t.task_id
29: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
30: ZPB_ANALYSIS_CYCLES zac,
31: zpb_analysis_cycle_tasks t,
32: ZPB_ANALYSIS_CYCLES publishedac
33: WHERE publishedac.analysis_cycle_id = p_acid and
34: publishedac.current_instance_id=zac.current_instance_id and

Line 32: ZPB_ANALYSIS_CYCLES publishedac

28: SELECT zaci.instance_ac_id, zac.current_instance_id, t.wf_process_name, t.item_key, t.task_id
29: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
30: ZPB_ANALYSIS_CYCLES zac,
31: zpb_analysis_cycle_tasks t,
32: ZPB_ANALYSIS_CYCLES publishedac
33: WHERE publishedac.analysis_cycle_id = p_acid and
34: publishedac.current_instance_id=zac.current_instance_id and
35: zaci.instance_ac_id = zac.analysis_cycle_id and
36: zac.status_code NOT in('COMPLETE', 'COMPLETE_WITH_WARNING', 'ERROR')

Line 51: from ZPB_ANALYSIS_CYCLES

47:
48: -- abudnik 07DEC2005 BUSINESS AREA ID to call for ZPB_WF_DELAWINST
49: select BUSINESS_AREA_ID
50: into l_business_area_id
51: from ZPB_ANALYSIS_CYCLES
52: where ANALYSIS_CYCLE_ID = p_acid;
53:
54:
55: for v_active_instance in c_active_instance loop

Line 135: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

131:
132:
133:
134: PROCEDURE copy_ac_table_rec (
135: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
136: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
137: IS
138: BEGIN
139:

Line 136: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

132:
133:
134: PROCEDURE copy_ac_table_rec (
135: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
136: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
137: IS
138: BEGIN
139:
140: --if the calling procedure is publish_cycle, then

Line 142: INSERT INTO zpb_analysis_cycles

138: BEGIN
139:
140: --if the calling procedure is publish_cycle, then
141: --transfer the ownership to the Current User
142: INSERT INTO zpb_analysis_cycles
143: (ANALYSIS_CYCLE_ID,
144: STATUS_CODE,
145: NAME,
146: DESCRIPTION,

Line 177: FROM zpb_analysis_cycles

173: SYSDATE,
174: fnd_global.USER_ID,
175: SYSDATE,
176: fnd_global.LOGIN_ID
177: FROM zpb_analysis_cycles
178: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
179:
180: END copy_ac_table_rec;
181:

Line 184: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

180: END copy_ac_table_rec;
181:
182:
183: PROCEDURE copy_ac_param_values_recs (
184: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
185: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
186: IS
187: BEGIN
188: INSERT INTO zpb_ac_param_values

Line 185: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

181:
182:
183: PROCEDURE copy_ac_param_values_recs (
184: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
185: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
186: IS
187: BEGIN
188: INSERT INTO zpb_ac_param_values
189: (ANALYSIS_CYCLE_ID,

Line 260: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

256:
257: END copy_external_user_recs;
258:
259: PROCEDURE copy_cycle_datasets_recs (
260: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
261: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
262: IS
263: BEGIN
264: INSERT INTO zpb_cycle_datasets

Line 261: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

257: END copy_external_user_recs;
258:
259: PROCEDURE copy_cycle_datasets_recs (
260: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
261: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
262: IS
263: BEGIN
264: INSERT INTO zpb_cycle_datasets
265: (ANALYSIS_CYCLE_ID,

Line 289: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

285:
286:
287:
288: PROCEDURE copy_cycle_model_dim_recs (
289: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
290: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
291: IS
292: BEGIN
293: INSERT INTO zpb_cycle_model_dimensions

Line 290: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

286:
287:
288: PROCEDURE copy_cycle_model_dim_recs (
289: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
290: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
291: IS
292: BEGIN
293: INSERT INTO zpb_cycle_model_dimensions
294: (ANALYSIS_CYCLE_ID,

Line 329: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE ,

325: END copy_cycle_model_dim_recs;
326:
327: -- Bug 4587184: Add source_task_id and target_task_id to the signature
328: PROCEDURE copy_bp_measure_scope_recs (
329: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE ,
330: source_task_id IN zpb_measure_scope_exempt_users.task_id%TYPE,
331: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE ,
332: target_task_id IN zpb_measure_scope_exempt_users.task_id%TYPE)
333: IS

Line 331: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE ,

327: -- Bug 4587184: Add source_task_id and target_task_id to the signature
328: PROCEDURE copy_bp_measure_scope_recs (
329: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE ,
330: source_task_id IN zpb_measure_scope_exempt_users.task_id%TYPE,
331: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE ,
332: target_task_id IN zpb_measure_scope_exempt_users.task_id%TYPE)
333: IS
334: BEGIN
335:

Line 367: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

363: END copy_bp_measure_scope_recs;
364:
365: -- Bug 4587184: Add source_task_id and target_task_id to the signature
366: PROCEDURE copy_bp_scope_access_recs (
367: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
368: source_task_id IN zpb_business_process_scope.task_id%TYPE ,
369: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
370: target_task_id IN zpb_business_process_scope.task_id%TYPE )
371: IS

Line 369: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

365: -- Bug 4587184: Add source_task_id and target_task_id to the signature
366: PROCEDURE copy_bp_scope_access_recs (
367: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
368: source_task_id IN zpb_business_process_scope.task_id%TYPE ,
369: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
370: target_task_id IN zpb_business_process_scope.task_id%TYPE )
371: IS
372:
373: BEGIN

Line 421: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

417:
418: END copy_bp_scope_access_recs;
419:
420: PROCEDURE copy_cycle_comments_recs (
421: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
422: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
423: IS
424: BEGIN
425: INSERT INTO zpb_cycle_comments

Line 422: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

418: END copy_bp_scope_access_recs;
419:
420: PROCEDURE copy_cycle_comments_recs (
421: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
422: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
423: IS
424: BEGIN
425: INSERT INTO zpb_cycle_comments
426: (COMMENT_ID,

Line 485: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

481: END copy_task_param_recs;
482:
483:
484: PROCEDURE copy_ac_task_recs (
485: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
486: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
487: is_anal_excep_copied IN boolean default true)
488: IS
489: CURSOR ac_task_cur IS

Line 486: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

482:
483:
484: PROCEDURE copy_ac_task_recs (
485: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
486: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
487: is_anal_excep_copied IN boolean default true)
488: IS
489: CURSOR ac_task_cur IS
490: SELECT *

Line 590: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

586:
587: END copy_ac_task_recs;
588:
589: PROCEDURE copy_solve_member_defs_recs (
590: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
591: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
592: IS
593: BEGIN
594:

Line 591: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

587: END copy_ac_task_recs;
588:
589: PROCEDURE copy_solve_member_defs_recs (
590: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
591: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
592: IS
593: BEGIN
594:
595: INSERT INTO zpb_solve_member_defs

Line 636: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

632: END copy_solve_member_defs_recs;
633:
634:
635: PROCEDURE copy_copy_dim_members_recs (
636: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
637: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
638: IS
639: BEGIN
640:

Line 637: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

633:
634:
635: PROCEDURE copy_copy_dim_members_recs (
636: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
637: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
638: IS
639: BEGIN
640:
641: INSERT INTO zpb_copy_dim_members

Line 670: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

666:
667: END copy_copy_dim_members_recs;
668:
669: PROCEDURE copy_data_init_defs_recs (
670: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
671: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
672: IS
673: BEGIN
674:

Line 671: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

667: END copy_copy_dim_members_recs;
668:
669: PROCEDURE copy_data_init_defs_recs (
670: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
671: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
672: IS
673: BEGIN
674:
675: /* Bug#5092815, Added propagated_flag */

Line 717: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

713: END copy_data_init_defs_recs;
714:
715:
716: PROCEDURE copy_solve_input_level_recs (
717: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
718: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
719: IS
720: BEGIN
721: INSERT INTO zpb_solve_input_selections

Line 718: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

714:
715:
716: PROCEDURE copy_solve_input_level_recs (
717: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
718: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
719: IS
720: BEGIN
721: INSERT INTO zpb_solve_input_selections
722: (ANALYSIS_CYCLE_ID,

Line 755: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

751: END copy_solve_input_level_recs;
752:
753:
754: PROCEDURE copy_solve_output_level_recs (
755: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
756: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
757: IS
758: BEGIN
759:

Line 756: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

752:
753:
754: PROCEDURE copy_solve_output_level_recs (
755: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
756: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
757: IS
758: BEGIN
759:
760: INSERT INTO zpb_solve_output_selections

Line 796: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

792: END copy_solve_output_level_recs;
793:
794:
795: PROCEDURE copy_solve_alloc_defs_recs (
796: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
797: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
798: IS
799: BEGIN
800:

Line 797: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

793:
794:
795: PROCEDURE copy_solve_alloc_defs_recs (
796: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
797: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
798: IS
799: BEGIN
800:
801: INSERT INTO zpb_solve_allocation_defs

Line 839: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

835:
836: END copy_solve_alloc_defs_recs;
837:
838: PROCEDURE copy_line_dimensionality_recs (
839: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
840: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
841: IS
842: BEGIN
843:

Line 840: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

836: END copy_solve_alloc_defs_recs;
837:
838: PROCEDURE copy_line_dimensionality_recs (
839: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
840: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
841: IS
842: BEGIN
843:
844: INSERT INTO zpb_line_dimensionality

Line 883: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

879:
880: END copy_line_dimensionality_recs;
881:
882: PROCEDURE copy_solve_hier_order_recs (
883: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
884: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
885: IS
886: BEGIN
887: INSERT INTO zpb_solve_hier_order

Line 884: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

880: END copy_line_dimensionality_recs;
881:
882: PROCEDURE copy_solve_hier_order_recs (
883: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
884: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
885: IS
886: BEGIN
887: INSERT INTO zpb_solve_hier_order
888: (solve_hier_order_id,

Line 919: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

915:
916: END copy_solve_hier_order_recs;
917:
918: PROCEDURE create_ac_copy (
919: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
920: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
921: is_comments_copied IN boolean default true,
922: is_anal_excep_copied IN boolean default true)
923: IS

Line 920: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

916: END copy_solve_hier_order_recs;
917:
918: PROCEDURE create_ac_copy (
919: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
920: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
921: is_comments_copied IN boolean default true,
922: is_anal_excep_copied IN boolean default true)
923: IS
924: BEGIN

Line 956: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

952: * This internal procedure copes only those tasks that have not yet started in
953: * instance target_ac_id_in. This is used when republishing a cycle
954: */
955: PROCEDURE copy_nonstarted_tasks (
956: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
957: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
958: IS
959:
960: -- cursor ac_task_cur contains all tasks from source_ac_id_in whose

Line 957: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

953: * instance target_ac_id_in. This is used when republishing a cycle
954: */
955: PROCEDURE copy_nonstarted_tasks (
956: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
957: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
958: IS
959:
960: -- cursor ac_task_cur contains all tasks from source_ac_id_in whose
961: -- corresponding tasks in target_ac_id_in have not yet started

Line 1087: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1083:
1084: /*
1085: * Public */
1086: PROCEDURE delete_ac (
1087: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1088: delete_tasks IN VARCHAR2 default FND_API.G_TRUE)
1089: IS
1090: CURSOR ac_task_cur IS
1091: SELECT *

Line 1174: DELETE FROM zpb_analysis_cycles

1170:
1171: DELETE FROM zpb_cycle_datasets
1172: WHERE analysis_cycle_id = ac_id_in;
1173:
1174: DELETE FROM zpb_analysis_cycles
1175: WHERE analysis_cycle_id = ac_id_in;
1176:
1177: DELETE FROM zpb_solve_member_defs
1178: WHERE analysis_cycle_id = ac_id_in;

Line 1220: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1216: api has cursor previous_instance_cur that does not confirm to
1217: missing obj changes */
1218:
1219: PROCEDURE delete_published_ac (
1220: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1221: prev_instance_options_in IN VARCHAR2,
1222: curr_instance_options_in IN VARCHAR2)
1223: IS
1224: CURSOR previous_instance_cur IS

Line 1227: zpb_analysis_cycles zac

1223: IS
1224: CURSOR previous_instance_cur IS
1225: SELECT zaci.instance_ac_id
1226: FROM zpb_analysis_cycle_instances zaci,
1227: zpb_analysis_cycles zac
1228: WHERE zaci.analysis_cycle_id = ac_id_in and
1229: zac.analysis_cycle_id = zaci.analysis_cycle_id and
1230: zaci.instance_ac_id <> zac.current_instance_id;
1231:

Line 1232: curr_instance_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1228: WHERE zaci.analysis_cycle_id = ac_id_in and
1229: zac.analysis_cycle_id = zaci.analysis_cycle_id and
1230: zaci.instance_ac_id <> zac.current_instance_id;
1231:
1232: curr_instance_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1233: l_count NUMBER;
1234: BEGIN
1235:
1236: IF prev_instance_options_in = 'DELETE_PREVIOUS_INSTANCE' THEN

Line 1248: FROM zpb_analysis_cycles

1244:
1245: IF curr_instance_options_in = 'DELETE_CURR_INSTANCE' THEN
1246: SELECT current_instance_id
1247: INTO curr_instance_ac_id
1248: FROM zpb_analysis_cycles
1249: WHERE analysis_cycle_id = ac_id_in;
1250:
1251: --DELETE FROM zpb_current_instances
1252: -- WHERE current_instance_ac_id = curr_instance_ac_id;

Line 1277: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1273:
1274: END delete_published_ac;
1275:
1276: PROCEDURE getEditableCopyID (
1277: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1278: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1279: IS
1280: return_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1281: BEGIN

Line 1278: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

1274: END delete_published_ac;
1275:
1276: PROCEDURE getEditableCopyID (
1277: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1278: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1279: IS
1280: return_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1281: BEGIN
1282:

Line 1280: return_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1276: PROCEDURE getEditableCopyID (
1277: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1278: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1279: IS
1280: return_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1281: BEGIN
1282:
1283: SELECT editable_ac_id
1284: INTO return_ac_id

Line 1293: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1289:
1290: END getEditableCopyID;
1291:
1292: PROCEDURE recoverCycleObjects (
1293: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1294: is_published_out OUT NOCOPY VARCHAR2)
1295: IS
1296: published_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1297: BEGIN

Line 1296: published_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1292: PROCEDURE recoverCycleObjects (
1293: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1294: is_published_out OUT NOCOPY VARCHAR2)
1295: IS
1296: published_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1297: BEGIN
1298:
1299: is_published_out := 'N';
1300: getPubIdFromEditId(editable_ac_id_in, published_ac_id);

Line 1310: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1306:
1307: END recoverCycleObjects;
1308:
1309: PROCEDURE getPubIdFromEditId (
1310: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1311: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1312: IS
1313: return_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1314: BEGIN

Line 1311: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

1307: END recoverCycleObjects;
1308:
1309: PROCEDURE getPubIdFromEditId (
1310: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1311: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1312: IS
1313: return_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1314: BEGIN
1315:

Line 1313: return_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1309: PROCEDURE getPubIdFromEditId (
1310: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1311: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1312: IS
1313: return_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1314: BEGIN
1315:
1316: SELECT published_ac_id
1317: INTO return_ac_id

Line 1329: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1325: /* This procedure copies the defintion of an existing Business Process
1326: to a new business process.
1327: */
1328: procedure create_duplicate_copy (
1329: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1330: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1331: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1332: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
1333: is_comments_copied IN VARCHAR2 default 'true',

Line 1330: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,

1326: to a new business process.
1327: */
1328: procedure create_duplicate_copy (
1329: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1330: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1331: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1332: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
1333: is_comments_copied IN VARCHAR2 default 'true',
1334: is_analy_excep_copied IN VARCHAR2 default 'true',

Line 1331: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,

1327: */
1328: procedure create_duplicate_copy (
1329: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1330: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1331: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1332: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
1333: is_comments_copied IN VARCHAR2 default 'true',
1334: is_analy_excep_copied IN VARCHAR2 default 'true',
1335: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

Line 1332: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,

1328: procedure create_duplicate_copy (
1329: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1330: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1331: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1332: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
1333: is_comments_copied IN VARCHAR2 default 'true',
1334: is_analy_excep_copied IN VARCHAR2 default 'true',
1335: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1336:

Line 1335: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

1331: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1332: ac_business_area_in IN zpb_analysis_cycles.business_area_id%TYPE,
1333: is_comments_copied IN VARCHAR2 default 'true',
1334: is_analy_excep_copied IN VARCHAR2 default 'true',
1335: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1336:
1337: IS
1338: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1339: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

Line 1338: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1334: is_analy_excep_copied IN VARCHAR2 default 'true',
1335: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1336:
1337: IS
1338: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1339: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1340: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1341: pet_rec zpb_cycle_relationships%ROWTYPE;
1342: ac_rec zpb_analysis_cycles%ROWTYPE;

Line 1339: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1335: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1336:
1337: IS
1338: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1339: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1340: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1341: pet_rec zpb_cycle_relationships%ROWTYPE;
1342: ac_rec zpb_analysis_cycles%ROWTYPE;
1343:

Line 1342: ac_rec zpb_analysis_cycles%ROWTYPE;

1338: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1339: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1340: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1341: pet_rec zpb_cycle_relationships%ROWTYPE;
1342: ac_rec zpb_analysis_cycles%ROWTYPE;
1343:
1344: comments boolean := true;
1345: analy_excep boolean := true;
1346:

Line 1359: UPDATE zpb_analysis_cycles

1355: create_ac_copy(published_ac_id_in, new_ac_id,comments,analy_excep);
1356:
1357: -- Bug 5173164: Added current_instance_id, owner_id also
1358: -- in the below given update statement
1359: UPDATE zpb_analysis_cycles
1360: SET name = editable_ac_name_in,
1361: status_code = 'DISABLE_ASAP',
1362: validate_status = 'INVALID',
1363: locked_by = 1,

Line 1405: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1401:
1402: end create_duplicate_copy;
1403:
1404: PROCEDURE create_editable_copy (
1405: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1406: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1407: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1408: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1409: IS

Line 1406: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,

1402: end create_duplicate_copy;
1403:
1404: PROCEDURE create_editable_copy (
1405: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1406: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1407: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1408: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1409: IS
1410: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

Line 1407: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,

1403:
1404: PROCEDURE create_editable_copy (
1405: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1406: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1407: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1408: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1409: IS
1410: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1411: pet_row_rec zpb_cycle_relationships%ROWTYPE;

Line 1408: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

1404: PROCEDURE create_editable_copy (
1405: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1406: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1407: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1408: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1409: IS
1410: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1411: pet_row_rec zpb_cycle_relationships%ROWTYPE;
1412: BEGIN

Line 1410: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1406: editable_ac_name_in IN zpb_analysis_cycles.name%TYPE,
1407: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1408: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1409: IS
1410: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1411: pet_row_rec zpb_cycle_relationships%ROWTYPE;
1412: BEGIN
1413: SELECT *
1414: INTO pet_row_rec

Line 1422: UPDATE zpb_analysis_cycles

1418: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1419:
1420: create_ac_copy(published_ac_id_in, new_ac_id);
1421:
1422: UPDATE zpb_analysis_cycles
1423: SET name = editable_ac_name_in,
1424: status_code = 'DISABLE_ASAP',
1425: published_date = NULL,
1426: published_by = NULL,

Line 1445: ac_name_in IN zpb_analysis_cycles.name%TYPE,

1441: END create_editable_copy;
1442:
1443:
1444: PROCEDURE create_new_cycle (
1445: ac_name_in IN zpb_analysis_cycles.name%TYPE,
1446: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,
1447: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
1448: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1449: IS

Line 1446: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,

1442:
1443:
1444: PROCEDURE create_new_cycle (
1445: ac_name_in IN zpb_analysis_cycles.name%TYPE,
1446: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,
1447: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
1448: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1449: IS
1450: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

Line 1448: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

1444: PROCEDURE create_new_cycle (
1445: ac_name_in IN zpb_analysis_cycles.name%TYPE,
1446: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,
1447: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
1448: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1449: IS
1450: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1451: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1452: relationship_id zpb_cycle_relationships.relationship_id%TYPE;

Line 1450: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1446: ac_owner_id_in IN zpb_analysis_cycles.owner_id%TYPE,
1447: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
1448: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1449: IS
1450: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1451: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1452: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1453: pet_rec zpb_cycle_relationships%ROWTYPE;
1454: ac_rec zpb_analysis_cycles%ROWTYPE;

Line 1451: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1447: ac_business_area_in IN zpb_business_areas.business_area_id%TYPE,
1448: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1449: IS
1450: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1451: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1452: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1453: pet_rec zpb_cycle_relationships%ROWTYPE;
1454: ac_rec zpb_analysis_cycles%ROWTYPE;
1455: BEGIN

Line 1454: ac_rec zpb_analysis_cycles%ROWTYPE;

1450: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1451: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1452: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1453: pet_rec zpb_cycle_relationships%ROWTYPE;
1454: ac_rec zpb_analysis_cycles%ROWTYPE;
1455: BEGIN
1456: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1457: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1458: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;

Line 1474: INSERT INTO zpb_analysis_cycles(ANALYSIS_CYCLE_ID,

1470: --ac_rec.PUBLISHED_BY := sys_context('ZPB_CONTEXT', 'shadow_id');
1471: ac_rec.OWNER_ID := ac_owner_id_in;
1472: ac_rec.BUSINESS_AREA_ID := ac_business_area_in;
1473: ac_rec.CURRENT_INSTANCE_ID :=current_inst_id;
1474: INSERT INTO zpb_analysis_cycles(ANALYSIS_CYCLE_ID,
1475: STATUS_CODE,
1476: NAME,
1477: DESCRIPTION,
1478: LOCKED_BY,

Line 1540: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1536: END create_new_cycle;
1537:
1538:
1539: PROCEDURE create_new_instance (
1540: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1541: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1542: IS
1543: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1544: ac_rec zpb_analysis_cycles%ROWTYPE;

Line 1541: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

1537:
1538:
1539: PROCEDURE create_new_instance (
1540: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1541: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1542: IS
1543: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1544: ac_rec zpb_analysis_cycles%ROWTYPE;
1545: instance_rec zpb_analysis_cycle_instances%ROWTYPE;

Line 1543: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1539: PROCEDURE create_new_instance (
1540: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1541: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1542: IS
1543: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1544: ac_rec zpb_analysis_cycles%ROWTYPE;
1545: instance_rec zpb_analysis_cycle_instances%ROWTYPE;
1546: instance_desc zpb_analysis_cycle_instances.instance_description%TYPE;
1547: curr_count INTEGER;

Line 1544: ac_rec zpb_analysis_cycles%ROWTYPE;

1540: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1541: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1542: IS
1543: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1544: ac_rec zpb_analysis_cycles%ROWTYPE;
1545: instance_rec zpb_analysis_cycle_instances%ROWTYPE;
1546: instance_desc zpb_analysis_cycle_instances.instance_description%TYPE;
1547: curr_count INTEGER;
1548: curr_count_str VARCHAR2(5);

Line 1558: zpb_analysis_cycles pubac,

1554: select to_number(substr(instance_description,length(instance_description) -2))
1555: from zpb_analysis_cycle_instances
1556: where instance_ac_id = (select max(instance_ac_id)
1557: from zpb_analysis_cycle_instances aci,
1558: zpb_analysis_cycles pubac,
1559: zpb_analysis_cycles runac
1560: where pubac.analysis_cycle_id = ac_id_in
1561: and pubac.current_instance_id =
1562: runac.current_instance_id

Line 1559: zpb_analysis_cycles runac

1555: from zpb_analysis_cycle_instances
1556: where instance_ac_id = (select max(instance_ac_id)
1557: from zpb_analysis_cycle_instances aci,
1558: zpb_analysis_cycles pubac,
1559: zpb_analysis_cycles runac
1560: where pubac.analysis_cycle_id = ac_id_in
1561: and pubac.current_instance_id =
1562: runac.current_instance_id
1563: and runac.analysis_cycle_id = aci.instance_ac_id);

Line 1576: FROM zpb_analysis_cycles

1572: create_ac_copy(ac_id_in, new_ac_id);
1573:
1574: SELECT *
1575: INTO ac_rec
1576: FROM zpb_analysis_cycles
1577: WHERE analysis_cycle_id = new_ac_id;
1578:
1579: SELECT tag INTO l_appview_param_id
1580: FROM fnd_lookup_values_vl

Line 1584: UPDATE zpb_analysis_cycles

1580: FROM fnd_lookup_values_vl
1581: WHERE LOOKUP_CODE = 'APPEND_VIEW'
1582: and LOOKUP_TYPE = 'ZPB_PARAMS';
1583:
1584: UPDATE zpb_analysis_cycles
1585: SET status_code = 'PUBLISHED',
1586: LAST_UPDATED_BY = fnd_global.USER_ID,
1587: LAST_UPDATE_DATE = SYSDATE,
1588: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1672: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1668: END create_new_instance;
1669:
1670:
1671: PROCEDURE create_tmp_cycle (
1672: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1673: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1674: IS
1675: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1676: pet_row_rec zpb_cycle_relationships%ROWTYPE;

Line 1673: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

1669:
1670:
1671: PROCEDURE create_tmp_cycle (
1672: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1673: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1674: IS
1675: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1676: pet_row_rec zpb_cycle_relationships%ROWTYPE;
1677: BEGIN

Line 1675: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1671: PROCEDURE create_tmp_cycle (
1672: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1673: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1674: IS
1675: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1676: pet_row_rec zpb_cycle_relationships%ROWTYPE;
1677: BEGIN
1678: SELECT *
1679: INTO pet_row_rec

Line 1705: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

1701: END create_tmp_cycle;
1702:
1703:
1704: PROCEDURE delete_tmp_ac (
1705: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
1706: IS
1707: editable_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1708: BEGIN
1709: SELECT editable_ac_id

Line 1707: editable_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1703:
1704: PROCEDURE delete_tmp_ac (
1705: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
1706: IS
1707: editable_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1708: BEGIN
1709: SELECT editable_ac_id
1710: INTO editable_ac_id
1711: FROM zpb_cycle_relationships

Line 1714: UPDATE zpb_analysis_cycles

1710: INTO editable_ac_id
1711: FROM zpb_cycle_relationships
1712: WHERE tmp_ac_id = tmp_ac_id_in;
1713:
1714: UPDATE zpb_analysis_cycles
1715: SET
1716: LAST_UPDATED_BY = fnd_global.USER_ID,
1717: LAST_UPDATE_DATE = SYSDATE,
1718: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1727: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1723:
1724:
1725:
1726: PROCEDURE lock_cycle (
1727: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1728: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,
1729: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE)
1730: IS
1731: locked_by_id zpb_analysis_cycles.locked_by%TYPE;

Line 1728: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,

1724:
1725:
1726: PROCEDURE lock_cycle (
1727: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1728: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,
1729: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE)
1730: IS
1731: locked_by_id zpb_analysis_cycles.locked_by%TYPE;
1732: BEGIN

Line 1729: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE)

1725:
1726: PROCEDURE lock_cycle (
1727: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1728: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,
1729: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE)
1730: IS
1731: locked_by_id zpb_analysis_cycles.locked_by%TYPE;
1732: BEGIN
1733: SELECT locked_by

Line 1731: locked_by_id zpb_analysis_cycles.locked_by%TYPE;

1727: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1728: user_id_in IN zpb_analysis_cycles.locked_by%TYPE,
1729: locked_by_id_out OUT NOCOPY zpb_analysis_cycles.locked_by%TYPE)
1730: IS
1731: locked_by_id zpb_analysis_cycles.locked_by%TYPE;
1732: BEGIN
1733: SELECT locked_by
1734: INTO locked_by_id
1735: FROM zpb_analysis_cycles

Line 1735: FROM zpb_analysis_cycles

1731: locked_by_id zpb_analysis_cycles.locked_by%TYPE;
1732: BEGIN
1733: SELECT locked_by
1734: INTO locked_by_id
1735: FROM zpb_analysis_cycles
1736: WHERE analysis_cycle_id = editable_ac_id_in;
1737:
1738: locked_by_id_out := locked_by_id;
1739:

Line 1741: UPDATE zpb_analysis_cycles

1737:
1738: locked_by_id_out := locked_by_id;
1739:
1740: IF locked_by_id IS NULL THEN
1741: UPDATE zpb_analysis_cycles
1742: SET locked_by = user_id_in,
1743: LAST_UPDATED_BY = fnd_global.USER_ID,
1744: LAST_UPDATE_DATE = SYSDATE,
1745: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1754: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1750: END lock_cycle;
1751:
1752:
1753: PROCEDURE mark_cycle_for_delete (
1754: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1755: prev_instance_options_in IN VARCHAR2,
1756: curr_instance_options_in IN VARCHAR2)
1757: IS
1758: CURSOR previous_instance_cur IS

Line 1760: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,

1756: curr_instance_options_in IN VARCHAR2)
1757: IS
1758: CURSOR previous_instance_cur IS
1759: SELECT aci.instance_ac_id, ac.current_instance_id
1760: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,
1761: zpb_analysis_cycles currinst
1762: where currinst.ANALYSIS_CYCLE_ID = ac_id_in
1763: and currinst.current_instance_id=ac.current_instance_id
1764: and ac.analysis_cycle_id=aci.instance_ac_id

Line 1761: zpb_analysis_cycles currinst

1757: IS
1758: CURSOR previous_instance_cur IS
1759: SELECT aci.instance_ac_id, ac.current_instance_id
1760: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,
1761: zpb_analysis_cycles currinst
1762: where currinst.ANALYSIS_CYCLE_ID = ac_id_in
1763: and currinst.current_instance_id=ac.current_instance_id
1764: and ac.analysis_cycle_id=aci.instance_ac_id
1765: and ac.status_code in ('COMPLETE','ERROR','COMPLETE_WITH_WARNING');

Line 1775: curr_instance_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1771: and name = 'ACID'
1772: and number_value = ac_id_in;
1773: v_wfItemKey c_wfItemKey%ROWTYPE;
1774:
1775: curr_instance_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1776: l_count NUMBER;
1777: cycle_type VARCHAR2(30);
1778: tmp_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1779: edit_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

Line 1778: tmp_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1774:
1775: curr_instance_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1776: l_count NUMBER;
1777: cycle_type VARCHAR2(30);
1778: tmp_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1779: edit_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1780: ownerid NUMBER;
1781: l_REQID NUMBER;
1782: l_REQID2 NUMBER;

Line 1779: edit_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

1775: curr_instance_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1776: l_count NUMBER;
1777: cycle_type VARCHAR2(30);
1778: tmp_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1779: edit_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1780: ownerid NUMBER;
1781: l_REQID NUMBER;
1782: l_REQID2 NUMBER;
1783: respID number := fnd_global.RESP_ID;

Line 1796: from zpb_analysis_cycles

1792: BEGIN
1793:
1794: -- abudnik 07DEC2005 BUSINESS AREA ID added for ZPB_WF_DELAWINST
1795: select published_by, BUSINESS_AREA_ID into ownerid, l_business_area_id
1796: from zpb_analysis_cycles
1797: where analysis_cycle_id = ac_id_in;
1798:
1799: for v_wfItemKey in c_wfItemKey loop
1800: ItemKey:=v_wfItemKey.item_key;

Line 1873: UPDATE zpb_analysis_cycles

1869:
1870: END IF;
1871:
1872: -- Now mark the cycle its editable copy, and its temp copy for deletion
1873: UPDATE zpb_analysis_cycles
1874: SET status_code='MARKED_FOR_DELETION',
1875: LAST_UPDATED_BY = fnd_global.USER_ID,
1876: LAST_UPDATE_DATE = SYSDATE,
1877: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1903: UPDATE zpb_analysis_cycles

1899: IF prev_instance_options_in = 'DELETE_PREVIOUS_INSTANCE' THEN
1900:
1901: FOR instance_rec IN previous_instance_cur LOOP
1902:
1903: UPDATE zpb_analysis_cycles
1904: SET status_code='MARKED_FOR_DELETION',
1905: LAST_UPDATED_BY = fnd_global.USER_ID,
1906: LAST_UPDATE_DATE = SYSDATE,
1907: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1934: UPDATE zpb_analysis_cycles

1930:
1931: -- ABUDNIK B4558985 09Oct2005
1932: CLEAN_ACTIVE_INSTANCE(ac_id_in);
1933:
1934: UPDATE zpb_analysis_cycles
1935: SET status_code = 'MARKED_FOR_DELETION',
1936: LAST_UPDATED_BY = fnd_global.USER_ID,
1937: LAST_UPDATE_DATE = SYSDATE,
1938: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1941: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,

1937: LAST_UPDATE_DATE = SYSDATE,
1938: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1939: WHERE analysis_cycle_id in
1940: (select instance_ac_id
1941: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,
1942: zpb_analysis_cycles currinst
1943: where currinst.ANALYSIS_CYCLE_ID =ac_id_in
1944: and currinst.current_instance_id=ac.current_instance_id
1945: and ac.analysis_cycle_id=aci.instance_ac_id

Line 1942: zpb_analysis_cycles currinst

1938: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1939: WHERE analysis_cycle_id in
1940: (select instance_ac_id
1941: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,
1942: zpb_analysis_cycles currinst
1943: where currinst.ANALYSIS_CYCLE_ID =ac_id_in
1944: and currinst.current_instance_id=ac.current_instance_id
1945: and ac.analysis_cycle_id=aci.instance_ac_id
1946: and ac.status_code NOT IN ('COMPLETE','ERROR','COMPLETE_WITH_WARNING'));

Line 1969: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

1965: -- The flag will be used by the Solve task of an active instance to
1966: -- determine if it should start the Solve from the very beginning or not
1967: --
1968: PROCEDURE update_solve_definition_flag(
1969: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1970: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
1971: IS
1972: cursor input_levels_cur(published_ac_id_in IN integer ,
1973: editable_ac_id_in in integer) IS

Line 1970: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)

1966: -- determine if it should start the Solve from the very beginning or not
1967: --
1968: PROCEDURE update_solve_definition_flag(
1969: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1970: published_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
1971: IS
1972: cursor input_levels_cur(published_ac_id_in IN integer ,
1973: editable_ac_id_in in integer) IS
1974: select edt.member, edt.dimension, edt.input_level

Line 2010: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

2006:
2007: end update_solve_definition_flag;
2008:
2009: PROCEDURE publish_cycle (
2010: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2011: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
2012: publish_options_in IN VARCHAR2,
2013: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
2014: IS

Line 2011: published_by_in IN zpb_analysis_cycles.published_by%TYPE,

2007: end update_solve_definition_flag;
2008:
2009: PROCEDURE publish_cycle (
2010: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2011: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
2012: publish_options_in IN VARCHAR2,
2013: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
2014: IS
2015: l_dummy VARCHAR2(4000);

Line 2013: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

2009: PROCEDURE publish_cycle (
2010: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2011: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
2012: publish_options_in IN VARCHAR2,
2013: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
2014: IS
2015: l_dummy VARCHAR2(4000);
2016: BEGIN
2017: -- call the overloaded procedure marking it as a non external event.

Line 2040: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

2036: -- current runs.
2037:
2038:
2039: PROCEDURE publish_cycle (
2040: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2041: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
2042: publish_options_in IN VARCHAR2,
2043: p_bp_name_in IN VARCHAR2,
2044: p_external IN VARCHAR2,

Line 2041: published_by_in IN zpb_analysis_cycles.published_by%TYPE,

2037:
2038:
2039: PROCEDURE publish_cycle (
2040: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2041: published_by_in IN zpb_analysis_cycles.published_by%TYPE,
2042: publish_options_in IN VARCHAR2,
2043: p_bp_name_in IN VARCHAR2,
2044: p_external IN VARCHAR2,
2045: p_start_mem_in IN VARCHAR2,

Line 2048: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE,

2044: p_external IN VARCHAR2,
2045: p_start_mem_in IN VARCHAR2,
2046: p_end_mem_in IN VARCHAR2,
2047: p_send_date_in IN DATE,
2048: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE,
2049: x_item_key_out OUT NOCOPY VARCHAR2)
2050: IS
2051: old_published_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2052: ac_rec zpb_analysis_cycles%ROWTYPE;

Line 2051: old_published_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

2047: p_send_date_in IN DATE,
2048: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE,
2049: x_item_key_out OUT NOCOPY VARCHAR2)
2050: IS
2051: old_published_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2052: ac_rec zpb_analysis_cycles%ROWTYPE;
2053: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2054: published_before VARCHAR2(1);
2055: published_before_status VARCHAR2(30);

Line 2052: ac_rec zpb_analysis_cycles%ROWTYPE;

2048: published_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE,
2049: x_item_key_out OUT NOCOPY VARCHAR2)
2050: IS
2051: old_published_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2052: ac_rec zpb_analysis_cycles%ROWTYPE;
2053: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2054: published_before VARCHAR2(1);
2055: published_before_status VARCHAR2(30);
2056: enable_option varchar2(30);

Line 2065: ZPB_ANALYSIS_CYCLES zac

2061:
2062: CURSOR instance_cur IS
2063: SELECT zaci.instance_ac_id, zaci.analysis_cycle_id
2064: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
2065: ZPB_ANALYSIS_CYCLES zac
2066: WHERE zaci.analysis_cycle_id = editable_ac_id_in and
2067: zaci.instance_ac_id = zac.analysis_cycle_id and
2068: zac.status_code not in('COMPLETE', 'COMPLETE_WITH_WARNING', 'DISABLE_ASAP', 'ERROR', 'MARKED_FOR_DELETION');
2069:

Line 2095: from ZPB_ANALYSIS_CYCLES

2091:
2092: begin
2093:
2094: select STATUS_CODE into published_before_status
2095: from ZPB_ANALYSIS_CYCLES
2096: where analysis_cycle_id=pet_row_rec.published_ac_id;
2097:
2098: exception
2099: when NO_DATA_FOUND then

Line 2141: Update ZPB_ANALYSIS_CYCLES

2137: -- delete_ac(pet_row_rec.published_ac_id);
2138:
2139: old_published_ac_id := pet_row_rec.published_ac_id;
2140:
2141: Update ZPB_ANALYSIS_CYCLES
2142: set STATUS_CODE = 'ENABLE_TASK_OLD'
2143: where ANALYSIS_CYCLE_ID = old_published_ac_id
2144: and STATUS_CODE = 'ENABLE_TASK';
2145:

Line 2172: UPDATE zpb_analysis_cycles

2168: * must set the cycle status to 'ENABLE_TASK' by default when
2169: * publishing the cycle
2170: */
2171:
2172: UPDATE zpb_analysis_cycles
2173: SET published_by = published_by_in,
2174: published_date = sysdate,
2175: status_code = 'ENABLE_TASK',
2176: LAST_UPDATED_BY = fnd_global.USER_ID,

Line 2193: FROM zpb_analysis_cycles

2189: FOR instance_rec IN instance_cur LOOP
2190:
2191: SELECT *
2192: INTO ac_rec
2193: FROM zpb_analysis_cycles
2194: WHERE analysis_cycle_id = instance_rec.instance_ac_id;
2195:
2196: delete_ac(instance_rec.instance_ac_id, FND_API.G_FALSE);
2197:

Line 2226: UPDATE zpb_analysis_cycles

2222:
2223: -- Set the status and name of the instance back to what it was before copy
2224: -- most likely ACTIVE
2225:
2226: UPDATE zpb_analysis_cycles
2227: SET LAST_UPDATED_BY = fnd_global.USER_ID,
2228: LAST_UPDATE_DATE = SYSDATE,
2229: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
2230: STATUS_CODE = ac_rec.status_code,

Line 2254: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

2250: published_ac_id_out := editable_ac_id_in;
2251: END publish_cycle;
2252:
2253: PROCEDURE save_tmp_cycle (
2254: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2255: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
2256: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,
2257: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2258: x_return_status OUT NOCOPY VARCHAR2 ,

Line 2255: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,

2251: END publish_cycle;
2252:
2253: PROCEDURE save_tmp_cycle (
2254: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2255: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
2256: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,
2257: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2258: x_return_status OUT NOCOPY VARCHAR2 ,
2259: x_msg_count OUT NOCOPY NUMBER,

Line 2256: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,

2252:
2253: PROCEDURE save_tmp_cycle (
2254: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2255: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
2256: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,
2257: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2258: x_return_status OUT NOCOPY VARCHAR2 ,
2259: x_msg_count OUT NOCOPY NUMBER,
2260: x_msg_data OUT NOCOPY VARCHAR2,

Line 2257: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

2253: PROCEDURE save_tmp_cycle (
2254: tmp_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2255: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
2256: lock_val_in IN zpb_analysis_cycles.locked_by%TYPE,
2257: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2258: x_return_status OUT NOCOPY VARCHAR2 ,
2259: x_msg_count OUT NOCOPY NUMBER,
2260: x_msg_data OUT NOCOPY VARCHAR2,
2261: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

Line 2261: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)

2257: lock_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2258: x_return_status OUT NOCOPY VARCHAR2 ,
2259: x_msg_count OUT NOCOPY NUMBER,
2260: x_msg_data OUT NOCOPY VARCHAR2,
2261: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
2262:
2263: IS
2264: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2265: pet_row_rec zpb_cycle_relationships%ROWTYPE;

Line 2264: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

2260: x_msg_data OUT NOCOPY VARCHAR2,
2261: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
2262:
2263: IS
2264: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2265: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2266: lock_val zpb_analysis_cycles.locked_by%TYPE;
2267: msg_data VARCHAR2(100);
2268: CURSOR lock_cursor is SELECT locked_by FROM zpb_analysis_cycles

Line 2266: lock_val zpb_analysis_cycles.locked_by%TYPE;

2262:
2263: IS
2264: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2265: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2266: lock_val zpb_analysis_cycles.locked_by%TYPE;
2267: msg_data VARCHAR2(100);
2268: CURSOR lock_cursor is SELECT locked_by FROM zpb_analysis_cycles
2269: where analysis_cycle_id = lock_ac_id_in FOR UPDATE;
2270:

Line 2268: CURSOR lock_cursor is SELECT locked_by FROM zpb_analysis_cycles

2264: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2265: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2266: lock_val zpb_analysis_cycles.locked_by%TYPE;
2267: msg_data VARCHAR2(100);
2268: CURSOR lock_cursor is SELECT locked_by FROM zpb_analysis_cycles
2269: where analysis_cycle_id = lock_ac_id_in FOR UPDATE;
2270:
2271: BEGIN
2272:

Line 2307: UPDATE zpb_analysis_cycles

2303: WHERE tmp_ac_id = tmp_ac_id_in;
2304:
2305: delete_ac(tmp_ac_id_in);
2306:
2307: UPDATE zpb_analysis_cycles
2308: SET locked_by = nvl(locked_by,0)+1,
2309: LAST_UPDATED_BY = fnd_global.USER_ID,
2310: LAST_UPDATE_DATE = SYSDATE,
2311: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 2339: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

2335: * based on its cycle ID
2336: */
2337:
2338: PROCEDURE get_cycle_type (
2339: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2340: cycle_type_out OUT NOCOPY VARCHAR2)
2341: IS
2342: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2343: BEGIN

Line 2375: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

2371: * based on its cycle ID
2372: */
2373:
2374: PROCEDURE get_cycle_status (
2375: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2376: cycle_status_out OUT NOCOPY VARCHAR2)
2377: IS
2378:
2379: BEGIN

Line 2385: FROM zpb_analysis_cycles

2381: begin
2382:
2383: SELECT status_code
2384: INTO cycle_status_out
2385: FROM zpb_analysis_cycles
2386: WHERE analysis_cycle_id=ac_id_in;
2387:
2388: exception
2389: when no_data_found then

Line 2396: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

2392:
2393: END get_cycle_status;
2394:
2395: PROCEDURE get_lock_value (
2396: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2397: lock_value_out OUT NOCOPY NUMBER)
2398: IS
2399:
2400: BEGIN

Line 2406: FROM zpb_analysis_cycles

2402: begin
2403:
2404: SELECT locked_by
2405: INTO lock_value_out
2406: FROM zpb_analysis_cycles
2407: WHERE analysis_cycle_id=ac_id_in;
2408:
2409: exception
2410: when no_data_found then

Line 2421: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

2417: * This procedure enables the cycle identified by
2418: * based on the enable status passed into the UI.
2419: */
2420: PROCEDURE enable_cycle (
2421: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2422: enable_status_in IN VARCHAR2)
2423: IS
2424: BEGIN
2425:

Line 2435: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER IS

2431: /*
2432: * This function returns 1 if this temp ac id is a draft of a published cycle
2433: *
2434: */
2435: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER IS
2436: CURSOR c_draft(cp_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) IS
2437: SELECT 1 FROM zpb_cycle_relationships
2438: WHERE TMP_AC_ID = cp_tmp_ac_id AND published_ac_id IS NOT NULL;
2439: l_ret NUMBER(2);

Line 2436: CURSOR c_draft(cp_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) IS

2432: * This function returns 1 if this temp ac id is a draft of a published cycle
2433: *
2434: */
2435: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER IS
2436: CURSOR c_draft(cp_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) IS
2437: SELECT 1 FROM zpb_cycle_relationships
2438: WHERE TMP_AC_ID = cp_tmp_ac_id AND published_ac_id IS NOT NULL;
2439: l_ret NUMBER(2);
2440: BEGIN

Line 2459: FUNCTION getUniqueName(p_bus_area_id IN zpb_analysis_cycles.business_area_id%TYPE,

2455: duplication of business process is invoked.
2456: Assumption(s):
2457: Maximum length of the name of a BP is 300.
2458: */
2459: FUNCTION getUniqueName(p_bus_area_id IN zpb_analysis_cycles.business_area_id%TYPE,
2460: p_cycle_name IN varchar2)RETURN VARCHAR IS
2461:
2462: cursor unique_name_cur(cycle_name zpb_analysis_cycles.name%type)
2463: is

Line 2462: cursor unique_name_cur(cycle_name zpb_analysis_cycles.name%type)

2458: */
2459: FUNCTION getUniqueName(p_bus_area_id IN zpb_analysis_cycles.business_area_id%TYPE,
2460: p_cycle_name IN varchar2)RETURN VARCHAR IS
2461:
2462: cursor unique_name_cur(cycle_name zpb_analysis_cycles.name%type)
2463: is
2464: select 1 from zpb_analysis_cycles where
2465: lower(name) = lower(cycle_name)
2466: and status_code <> 'MARKED_FOR_DELETION'

Line 2464: select 1 from zpb_analysis_cycles where

2460: p_cycle_name IN varchar2)RETURN VARCHAR IS
2461:
2462: cursor unique_name_cur(cycle_name zpb_analysis_cycles.name%type)
2463: is
2464: select 1 from zpb_analysis_cycles where
2465: lower(name) = lower(cycle_name)
2466: and status_code <> 'MARKED_FOR_DELETION'
2467: and business_area_id = p_bus_area_id;
2468:

Line 2470: new_bp_name zpb_analysis_cycles.name%TYPE;

2466: and status_code <> 'MARKED_FOR_DELETION'
2467: and business_area_id = p_bus_area_id;
2468:
2469: orig_name varchar2(500);
2470: new_bp_name zpb_analysis_cycles.name%TYPE;
2471: old_name zpb_analysis_cycles.name%type;
2472: temp number := null;
2473: mycount number := 1;
2474:

Line 2471: old_name zpb_analysis_cycles.name%type;

2467: and business_area_id = p_bus_area_id;
2468:
2469: orig_name varchar2(500);
2470: new_bp_name zpb_analysis_cycles.name%TYPE;
2471: old_name zpb_analysis_cycles.name%type;
2472: temp number := null;
2473: mycount number := 1;
2474:
2475: BEGIN

Line 2693: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

2689: x_ac_id out nocopy number) as
2690:
2691: l_api_name CONSTANT VARCHAR2(30) := 'create_partial_cycle';
2692: l_api_version CONSTANT NUMBER := 1.0;
2693: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2694: current_inst_id zpb_analysis_cycles.current_instance_id%TYPE;
2695: ac_rec zpb_analysis_cycles%ROWTYPE;
2696: pet_rec zpb_cycle_relationships%ROWTYPE;
2697: relationship_id zpb_cycle_relationships.relationship_id%TYPE;

Line 2694: current_inst_id zpb_analysis_cycles.current_instance_id%TYPE;

2690:
2691: l_api_name CONSTANT VARCHAR2(30) := 'create_partial_cycle';
2692: l_api_version CONSTANT NUMBER := 1.0;
2693: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2694: current_inst_id zpb_analysis_cycles.current_instance_id%TYPE;
2695: ac_rec zpb_analysis_cycles%ROWTYPE;
2696: pet_rec zpb_cycle_relationships%ROWTYPE;
2697: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
2698: ac_param_rec zpb_ac_param_values%ROWTYPE;

Line 2695: ac_rec zpb_analysis_cycles%ROWTYPE;

2691: l_api_name CONSTANT VARCHAR2(30) := 'create_partial_cycle';
2692: l_api_version CONSTANT NUMBER := 1.0;
2693: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2694: current_inst_id zpb_analysis_cycles.current_instance_id%TYPE;
2695: ac_rec zpb_analysis_cycles%ROWTYPE;
2696: pet_rec zpb_cycle_relationships%ROWTYPE;
2697: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
2698: ac_param_rec zpb_ac_param_values%ROWTYPE;
2699: invalid_versions exception;

Line 2742: INSERT INTO zpb_analysis_cycles(ANALYSIS_CYCLE_ID,

2738: ac_rec.LAST_UPDATE_DATE := SYSDATE;
2739: ac_rec.LAST_UPDATE_LOGIN := p_apps_user_id;
2740: ac_rec.PUBLISHED_BY := p_apps_user_id;
2741:
2742: INSERT INTO zpb_analysis_cycles(ANALYSIS_CYCLE_ID,
2743: STATUS_CODE,
2744: NAME,
2745: DESCRIPTION,
2746: LOCKED_BY,

Line 3147: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

3143:
3144: l_api_name CONSTANT VARCHAR2(30) := 'create_migrate_inst';
3145: l_api_version CONSTANT NUMBER := 1.0;
3146: instance_rec zpb_analysis_cycle_instances%ROWTYPE;
3147: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
3148: invalid_calendar_start_member exception;
3149: invalid_calendar_end_member exception;
3150: begin
3151:

Line 3181: update zpb_analysis_cycles set status_code = 'PUBLISHED',

3177: created_by = p_apps_user_id,
3178: last_update_login = p_apps_user_id
3179: where analysis_cycle_id = new_ac_id;
3180:
3181: update zpb_analysis_cycles set status_code = 'PUBLISHED',
3182: validate_status = 'VALID',
3183: last_updated_by = p_apps_user_id,
3184: created_by = p_apps_user_id,
3185: last_update_login = p_apps_user_id

Line 3594: p_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

3590: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3591: x_return_status OUT NOCOPY VARCHAR2,
3592: x_msg_count OUT NOCOPY NUMBER,
3593: x_msg_data OUT NOCOPY VARCHAR2,
3594: p_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
3595: x_vm_instance_id OUT NOCOPY NUMBER
3596: )
3597: IS
3598: l_api_name CONSTANT VARCHAR2(30) := 'Get_VM_instance_id';

Line 3636: FROM ZPB_ANALYSIS_CYCLES

3632: IF (l_param_value= 'APPEND_VIEW')
3633: THEN
3634: SELECT CURRENT_INSTANCE_ID
3635: INTO x_vm_instance_id
3636: FROM ZPB_ANALYSIS_CYCLES
3637: WHERE ANALYSIS_CYCLE_ID = p_ac_id_in;
3638: ELSE
3639: x_vm_instance_id := p_ac_id_in;
3640: END IF;