APPS.LNS_FUNDING_PUB dependencies on AP_INVOICES_INTERFACE

Line 3903: select AP_INVOICES_INTERFACE_S.NEXTVAL from dual;

3899: disb_header_id = P_DISB_HEADER_ID;
3900:
3901: -- generating new invoice id
3902: CURSOR new_inv_id_cur IS
3903: select AP_INVOICES_INTERFACE_S.NEXTVAL from dual;
3904:
3905: -- generating new invoice line id
3906: CURSOR new_inv_ln_id_cur IS
3907: select AP_INVOICE_LINES_INTERFACE_S.NEXTVAL from dual;

Line 3919: from AP_INVOICES_INTERFACE inv,

3915:
3916: -- get party for rejection
3917: CURSOR get_party1_cur(P_ID VARCHAR2) IS
3918: select party.party_name
3919: from AP_INVOICES_INTERFACE inv,
3920: hz_parties party
3921: where inv.INVOICE_ID = P_ID and
3922: inv.party_id = party.party_id;
3923:

Line 3927: from AP_INVOICES_INTERFACE inv,

3923:
3924: -- get party for rejection
3925: CURSOR get_party2_cur(P_ID VARCHAR2) IS
3926: select party.party_name
3927: from AP_INVOICES_INTERFACE inv,
3928: AP_INVOICE_LINES_INTERFACE line,
3929: hz_parties party
3930: where line.INVOICE_LINE_ID = P_ID and
3931: line.INVOICE_ID = inv.INVOICE_ID and

Line 4139: AP_INVOICES_INTERFACE_PKG.INSERT_ROW(

4135: l_new_invoice := 'Y';
4136: -- inserting invoice line
4137: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting AP invoice into interface table...');
4138:
4139: AP_INVOICES_INTERFACE_PKG.INSERT_ROW(
4140: X_ROWID => l_invoice_row_id,
4141: X_INVOICE_ID => l_invoice_id,
4142: X_INVOICE_NUM => l_invoice_number,
4143: X_INVOICE_TYPE_LOOKUP_CODE => 'PAYMENT REQUEST',

Line 4279: AP_INVOICES_INTERFACE_PKG.UPDATE_ROW(

4275:
4276: -- inserting invoice line
4277: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AP invoice into interface table...');
4278:
4279: AP_INVOICES_INTERFACE_PKG.UPDATE_ROW(
4280: X_INVOICE_ID => l_invoice_id,
4281: X_INVOICE_NUM => l_invoice_number,
4282: X_INVOICE_TYPE_LOOKUP_CODE => 'PAYMENT REQUEST',
4283: X_INVOICE_DATE => l_due_date,

Line 4778: if l_rejections(l_Count2).parent_table = 'AP_INVOICES_INTERFACE' then

4774: close get_reject_cur;
4775:
4776: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rejection desc: ' || l_reject_desc);
4777:
4778: if l_rejections(l_Count2).parent_table = 'AP_INVOICES_INTERFACE' then
4779:
4780: -- get party for rejection
4781: open get_party1_cur(l_rejections(l_Count2).parent_id);
4782: fetch get_party1_cur into l_payee;