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
372:
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
374: -- Bug 4587184: Consider task_id in the query
371: IS
372:
373: BEGIN
374: -- Bug 4587184: Consider task_id in the query
375: INSERT INTO zpb_business_process_scope
376: (ANALYSIS_CYCLE_ID,
377: TASK_ID,
378: RESTRICTION_TYPE,
379: START_TIME_TYPE,
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:
418: END copy_bp_scope_access_recs;
1148: DELETE FROM zpb_analysis_cycle_tasks
1149: WHERE analysis_cycle_id = ac_id_in;
1150: END IF;
1151:
1152: DELETE FROM zpb_business_process_scope
1153: WHERE analysis_cycle_id = ac_id_in;
1154:
1155: DELETE FROM zpb_copy_dim_members
1156: WHERE analysis_cycle_id = ac_id_in;