APPS.LNS_FUNDING_PUB dependencies on AP_INVOICES_INTERFACE

Line 3725: select AP_INVOICES_INTERFACE_S.NEXTVAL from dual;

3721: disb_header_id = P_DISB_HEADER_ID;
3722:
3723: -- generating new invoice id
3724: CURSOR new_inv_id_cur IS
3725: select AP_INVOICES_INTERFACE_S.NEXTVAL from dual;
3726:
3727: -- generating new invoice line id
3728: CURSOR new_inv_ln_id_cur IS
3729: select AP_INVOICE_LINES_INTERFACE_S.NEXTVAL from dual;

Line 3741: from AP_INVOICES_INTERFACE inv,

3737:
3738: -- get party for rejection
3739: CURSOR get_party1_cur(P_ID VARCHAR2) IS
3740: select party.party_name
3741: from AP_INVOICES_INTERFACE inv,
3742: hz_parties party
3743: where inv.INVOICE_ID = P_ID and
3744: inv.party_id = party.party_id;
3745:

Line 3749: from AP_INVOICES_INTERFACE inv,

3745:
3746: -- get party for rejection
3747: CURSOR get_party2_cur(P_ID VARCHAR2) IS
3748: select party.party_name
3749: from AP_INVOICES_INTERFACE inv,
3750: AP_INVOICE_LINES_INTERFACE line,
3751: hz_parties party
3752: where line.INVOICE_LINE_ID = P_ID and
3753: line.INVOICE_ID = inv.INVOICE_ID and

Line 3940: AP_INVOICES_INTERFACE_PKG.INSERT_ROW(

3936: l_new_invoice := 'Y';
3937: -- inserting invoice line
3938: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting AP invoice into interface table...');
3939:
3940: AP_INVOICES_INTERFACE_PKG.INSERT_ROW(
3941: X_ROWID => l_invoice_row_id,
3942: X_INVOICE_ID => l_invoice_id,
3943: X_INVOICE_NUM => l_invoice_number,
3944: X_INVOICE_TYPE_LOOKUP_CODE => 'PAYMENT REQUEST',

Line 4080: AP_INVOICES_INTERFACE_PKG.UPDATE_ROW(

4076:
4077: -- inserting invoice line
4078: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AP invoice into interface table...');
4079:
4080: AP_INVOICES_INTERFACE_PKG.UPDATE_ROW(
4081: X_INVOICE_ID => l_invoice_id,
4082: X_INVOICE_NUM => l_invoice_number,
4083: X_INVOICE_TYPE_LOOKUP_CODE => 'PAYMENT REQUEST',
4084: X_INVOICE_DATE => l_due_date,

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

4557: close get_reject_cur;
4558:
4559: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rejection desc: ' || l_reject_desc);
4560:
4561: if l_rejections(l_Count2).parent_table = 'AP_INVOICES_INTERFACE' then
4562:
4563: -- get party for rejection
4564: open get_party1_cur(l_rejections(l_Count2).parent_id);
4565: fetch get_party1_cur into l_payee;