APPS.LNS_FUNDING_PUB dependencies on AP_INVOICE_LINES_INTERFACE

Line 3907: select AP_INVOICE_LINES_INTERFACE_S.NEXTVAL from dual;

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;
3908:
3909: -- get rejection description
3910: CURSOR get_reject_cur(P_CODE VARCHAR2) IS
3911: select description

Line 3928: AP_INVOICE_LINES_INTERFACE line,

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
3932: inv.party_id = party.party_id;

Line 4429: delete from AP_INVOICE_LINES_INTERFACE

4425:
4426: -- Deleting invoice interface lines
4427: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting invoice interface lines...');
4428:
4429: delete from AP_INVOICE_LINES_INTERFACE
4430: where INVOICE_ID = l_invoice_id;
4431:
4432: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleted');
4433:

Line 4524: AP_INVOICE_LINES_INTERFACE_PKG.INSERT_ROW(

4520: END IF;
4521:
4522:
4523:
4524: AP_INVOICE_LINES_INTERFACE_PKG.INSERT_ROW(
4525: X_ROWID => l_inv_line_row_id,
4526: X_INVOICE_ID => l_invoice_id,
4527: X_INVOICE_LINE_ID => l_invoice_line_id,
4528: X_LINE_NUMBER => l_Count1,

Line 4785: elsif l_rejections(l_Count2).parent_table = 'AP_INVOICE_LINES_INTERFACE' then

4781: open get_party1_cur(l_rejections(l_Count2).parent_id);
4782: fetch get_party1_cur into l_payee;
4783: close get_party1_cur;
4784:
4785: elsif l_rejections(l_Count2).parent_table = 'AP_INVOICE_LINES_INTERFACE' then
4786:
4787: -- get party for rejection
4788: open get_party2_cur(l_rejections(l_Count2).parent_id);
4789: fetch get_party2_cur into l_payee;