206: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
207: END copy_ac_param_values_recs;
208:
209: PROCEDURE copy_cycle_currency_recs (
210: source_ac_id_in IN zpb_cycle_currencies.analysis_cycle_id%TYPE,
211: target_ac_id_in IN zpb_cycle_currencies.analysis_cycle_id%TYPE)
212: IS
213: BEGIN
214: INSERT INTO zpb_cycle_currencies
207: END copy_ac_param_values_recs;
208:
209: PROCEDURE copy_cycle_currency_recs (
210: source_ac_id_in IN zpb_cycle_currencies.analysis_cycle_id%TYPE,
211: target_ac_id_in IN zpb_cycle_currencies.analysis_cycle_id%TYPE)
212: IS
213: BEGIN
214: INSERT INTO zpb_cycle_currencies
215: (ANALYSIS_CYCLE_ID,
210: source_ac_id_in IN zpb_cycle_currencies.analysis_cycle_id%TYPE,
211: target_ac_id_in IN zpb_cycle_currencies.analysis_cycle_id%TYPE)
212: IS
213: BEGIN
214: INSERT INTO zpb_cycle_currencies
215: (ANALYSIS_CYCLE_ID,
216: CURRENCY_CODE,
217: CREATED_BY,
218: CREATION_DATE,
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;
233:
1197:
1198: DELETE FROM zpb_line_dimensionality
1199: WHERE analysis_cycle_id = ac_id_in;
1200:
1201: DELETE FROM zpb_cycle_currencies
1202: WHERE analysis_cycle_id = ac_id_in;
1203:
1204: DELETE FROM zpb_bp_external_users
1205: WHERE analysis_cycle_id = ac_id_in;