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
334: BEGIN
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:
336: -- Bug 4587184: Modified the query to consider the task id
333: IS
334: BEGIN
335:
336: -- Bug 4587184: Modified the query to consider the task id
337: INSERT INTO zpb_measure_scope_exempt_users
338: (BUSINESS_PROCESS_ENTITY_ID,
339: USER_ID,
340: EXEMPTION_ID,
341: TASK_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;
362:
1154:
1155: DELETE FROM zpb_copy_dim_members
1156: WHERE analysis_cycle_id = ac_id_in;
1157:
1158: DELETE FROM zpb_measure_scope_exempt_users
1159: WHERE BUSINESS_PROCESS_ENTITY_ID = ac_id_in
1160: AND BUSINESS_PROCESS_ENTITY_TYPE = 'A';
1161:
1162: DELETE FROM zpb_cycle_comments