[Home] [Help]
168: PUBLISHED_BY,
169: PREV_STATUS_CODE,
170: OWNER_ID,
171: BUSINESS_AREA_ID,
172: fnd_global.USER_ID,
173: SYSDATE,
174: fnd_global.USER_ID,
175: SYSDATE,
176: fnd_global.LOGIN_ID
170: OWNER_ID,
171: BUSINESS_AREA_ID,
172: fnd_global.USER_ID,
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;
172: fnd_global.USER_ID,
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;
196: LAST_UPDATE_LOGIN)
197: SELECT target_ac_id_in,
198: PARAM_ID,
199: VALUE,
200: fnd_global.USER_ID,
201: SYSDATE,
202: fnd_global.USER_ID,
203: SYSDATE,
204: fnd_global.LOGIN_ID
198: PARAM_ID,
199: VALUE,
200: fnd_global.USER_ID,
201: SYSDATE,
202: fnd_global.USER_ID,
203: SYSDATE,
204: fnd_global.LOGIN_ID
205: FROM zpb_ac_param_values
206: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
200: fnd_global.USER_ID,
201: SYSDATE,
202: fnd_global.USER_ID,
203: SYSDATE,
204: fnd_global.LOGIN_ID
205: FROM zpb_ac_param_values
206: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
207: END copy_ac_param_values_recs;
208:
220: LAST_UPDATE_DATE,
221: LAST_UPDATE_LOGIN)
222: SELECT target_ac_id_in,
223: CURRENCY_CODE,
224: fnd_global.USER_ID,
225: SYSDATE,
226: fnd_global.USER_ID,
227: SYSDATE,
228: fnd_global.LOGIN_ID
222: SELECT target_ac_id_in,
223: CURRENCY_CODE,
224: fnd_global.USER_ID,
225: SYSDATE,
226: fnd_global.USER_ID,
227: SYSDATE,
228: fnd_global.LOGIN_ID
229: FROM zpb_cycle_currencies
230: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
224: fnd_global.USER_ID,
225: SYSDATE,
226: fnd_global.USER_ID,
227: SYSDATE,
228: fnd_global.LOGIN_ID
229: FROM zpb_cycle_currencies
230: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
231:
232: END copy_cycle_currency_recs;
245: LAST_UPDATE_DATE,
246: LAST_UPDATE_LOGIN)
247: SELECT target_ac_id_in,
248: USER_ID,
249: fnd_global.USER_ID,
250: SYSDATE,
251: fnd_global.USER_ID,
252: SYSDATE,
253: fnd_global.LOGIN_ID
247: SELECT target_ac_id_in,
248: USER_ID,
249: fnd_global.USER_ID,
250: SYSDATE,
251: fnd_global.USER_ID,
252: SYSDATE,
253: fnd_global.LOGIN_ID
254: FROM zpb_bp_external_users
255: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
249: fnd_global.USER_ID,
250: SYSDATE,
251: fnd_global.USER_ID,
252: SYSDATE,
253: fnd_global.LOGIN_ID
254: FROM zpb_bp_external_users
255: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
256:
257: END copy_external_user_recs;
272: LAST_UPDATE_LOGIN)
273: SELECT target_ac_id_in,
274: DATASET_CODE,
275: ORDER_ID,
276: fnd_global.USER_ID,
277: SYSDATE,
278: fnd_global.USER_ID,
279: SYSDATE,
280: fnd_global.LOGIN_ID
274: DATASET_CODE,
275: ORDER_ID,
276: fnd_global.USER_ID,
277: SYSDATE,
278: fnd_global.USER_ID,
279: SYSDATE,
280: fnd_global.LOGIN_ID
281: FROM zpb_cycle_datasets
282: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
276: fnd_global.USER_ID,
277: SYSDATE,
278: fnd_global.USER_ID,
279: SYSDATE,
280: fnd_global.LOGIN_ID
281: FROM zpb_cycle_datasets
282: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
283:
284: END copy_cycle_datasets_recs;
313: REMOVE_DIMENSION_FLAG,
314: SUM_MEMBERS_NUMBER,
315: SUM_SELECTION_NAME,
316: SUM_SELECTION_PATH,
317: fnd_global.LOGIN_ID,
318: SYSDATE,
319: fnd_global.USER_ID,
320: SYSDATE,
321: fnd_global.USER_ID
315: SUM_SELECTION_NAME,
316: SUM_SELECTION_PATH,
317: fnd_global.LOGIN_ID,
318: SYSDATE,
319: fnd_global.USER_ID,
320: SYSDATE,
321: fnd_global.USER_ID
322: FROM zpb_cycle_model_dimensions
323: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
317: fnd_global.LOGIN_ID,
318: SYSDATE,
319: fnd_global.USER_ID,
320: SYSDATE,
321: fnd_global.USER_ID
322: FROM zpb_cycle_model_dimensions
323: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
324:
325: END copy_cycle_model_dim_recs;
349: USER_ID,
350: EXEMPTION_ID,
351: target_task_id,
352: BUSINESS_PROCESS_ENTITY_TYPE,
353: fnd_global.USER_ID,
354: SYSDATE,
355: fnd_global.USER_ID,
356: SYSDATE,
357: fnd_global.LOGIN_ID
351: target_task_id,
352: BUSINESS_PROCESS_ENTITY_TYPE,
353: fnd_global.USER_ID,
354: SYSDATE,
355: fnd_global.USER_ID,
356: SYSDATE,
357: fnd_global.LOGIN_ID
358: FROM zpb_measure_scope_exempt_users
359: WHERE BUSINESS_PROCESS_ENTITY_ID = source_ac_id_in
353: fnd_global.USER_ID,
354: SYSDATE,
355: fnd_global.USER_ID,
356: SYSDATE,
357: fnd_global.LOGIN_ID
358: FROM zpb_measure_scope_exempt_users
359: WHERE BUSINESS_PROCESS_ENTITY_ID = source_ac_id_in
360: AND BUSINESS_PROCESS_ENTITY_TYPE = 'A'
361: AND TASK_ID = source_task_id;
405: END_RELATIVE_TYPE_CODE,
406: END_PERIODS,
407: END_TIME_LEVEL_ID,
408: TIME_HIERARCHY_ID,
409: fnd_global.USER_ID,
410: SYSDATE,
411: fnd_global.USER_ID,
412: SYSDATE,
413: fnd_global.LOGIN_ID
407: END_TIME_LEVEL_ID,
408: TIME_HIERARCHY_ID,
409: fnd_global.USER_ID,
410: SYSDATE,
411: fnd_global.USER_ID,
412: SYSDATE,
413: fnd_global.LOGIN_ID
414: FROM zpb_business_process_scope
415: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in
409: fnd_global.USER_ID,
410: SYSDATE,
411: fnd_global.USER_ID,
412: SYSDATE,
413: fnd_global.LOGIN_ID
414: FROM zpb_business_process_scope
415: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in
416: AND TASK_ID = source_task_id;
417:
435: SELECT zpb_cycle_comments_id_seq.NEXTVAL,
436: target_ac_id_in,
437: COMMENTS,
438: OWNER_ID,
439: fnd_global.USER_ID,
440: SYSDATE,
441: fnd_global.USER_ID,
442: SYSDATE,
443: fnd_global.LOGIN_ID
437: COMMENTS,
438: OWNER_ID,
439: fnd_global.USER_ID,
440: SYSDATE,
441: fnd_global.USER_ID,
442: SYSDATE,
443: fnd_global.LOGIN_ID
444: FROM zpb_cycle_comments
445: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
439: fnd_global.USER_ID,
440: SYSDATE,
441: fnd_global.USER_ID,
442: SYSDATE,
443: fnd_global.LOGIN_ID
444: FROM zpb_cycle_comments
445: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
446:
447: END copy_cycle_comments_recs;
463: LAST_UPDATE_DATE,
464: LAST_UPDATE_LOGIN)
465: SELECT NAME,
466: target_task_id_in,
467: decode(name, 'OWNER_ID', to_char( fnd_global.USER_ID ),VALUE),
468: zpb_task_param_id_seq.NEXTVAL,
469: fnd_global.USER_ID,
470: SYSDATE,
471: fnd_global.USER_ID,
465: SELECT NAME,
466: target_task_id_in,
467: decode(name, 'OWNER_ID', to_char( fnd_global.USER_ID ),VALUE),
468: zpb_task_param_id_seq.NEXTVAL,
469: fnd_global.USER_ID,
470: SYSDATE,
471: fnd_global.USER_ID,
472: SYSDATE,
473: fnd_global.LOGIN_ID
467: decode(name, 'OWNER_ID', to_char( fnd_global.USER_ID ),VALUE),
468: zpb_task_param_id_seq.NEXTVAL,
469: fnd_global.USER_ID,
470: SYSDATE,
471: fnd_global.USER_ID,
472: SYSDATE,
473: fnd_global.LOGIN_ID
474: FROM zpb_task_parameters
475: WHERE TASK_ID = source_task_id_in;
469: fnd_global.USER_ID,
470: SYSDATE,
471: fnd_global.USER_ID,
472: SYSDATE,
473: fnd_global.LOGIN_ID
474: FROM zpb_task_parameters
475: WHERE TASK_ID = source_task_id_in;
476:
477: exception
519: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;
520: source_task_id := ac_task_rec.task_id;
521: ac_task_rec.analysis_cycle_id := target_ac_id_in;
522: ac_task_rec.task_id := target_task_id;
523: ac_task_rec.CREATED_BY := fnd_global.USER_ID;
524: ac_task_rec.CREATION_DATE := SYSDATE;
525: ac_task_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
526: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
527: ac_task_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
521: ac_task_rec.analysis_cycle_id := target_ac_id_in;
522: ac_task_rec.task_id := target_task_id;
523: ac_task_rec.CREATED_BY := fnd_global.USER_ID;
524: ac_task_rec.CREATION_DATE := SYSDATE;
525: ac_task_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
526: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
527: ac_task_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
528: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,
529: TASK_ID,
523: ac_task_rec.CREATED_BY := fnd_global.USER_ID;
524: ac_task_rec.CREATION_DATE := SYSDATE;
525: ac_task_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
526: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
527: ac_task_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
528: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,
529: TASK_ID,
530: SEQUENCE,
531: TASK_NAME,
555: ac_task_rec.CREATED_BY,
556: ac_task_rec.LAST_UPDATED_BY,
557: ac_task_rec.LAST_UPDATE_DATE,
558: ac_task_rec.LAST_UPDATE_LOGIN,
559: fnd_global.USER_ID);
560: copy_task_param_recs(source_task_id, target_task_id);
561:
562: -- Bug 4587184: Add the following condition to copy the tasks
563: IF (ac_task_rec.WF_PROCESS_NAME = 'SET_VIEW_RESTRICTION') THEN
621: MODEL_EQUATION,
622: PROPAGATE_TARGET,
623: DATA_SOURCE,
624: CURRENT_MODIFIED,
625: fnd_global.USER_ID,
626: SYSDATE,
627: fnd_global.USER_ID,
628: SYSDATE,
629: fnd_global.LOGIN_ID
623: DATA_SOURCE,
624: CURRENT_MODIFIED,
625: fnd_global.USER_ID,
626: SYSDATE,
627: fnd_global.USER_ID,
628: SYSDATE,
629: fnd_global.LOGIN_ID
630: FROM zpb_solve_member_defs
631: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
625: fnd_global.USER_ID,
626: SYSDATE,
627: fnd_global.USER_ID,
628: SYSDATE,
629: fnd_global.LOGIN_ID
630: FROM zpb_solve_member_defs
631: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
632: END copy_solve_member_defs_recs;
633:
653: SELECT DIM,
654: target_ac_id_in,
655: SOURCE_NUM_MEMBERS,
656: TARGET_NUM_MEMBERS,
657: fnd_global.USER_ID,
658: SYSDATE,
659: fnd_global.USER_ID,
660: SYSDATE,
661: fnd_global.LOGIN_ID,
655: SOURCE_NUM_MEMBERS,
656: TARGET_NUM_MEMBERS,
657: fnd_global.USER_ID,
658: SYSDATE,
659: fnd_global.USER_ID,
660: SYSDATE,
661: fnd_global.LOGIN_ID,
662: SAME_SELECTION,
663: LINE_MEMBER_ID
657: fnd_global.USER_ID,
658: SYSDATE,
659: fnd_global.USER_ID,
660: SYSDATE,
661: fnd_global.LOGIN_ID,
662: SAME_SELECTION,
663: LINE_MEMBER_ID
664: FROM zpb_copy_dim_members
665: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
697: LAG_TIME_PERIODS,
698: LAG_TIME_LEVEL,
699: CHANGE_NUMBER,
700: PERCENTAGE_FLAG,
701: fnd_global.USER_ID,
702: SYSDATE,
703: fnd_global.USER_ID,
704: SYSDATE,
705: fnd_global.LOGIN_ID,
699: CHANGE_NUMBER,
700: PERCENTAGE_FLAG,
701: fnd_global.USER_ID,
702: SYSDATE,
703: fnd_global.USER_ID,
704: SYSDATE,
705: fnd_global.LOGIN_ID,
706: QUERY_PATH,
707: SOURCE_QUERY_NAME,
701: fnd_global.USER_ID,
702: SYSDATE,
703: fnd_global.USER_ID,
704: SYSDATE,
705: fnd_global.LOGIN_ID,
706: QUERY_PATH,
707: SOURCE_QUERY_NAME,
708: TARGET_QUERY_NAME,
709: PROPAGATED_FLAG
739: HIERARCHY,
740: SELECTION_NAME,
741: PROPAGATED_FLAG,
742: SELECTION_PATH,
743: fnd_global.USER_ID,
744: SYSDATE,
745: fnd_global.USER_ID,
746: SYSDATE,
747: fnd_global.LOGIN_ID
741: PROPAGATED_FLAG,
742: SELECTION_PATH,
743: fnd_global.USER_ID,
744: SYSDATE,
745: fnd_global.USER_ID,
746: SYSDATE,
747: fnd_global.LOGIN_ID
748: FROM zpb_solve_input_selections
749: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
743: fnd_global.USER_ID,
744: SYSDATE,
745: fnd_global.USER_ID,
746: SYSDATE,
747: fnd_global.LOGIN_ID
748: FROM zpb_solve_input_selections
749: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
750:
751: END copy_solve_input_level_recs;
780: SELECTION_NAME,
781: PROPAGATED_FLAG,
782: MATCH_INPUT_FLAG,
783: SELECTION_PATH,
784: fnd_global.USER_ID,
785: SYSDATE,
786: fnd_global.USER_ID,
787: SYSDATE,
788: fnd_global.LOGIN_ID
782: MATCH_INPUT_FLAG,
783: SELECTION_PATH,
784: fnd_global.USER_ID,
785: SYSDATE,
786: fnd_global.USER_ID,
787: SYSDATE,
788: fnd_global.LOGIN_ID
789: FROM zpb_solve_output_selections
790: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
784: fnd_global.USER_ID,
785: SYSDATE,
786: fnd_global.USER_ID,
787: SYSDATE,
788: fnd_global.LOGIN_ID
789: FROM zpb_solve_output_selections
790: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
791:
792: END copy_solve_output_level_recs;
823: QUALIFIER,
824: EVALUATION_OPTION,
825: ROUND_DECIMALS,
826: ROUND_ENABLED,
827: fnd_global.USER_ID,
828: SYSDATE,
829: fnd_global.USER_ID,
830: SYSDATE,
831: fnd_global.LOGIN_ID
825: ROUND_DECIMALS,
826: ROUND_ENABLED,
827: fnd_global.USER_ID,
828: SYSDATE,
829: fnd_global.USER_ID,
830: SYSDATE,
831: fnd_global.LOGIN_ID
832: FROM zpb_solve_allocation_defs
833: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
827: fnd_global.USER_ID,
828: SYSDATE,
829: fnd_global.USER_ID,
830: SYSDATE,
831: fnd_global.LOGIN_ID
832: FROM zpb_solve_allocation_defs
833: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
834:
835:
868: FORCE_INPUT_FLAG,
869: SUM_SELECTION_NAME,
870: PROPAGATED_FLAG,
871: SUM_SELECTION_PATH,
872: fnd_global.USER_ID,
873: SYSDATE,
874: fnd_global.USER_ID,
875: SYSDATE,
876: fnd_global.LOGIN_ID
870: PROPAGATED_FLAG,
871: SUM_SELECTION_PATH,
872: fnd_global.USER_ID,
873: SYSDATE,
874: fnd_global.USER_ID,
875: SYSDATE,
876: fnd_global.LOGIN_ID
877: FROM zpb_line_dimensionality
878: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
872: fnd_global.USER_ID,
873: SYSDATE,
874: fnd_global.USER_ID,
875: SYSDATE,
876: fnd_global.LOGIN_ID
877: FROM zpb_line_dimensionality
878: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
879:
880: END copy_line_dimensionality_recs;
905: hierarchy_order,
906: first_last_flag,
907: object_version_number,
908: sysdate,
909: fnd_global.user_id,
910: fnd_global.user_id,
911: sysdate,
912: fnd_global.login_id
913: FROM zpb_solve_hier_order
906: first_last_flag,
907: object_version_number,
908: sysdate,
909: fnd_global.user_id,
910: fnd_global.user_id,
911: sysdate,
912: fnd_global.login_id
913: FROM zpb_solve_hier_order
914: WHERE analysis_cycle_id = source_ac_id_in;
908: sysdate,
909: fnd_global.user_id,
910: fnd_global.user_id,
911: sysdate,
912: fnd_global.login_id
913: FROM zpb_solve_hier_order
914: WHERE analysis_cycle_id = source_ac_id_in;
915:
916: END copy_solve_hier_order_recs;
1001: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;
1002: source_task_id := ac_task_rec.task_id;
1003: ac_task_rec.analysis_cycle_id := target_ac_id_in;
1004: ac_task_rec.task_id := target_task_id;
1005: ac_task_rec.CREATED_BY := fnd_global.USER_ID;
1006: ac_task_rec.CREATION_DATE := SYSDATE;
1007: ac_task_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1008: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
1009: ac_task_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1003: ac_task_rec.analysis_cycle_id := target_ac_id_in;
1004: ac_task_rec.task_id := target_task_id;
1005: ac_task_rec.CREATED_BY := fnd_global.USER_ID;
1006: ac_task_rec.CREATION_DATE := SYSDATE;
1007: ac_task_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1008: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
1009: ac_task_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1010: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,
1011: TASK_ID,
1005: ac_task_rec.CREATED_BY := fnd_global.USER_ID;
1006: ac_task_rec.CREATION_DATE := SYSDATE;
1007: ac_task_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1008: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
1009: ac_task_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1010: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,
1011: TASK_ID,
1012: SEQUENCE,
1013: TASK_NAME,
1108:
1109: IF pet_rec.published_ac_id = ac_id_in THEN
1110: UPDATE zpb_cycle_relationships
1111: SET published_ac_id = NULL,
1112: LAST_UPDATED_BY = fnd_global.USER_ID,
1113: LAST_UPDATE_DATE = SYSDATE,
1114: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1115: WHERE relationship_id = pet_rec.relationship_id;
1116: ELSIF pet_rec.editable_ac_id = ac_id_in THEN
1110: UPDATE zpb_cycle_relationships
1111: SET published_ac_id = NULL,
1112: LAST_UPDATED_BY = fnd_global.USER_ID,
1113: LAST_UPDATE_DATE = SYSDATE,
1114: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1115: WHERE relationship_id = pet_rec.relationship_id;
1116: ELSIF pet_rec.editable_ac_id = ac_id_in THEN
1117: UPDATE zpb_cycle_relationships
1118: SET editable_ac_id = NULL,
1115: WHERE relationship_id = pet_rec.relationship_id;
1116: ELSIF pet_rec.editable_ac_id = ac_id_in THEN
1117: UPDATE zpb_cycle_relationships
1118: SET editable_ac_id = NULL,
1119: LAST_UPDATED_BY = fnd_global.USER_ID,
1120: LAST_UPDATE_DATE = SYSDATE,
1121: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1122: WHERE relationship_id = pet_rec.relationship_id;
1123: ELSIF pet_rec.tmp_ac_id = ac_id_in THEN
1117: UPDATE zpb_cycle_relationships
1118: SET editable_ac_id = NULL,
1119: LAST_UPDATED_BY = fnd_global.USER_ID,
1120: LAST_UPDATE_DATE = SYSDATE,
1121: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1122: WHERE relationship_id = pet_rec.relationship_id;
1123: ELSIF pet_rec.tmp_ac_id = ac_id_in THEN
1124: UPDATE zpb_cycle_relationships
1125: SET tmp_ac_id = NULL,
1122: WHERE relationship_id = pet_rec.relationship_id;
1123: ELSIF pet_rec.tmp_ac_id = ac_id_in THEN
1124: UPDATE zpb_cycle_relationships
1125: SET tmp_ac_id = NULL,
1126: LAST_UPDATED_BY = fnd_global.USER_ID,
1127: LAST_UPDATE_DATE = SYSDATE,
1128: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1129: WHERE relationship_id = pet_rec.relationship_id;
1130: END IF;
1124: UPDATE zpb_cycle_relationships
1125: SET tmp_ac_id = NULL,
1126: LAST_UPDATED_BY = fnd_global.USER_ID,
1127: LAST_UPDATE_DATE = SYSDATE,
1128: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1129: WHERE relationship_id = pet_rec.relationship_id;
1130: END IF;
1131:
1132: DELETE FROM zpb_cycle_relationships
1263: * AC_ID because it has been deleted from the tables.
1264: */
1265: UPDATE zpb_analysis_cycle_instances
1266: SET analysis_cycle_id = NULL,
1267: LAST_UPDATED_BY = fnd_global.USER_ID,
1268: LAST_UPDATE_DATE = SYSDATE,
1269: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1270: WHERE analysis_cycle_id = ac_id_in;
1271:
1265: UPDATE zpb_analysis_cycle_instances
1266: SET analysis_cycle_id = NULL,
1267: LAST_UPDATED_BY = fnd_global.USER_ID,
1268: LAST_UPDATE_DATE = SYSDATE,
1269: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1270: WHERE analysis_cycle_id = ac_id_in;
1271:
1272: delete_ac(ac_id_in);
1273:
1363: locked_by = 1,
1364: published_date = NULL,
1365: published_by = NULL,
1366: current_instance_id = current_inst_id,
1367: owner_id = fnd_global.USER_ID,
1368: LAST_UPDATED_BY = fnd_global.USER_ID,
1369: LAST_UPDATE_DATE = SYSDATE,
1370: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1371: WHERE analysis_cycle_id = new_ac_id;
1364: published_date = NULL,
1365: published_by = NULL,
1366: current_instance_id = current_inst_id,
1367: owner_id = fnd_global.USER_ID,
1368: LAST_UPDATED_BY = fnd_global.USER_ID,
1369: LAST_UPDATE_DATE = SYSDATE,
1370: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1371: WHERE analysis_cycle_id = new_ac_id;
1372:
1366: current_instance_id = current_inst_id,
1367: owner_id = fnd_global.USER_ID,
1368: LAST_UPDATED_BY = fnd_global.USER_ID,
1369: LAST_UPDATE_DATE = SYSDATE,
1370: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1371: WHERE analysis_cycle_id = new_ac_id;
1372:
1373: pet_rec.relationship_id := relationship_id;
1374: pet_rec.tmp_ac_id := new_ac_id;
1371: WHERE analysis_cycle_id = new_ac_id;
1372:
1373: pet_rec.relationship_id := relationship_id;
1374: pet_rec.tmp_ac_id := new_ac_id;
1375: pet_rec.CREATED_BY := fnd_global.USER_ID;
1376: pet_rec.CREATION_DATE := SYSDATE;
1377: pet_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1378: pet_rec.LAST_UPDATE_DATE := SYSDATE;
1379: pet_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1373: pet_rec.relationship_id := relationship_id;
1374: pet_rec.tmp_ac_id := new_ac_id;
1375: pet_rec.CREATED_BY := fnd_global.USER_ID;
1376: pet_rec.CREATION_DATE := SYSDATE;
1377: pet_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1378: pet_rec.LAST_UPDATE_DATE := SYSDATE;
1379: pet_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1380:
1381: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,
1375: pet_rec.CREATED_BY := fnd_global.USER_ID;
1376: pet_rec.CREATION_DATE := SYSDATE;
1377: pet_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1378: pet_rec.LAST_UPDATE_DATE := SYSDATE;
1379: pet_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1380:
1381: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,
1382: PUBLISHED_AC_ID,
1383: EDITABLE_AC_ID,
1423: SET name = editable_ac_name_in,
1424: status_code = 'DISABLE_ASAP',
1425: published_date = NULL,
1426: published_by = NULL,
1427: LAST_UPDATED_BY = fnd_global.USER_ID,
1428: LAST_UPDATE_DATE = SYSDATE,
1429: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1430: WHERE analysis_cycle_id = new_ac_id;
1431:
1425: published_date = NULL,
1426: published_by = NULL,
1427: LAST_UPDATED_BY = fnd_global.USER_ID,
1428: LAST_UPDATE_DATE = SYSDATE,
1429: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1430: WHERE analysis_cycle_id = new_ac_id;
1431:
1432: UPDATE zpb_cycle_relationships
1433: SET editable_ac_id = new_ac_id,
1430: WHERE analysis_cycle_id = new_ac_id;
1431:
1432: UPDATE zpb_cycle_relationships
1433: SET editable_ac_id = new_ac_id,
1434: LAST_UPDATED_BY = fnd_global.USER_ID,
1435: LAST_UPDATE_DATE = SYSDATE,
1436: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1437: WHERE published_ac_id = published_ac_id_in;
1438:
1432: UPDATE zpb_cycle_relationships
1433: SET editable_ac_id = new_ac_id,
1434: LAST_UPDATED_BY = fnd_global.USER_ID,
1435: LAST_UPDATE_DATE = SYSDATE,
1436: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1437: WHERE published_ac_id = published_ac_id_in;
1438:
1439: editable_ac_id_out := new_ac_id;
1440:
1461: ac_rec.name := ac_name_in;
1462: ac_rec.validate_status := 'INVALID';
1463: ac_rec.status_code := 'DISABLE_ASAP';
1464: ac_rec.locked_by := 1;
1465: ac_rec.CREATED_BY := fnd_global.USER_ID;
1466: ac_rec.CREATION_DATE := SYSDATE;
1467: ac_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1468: ac_rec.LAST_UPDATE_DATE := SYSDATE;
1469: ac_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1463: ac_rec.status_code := 'DISABLE_ASAP';
1464: ac_rec.locked_by := 1;
1465: ac_rec.CREATED_BY := fnd_global.USER_ID;
1466: ac_rec.CREATION_DATE := SYSDATE;
1467: ac_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1468: ac_rec.LAST_UPDATE_DATE := SYSDATE;
1469: ac_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1470: --ac_rec.PUBLISHED_BY := sys_context('ZPB_CONTEXT', 'shadow_id');
1471: ac_rec.OWNER_ID := ac_owner_id_in;
1465: ac_rec.CREATED_BY := fnd_global.USER_ID;
1466: ac_rec.CREATION_DATE := SYSDATE;
1467: ac_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1468: ac_rec.LAST_UPDATE_DATE := SYSDATE;
1469: ac_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_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;
1507: ac_rec.OWNER_ID);
1508:
1509: pet_rec.relationship_id := relationship_id;
1510: pet_rec.tmp_ac_id := new_ac_id;
1511: pet_rec.CREATED_BY := fnd_global.USER_ID;
1512: pet_rec.CREATION_DATE := SYSDATE;
1513: pet_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1514: pet_rec.LAST_UPDATE_DATE := SYSDATE;
1515: pet_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1509: pet_rec.relationship_id := relationship_id;
1510: pet_rec.tmp_ac_id := new_ac_id;
1511: pet_rec.CREATED_BY := fnd_global.USER_ID;
1512: pet_rec.CREATION_DATE := SYSDATE;
1513: pet_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1514: pet_rec.LAST_UPDATE_DATE := SYSDATE;
1515: pet_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1516: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,
1517: PUBLISHED_AC_ID,
1511: pet_rec.CREATED_BY := fnd_global.USER_ID;
1512: pet_rec.CREATION_DATE := SYSDATE;
1513: pet_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1514: pet_rec.LAST_UPDATE_DATE := SYSDATE;
1515: pet_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1516: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,
1517: PUBLISHED_AC_ID,
1518: EDITABLE_AC_ID,
1519: TMP_AC_ID,
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
1589: WHERE analysis_cycle_id = new_ac_id;
1590:
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
1589: WHERE analysis_cycle_id = new_ac_id;
1590:
1591: begin
1592: -- find if its an append view BP, do not show ID in that case
1640:
1641: instance_rec.analysis_cycle_id := ac_id_in;
1642: instance_rec.instance_ac_id := new_ac_id;
1643: instance_rec.instance_description := instance_desc;
1644: instance_rec.CREATED_BY := fnd_global.USER_ID;
1645: instance_rec.CREATION_DATE := SYSDATE;
1646: instance_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1647: instance_rec.LAST_UPDATE_DATE := SYSDATE;
1648: instance_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1642: instance_rec.instance_ac_id := new_ac_id;
1643: instance_rec.instance_description := instance_desc;
1644: instance_rec.CREATED_BY := fnd_global.USER_ID;
1645: instance_rec.CREATION_DATE := SYSDATE;
1646: instance_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1647: instance_rec.LAST_UPDATE_DATE := SYSDATE;
1648: instance_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1649: INSERT INTO zpb_analysis_cycle_instances(ANALYSIS_CYCLE_ID,
1650: INSTANCE_AC_ID,
1644: instance_rec.CREATED_BY := fnd_global.USER_ID;
1645: instance_rec.CREATION_DATE := SYSDATE;
1646: instance_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1647: instance_rec.LAST_UPDATE_DATE := SYSDATE;
1648: instance_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1649: INSERT INTO zpb_analysis_cycle_instances(ANALYSIS_CYCLE_ID,
1650: INSTANCE_AC_ID,
1651: INSTANCE_DESCRIPTION,
1652: CREATION_DATE,
1690: create_ac_copy(editable_ac_id_in, new_ac_id);
1691:
1692: UPDATE zpb_cycle_relationships
1693: SET tmp_ac_id = new_ac_id,
1694: LAST_UPDATED_BY = fnd_global.USER_ID,
1695: LAST_UPDATE_DATE = SYSDATE,
1696: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1697: WHERE editable_ac_id = editable_ac_id_in;
1698:
1692: UPDATE zpb_cycle_relationships
1693: SET tmp_ac_id = new_ac_id,
1694: LAST_UPDATED_BY = fnd_global.USER_ID,
1695: LAST_UPDATE_DATE = SYSDATE,
1696: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1697: WHERE editable_ac_id = editable_ac_id_in;
1698:
1699: tmp_ac_id_out := new_ac_id;
1700:
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
1719: WHERE analysis_cycle_id = editable_ac_id;
1720:
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
1719: WHERE analysis_cycle_id = editable_ac_id;
1720:
1721: delete_ac(tmp_ac_id_in);
1722: END delete_tmp_ac;
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
1746: WHERE analysis_cycle_id = editable_ac_id_in;
1747: locked_by_id_out := user_id_in;
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
1746: WHERE analysis_cycle_id = editable_ac_id_in;
1747: locked_by_id_out := user_id_in;
1748: END IF;
1749:
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;
1784: respAppID number := fnd_global.RESP_APPL_ID;
1785: ItemType varchar2(8) := 'ZPBSCHED';
1786: ItemKey varchar2(240):='UNINITIALIZED';
1787: l_return_status VARCHAR2(1);
1780: ownerid NUMBER;
1781: l_REQID NUMBER;
1782: l_REQID2 NUMBER;
1783: respID number := fnd_global.RESP_ID;
1784: respAppID number := fnd_global.RESP_APPL_ID;
1785: ItemType varchar2(8) := 'ZPBSCHED';
1786: ItemKey varchar2(240):='UNINITIALIZED';
1787: l_return_status VARCHAR2(1);
1788: l_msg_count NUMBER;
1816: Itemkey => ItemKey,
1817: aname => 'RESPAPPID');
1818:
1819: -- Set the context before calling submit_request
1820: fnd_global.apps_initialize(ownerID, respID, RespAppId);
1821:
1822: end if;
1823:
1824: get_cycle_type(ac_id_in, cycle_type);
1854: WHERE editable_ac_id = ac_id_in;
1855:
1856: UPDATE zpb_cycle_relationships
1857: set editable_ac_id = null,
1858: LAST_UPDATED_BY = fnd_global.USER_ID,
1859: LAST_UPDATE_DATE = SYSDATE,
1860: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1861: where editable_ac_id = ac_id_in;
1862: END IF;
1856: UPDATE zpb_cycle_relationships
1857: set editable_ac_id = null,
1858: LAST_UPDATED_BY = fnd_global.USER_ID,
1859: LAST_UPDATE_DATE = SYSDATE,
1860: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1861: where editable_ac_id = ac_id_in;
1862: END IF;
1863:
1864: IF cycle_type = 'UNPUBLISHED' THEN
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
1878: WHERE analysis_cycle_id in (ac_id_in, tmp_ac_id, edit_ac_id);
1879:
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
1878: WHERE analysis_cycle_id in (ac_id_in, tmp_ac_id, edit_ac_id);
1879:
1880: DELETE zpb_dc_objects
1881: WHERE delete_instance_measures_flag = 'D' and
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
1908: WHERE analysis_cycle_id = instance_rec.instance_ac_id;
1909:
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
1908: WHERE analysis_cycle_id = instance_rec.instance_ac_id;
1909:
1910: -- Clean up the measure for
1911: -- abudnik 07DEC2005 BUSINESS AREA ID added for ZPB_WF_DELAWINST
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
1939: WHERE analysis_cycle_id in
1940: (select instance_ac_id
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
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
2158:
2159: UPDATE zpb_cycle_relationships
2160: SET published_ac_id = editable_ac_id_in,
2161: editable_ac_id = null,
2162: LAST_UPDATED_BY = fnd_global.USER_ID,
2163: LAST_UPDATE_DATE = SYSDATE,
2164: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2165: WHERE editable_ac_id = editable_ac_id_in;
2166:
2160: SET published_ac_id = editable_ac_id_in,
2161: editable_ac_id = null,
2162: LAST_UPDATED_BY = fnd_global.USER_ID,
2163: LAST_UPDATE_DATE = SYSDATE,
2164: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2165: WHERE editable_ac_id = editable_ac_id_in;
2166:
2167: /*
2168: * must set the cycle status to 'ENABLE_TASK' by default when
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,
2177: LAST_UPDATE_DATE = SYSDATE,
2178: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2179: WHERE analysis_cycle_id = editable_ac_id_in;
2180:
2174: published_date = sysdate,
2175: status_code = 'ENABLE_TASK',
2176: LAST_UPDATED_BY = fnd_global.USER_ID,
2177: LAST_UPDATE_DATE = SYSDATE,
2178: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2179: WHERE analysis_cycle_id = editable_ac_id_in;
2180:
2181: /*
2182: * If user chooses to apply publish changes already for current
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,
2231: PREV_STATUS_CODE = ac_rec.prev_status_code,
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,
2231: PREV_STATUS_CODE = ac_rec.prev_status_code,
2232: NAME = ac_rec.name
2233: WHERE analysis_cycle_id = instance_rec.instance_ac_id;
2296: create_ac_copy(tmp_ac_id_in, new_ac_id);
2297:
2298: UPDATE zpb_cycle_relationships
2299: SET editable_ac_id = new_ac_id,
2300: LAST_UPDATED_BY = fnd_global.USER_ID,
2301: LAST_UPDATE_DATE = SYSDATE,
2302: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2303: WHERE tmp_ac_id = tmp_ac_id_in;
2304:
2298: UPDATE zpb_cycle_relationships
2299: SET editable_ac_id = new_ac_id,
2300: LAST_UPDATED_BY = fnd_global.USER_ID,
2301: LAST_UPDATE_DATE = SYSDATE,
2302: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2303: WHERE tmp_ac_id = tmp_ac_id_in;
2304:
2305: delete_ac(tmp_ac_id_in);
2306:
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
2312: where analysis_cycle_id = new_ac_id;
2313:
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
2312: where analysis_cycle_id = new_ac_id;
2313:
2314: IF lock_cursor%ISOPEN THEN
2315: close lock_cursor;
3395:
3396: -- Initialize API return status to success
3397: x_return_status := FND_API.G_RET_STS_SUCCESS;
3398:
3399: l_user_id := fnd_global.user_id;
3400: l_login_id := fnd_global.user_id;
3401: l_object_version_number := 1;
3402: l_hier_count := 1;
3403: l_first_last_flag := null;
3396: -- Initialize API return status to success
3397: x_return_status := FND_API.G_RET_STS_SUCCESS;
3398:
3399: l_user_id := fnd_global.user_id;
3400: l_login_id := fnd_global.user_id;
3401: l_object_version_number := 1;
3402: l_hier_count := 1;
3403: l_first_last_flag := null;
3404: