DBA Data[Home] [Help]

APPS.IGIPMSDA dependencies on IGI_MPP_AP_INVOICES

Line 104: FROM igi_mpp_ap_invoices

100: FUNCTION InvoiceExists ( cp_invoice_id in number )
101: RETURN BOOLEAN IS
102: CURSOR c_exists IS
103: SELECT 'x'
104: FROM igi_mpp_ap_invoices
105: WHERE invoice_id = cp_invoice_id
106: ;
107: BEGIN
108: FOR l_exists IN C_exists LOOP

Line 220: INSERT INTO igi_mpp_ap_invoices

216: FND_LOG.STRING (l_state_level , 'igi.plsql.igipmsdb.IGIPMSDA.SynchronizeInvoice',
217: '>> Invoice Does not exist in MPP extended table. Inserting...');
218: END IF;
219: --bug 3199481 fnd logging changes: sdixit: end block
220: INSERT INTO igi_mpp_ap_invoices
221: ( invoice_id
222: , accounting_rule_id
223: , ignore_mpp_flag
224: , created_by

Line 375: FROM igi_mpp_ap_invoices

371: FUNCTION IsTransferOK ( fp_invoice_id in number )
372: RETURN BOOLEAN IS
373: CURSOR c_trx IS
374: SELECT 'x'
375: FROM igi_mpp_ap_invoices
376: WHERE invoice_id = fp_invoice_id
377: ;
378: BEGIN
379: FOR l_trx in c_trx LOOP

Line 455: FROM igi_mpp_ap_invoices

451: )
452: RETURN BOOLEAN IS
453: CURSOR c_igi_inv IS
454: SELECT 'x'
455: FROM igi_mpp_ap_invoices
456: WHERE invoice_id = fp_invoice_id
457: ;
458: b_rec_found BOOLEAN ;
459: BEGIN