DBA Data[Home] [Help]

APPS.ZPB_AC_OPS dependencies on ZPB_CYCLE_CURRENCIES

Line 210: source_ac_id_in IN zpb_cycle_currencies.analysis_cycle_id%TYPE,

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

Line 211: target_ac_id_in IN zpb_cycle_currencies.analysis_cycle_id%TYPE)

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,

Line 214: INSERT INTO zpb_cycle_currencies

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,

Line 229: FROM zpb_cycle_currencies

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:

Line 1201: DELETE FROM zpb_cycle_currencies

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;