[Home] [Help]
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;
3730:
3731: -- get rejection description
3732: CURSOR get_reject_cur(P_CODE VARCHAR2) IS
3733: select description
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
3754: inv.party_id = party.party_id;
4226:
4227: -- Deleting invoice interface lines
4228: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting invoice interface lines...');
4229:
4230: delete from AP_INVOICE_LINES_INTERFACE
4231: where INVOICE_ID = l_invoice_id;
4232:
4233: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleted');
4234:
4303: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Description: ' || l_description);
4304: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Accounting Date: ' || l_due_date);
4305: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DIST_CODE_COMBINATION_ID: ' || l_cc_id);
4306:
4307: AP_INVOICE_LINES_INTERFACE_PKG.INSERT_ROW(
4308: X_ROWID => l_inv_line_row_id,
4309: X_INVOICE_ID => l_invoice_id,
4310: X_INVOICE_LINE_ID => l_invoice_line_id,
4311: X_LINE_NUMBER => l_Count1,
4564: open get_party1_cur(l_rejections(l_Count2).parent_id);
4565: fetch get_party1_cur into l_payee;
4566: close get_party1_cur;
4567:
4568: elsif l_rejections(l_Count2).parent_table = 'AP_INVOICE_LINES_INTERFACE' then
4569:
4570: -- get party for rejection
4571: open get_party2_cur(l_rejections(l_Count2).parent_id);
4572: fetch get_party2_cur into l_payee;