APPS.IGI_VENDOR_MERGE_GRP dependencies on IGI_EXP_DUS

Line 13: -- Bug 3282938, EXP table IGI_EXP_DUS should be updated for

9: --
10: --
11: -- *************************************************************************
12: -- Procedure : Update_EXP_Tables
13: -- Bug 3282938, EXP table IGI_EXP_DUS should be updated for
14: -- Supplier merge.
15: -- *************************************************************************
16: PROCEDURE update_EXP_tables (p_paid_invoices_flag IN VARCHAR2,
17: p_old_vendor_id IN NUMBER,

Line 36: -- Bug 3282938, EXP table IGI_EXP_DUS should be updated for

32: -- needs updating. If new tables are added which store vendor_id,
33: -- this procedure should be updated to modify the new tables too.
34: -- The AP supplier merge report APXINUPD.rdf which performs all the
35: -- updates on the core table will call this API.
36: -- Bug 3282938, EXP table IGI_EXP_DUS should be updated for
37: -- Supplier merge.
38: -- *************************************************************************
39:
40: PROCEDURE merge_vendor(p_api_version IN NUMBER

Line 175: -- Bug 3282938, EXP table IGI_EXP_DUS should be updated for

171: END merge_vendor;
172:
173: -- *************************************************************************
174: -- Procedure : Update_EXP_Tables
175: -- Bug 3282938, EXP table IGI_EXP_DUS should be updated for
176: -- Supplier merge.
177: -- *************************************************************************
178: PROCEDURE update_EXP_tables (p_paid_invoices_flag IN VARCHAR2,
179: p_old_vendor_id IN NUMBER,

Line 198: UPDATE igi_exp_dus du

194: -- then update all the dialog units irrespective of their status.
195: IF p_paid_invoices_flag = 'Y'
196: THEN
197: -- Update all the Dialog Units associcated with payables.
198: UPDATE igi_exp_dus du
199: SET du.du_stp_id = p_new_vendor_id,
200: du.du_stp_site_id = p_new_vendor_site_id,
201: du.last_update_date = SYSDATE,
202: du.last_update_login = FND_GLOBAL.login_id,

Line 213: UPDATE igi_exp_dus du

209: WHERE application_id = 200) ;
210: ELSE
211: -- User has chosen to update only unpaid invoices
212: -- Update all dialog units which are not completed.
213: UPDATE igi_exp_dus du
214: SET du.du_stp_id = p_new_vendor_id,
215: du.du_stp_site_id = p_new_vendor_site_id,
216: du.last_update_date = SYSDATE,
217: du.last_update_login = FND_GLOBAL.login_id,

Line 230: UPDATE igi_exp_dus du

226:
227: --
228: -- Then update all the dialog units which are completed but
229: -- none of the invoices have been paid.
230: UPDATE igi_exp_dus du
231: SET du.du_stp_id = p_new_vendor_id,
232: du.du_stp_site_id = p_new_vendor_site_id,
233: du.last_update_date = SYSDATE,
234: du.last_update_login = FND_GLOBAL.login_id,