APPS.ZPB_AC_OPS dependencies on ZPB_BP_EXTERNAL_USERS

Line 235: source_ac_id_in IN zpb_bp_external_users.analysis_cycle_id%TYPE,

231:
232: END copy_cycle_currency_recs;
233:
234: PROCEDURE copy_external_user_recs (
235: source_ac_id_in IN zpb_bp_external_users.analysis_cycle_id%TYPE,
236: target_ac_id_in IN zpb_bp_external_users.analysis_cycle_id%TYPE)
237: IS
238: BEGIN
239: INSERT INTO zpb_bp_external_users

Line 236: target_ac_id_in IN zpb_bp_external_users.analysis_cycle_id%TYPE)

232: END copy_cycle_currency_recs;
233:
234: PROCEDURE copy_external_user_recs (
235: source_ac_id_in IN zpb_bp_external_users.analysis_cycle_id%TYPE,
236: target_ac_id_in IN zpb_bp_external_users.analysis_cycle_id%TYPE)
237: IS
238: BEGIN
239: INSERT INTO zpb_bp_external_users
240: (ANALYSIS_CYCLE_ID,

Line 239: INSERT INTO zpb_bp_external_users

235: source_ac_id_in IN zpb_bp_external_users.analysis_cycle_id%TYPE,
236: target_ac_id_in IN zpb_bp_external_users.analysis_cycle_id%TYPE)
237: IS
238: BEGIN
239: INSERT INTO zpb_bp_external_users
240: (ANALYSIS_CYCLE_ID,
241: USER_ID,
242: CREATED_BY,
243: CREATION_DATE,

Line 254: FROM zpb_bp_external_users

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;
258:

Line 1204: DELETE FROM zpb_bp_external_users

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;
1206:
1207: DELETE FROM ZPB_BP_VALIDATION_RESULTS
1208: WHERE BUS_PROC_ID = ac_id_in;