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
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
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
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