APPS.IGI_EXP_UTILS dependencies on AP_INVOICES

Line 763: CURSOR c_ap_invoices(pv_du_id igi_exp_dus_all.du_id%TYPE)

759: l_debug_info VARCHAR2(2000);
760: l_gl_date DATE;
761: l_trx_id NUMBER;
762:
763: CURSOR c_ap_invoices(pv_du_id igi_exp_dus_all.du_id%TYPE)
764: IS
765: SELECT a.invoice_id,
766: a.source,
767: a.cancelled_date,

Line 770: ap_invoices_all a

766: a.source,
767: a.cancelled_date,
768: a.gl_date -- shsaxena bug2777575.
769: FROM igi_exp_ap_trans i,
770: ap_invoices_all a
771: WHERE i.invoice_id = a.invoice_id
772: AND i.du_id = pv_du_id;
773:
774: CURSOR c_ar_trx(pv_du_id igi_exp_dus_all.du_id%TYPE)

Line 904: FOR r_ap_invoices IN c_ap_invoices(p_du_id)LOOP

900: -- Dialog Unit
901: -- 2. Update the GL date
902: -------------------------------------------------------
903:
904: FOR r_ap_invoices IN c_ap_invoices(p_du_id)LOOP
905: -----------------------------
906: l_debug_info := 'in ap loop';
907: --dbms_output.put_line(l_debug_info);
908: ----------------------------------

Line 917: IGI_EXP_HOLDS.Place_Release_Hold(r_ap_invoices.invoice_id,

913: l_debug_info := 'release holds';
914: --dbms_output.put_line(l_debug_info);
915: ----------------------------------
916:
917: IGI_EXP_HOLDS.Place_Release_Hold(r_ap_invoices.invoice_id,
918: '', -- invoice amount Bug 2469158
919: r_ap_invoices.source,
920: r_ap_invoices.cancelled_date,
921: 'R',

Line 919: r_ap_invoices.source,

915: ----------------------------------
916:
917: IGI_EXP_HOLDS.Place_Release_Hold(r_ap_invoices.invoice_id,
918: '', -- invoice amount Bug 2469158
919: r_ap_invoices.source,
920: r_ap_invoices.cancelled_date,
921: 'R',
922: 'AWAIT EXP APP',
923: 'IGI EXP WORKFLOW'

Line 920: r_ap_invoices.cancelled_date,

916:
917: IGI_EXP_HOLDS.Place_Release_Hold(r_ap_invoices.invoice_id,
918: '', -- invoice amount Bug 2469158
919: r_ap_invoices.source,
920: r_ap_invoices.cancelled_date,
921: 'R',
922: 'AWAIT EXP APP',
923: 'IGI EXP WORKFLOW'
924: );

Line 939: WHERE apd.invoice_id = r_ap_invoices.invoice_id

935: SET apd.accounting_date = TRUNC(p_gl_date),
936: apd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
937: apd.last_update_date = SYSDATE,
938: apd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
939: WHERE apd.invoice_id = r_ap_invoices.invoice_id
940: AND apd.posted_flag = 'N';
941:
942:
943: /* dvjoshi bug#5905190 START

Line 950: WHERE apl.invoice_id = r_ap_invoices.invoice_id

946: SET apl.gl_date = TRUNC(p_gl_date),
947: apl.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
948: apl.last_update_date = SYSDATE,
949: apl.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
950: WHERE apl.invoice_id = r_ap_invoices.invoice_id
951: AND EXISTS
952: (SELECT 'x' FROM ap_invoice_distributions aid
953: WHERE aid.invoice_id = apl.invoice_id
954: AND aid.posted_flag = 'N');

Line 958: UPDATE ap_invoices api

954: AND aid.posted_flag = 'N');
955:
956: dvjoshi bug#5905190 END */
957:
958: UPDATE ap_invoices api
959: SET api.gl_date = TRUNC(p_gl_date),
960: api.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
961: api.last_update_date = SYSDATE,
962: api.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)

Line 963: WHERE api.invoice_id = r_ap_invoices.invoice_id

959: SET api.gl_date = TRUNC(p_gl_date),
960: api.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
961: api.last_update_date = SYSDATE,
962: api.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
963: WHERE api.invoice_id = r_ap_invoices.invoice_id
964: AND EXISTS
965: (SELECT 'x' FROM ap_invoice_distributions aid
966: WHERE aid.invoice_id = api.invoice_id
967: AND aid.posted_flag = 'N');

Line 1097: IF c_ap_invoices%ISOPEN THEN

1093:
1094:
1095: WHEN OTHERS THEN
1096:
1097: IF c_ap_invoices%ISOPEN THEN
1098: CLOSE c_ap_invoices;
1099: ELSIF c_ar_trx%ISOPEN THEN
1100: CLOSE c_ar_trx;
1101: END IF;

Line 1098: CLOSE c_ap_invoices;

1094:
1095: WHEN OTHERS THEN
1096:
1097: IF c_ap_invoices%ISOPEN THEN
1098: CLOSE c_ap_invoices;
1099: ELSIF c_ar_trx%ISOPEN THEN
1100: CLOSE c_ar_trx;
1101: END IF;
1102: