APPS.PA_DEDUCTIONS dependencies on AP_INVOICE_LINES_INTERFACE

Line 65: -- This procedure is to create entries into ap_invoice_lines_interface

61: ,p_description IN VARCHAR2
62: ,p_tax_flag IN VARCHAR2
63: ,p_org_id IN NUMBER );
64:
65: -- This procedure is to create entries into ap_invoice_lines_interface
66: Procedure Create_Invoice_Line (
67: p_invoice_id IN NUMBER
68: ,p_amount IN NUMBER
69: ,p_accounting_date IN DATE

Line 1744: SELECT ap_invoice_lines_interface_s.nextval

1740: Begin
1741: g_api_name := 'Create_Invoice_Line';
1742: log_message ('Before inserting lines into interface lines table', g_api_name);
1743:
1744: SELECT ap_invoice_lines_interface_s.nextval
1745: INTO l_invoice_line_id
1746: FROM sys.dual;
1747:
1748: IF P_DEBUG_MODE = 'Y' THEN

Line 1752: INSERT INTO AP_INVOICE_LINES_INTERFACE (

1748: IF P_DEBUG_MODE = 'Y' THEN
1749: log_message ('Invoice Line Id : '||l_invoice_line_id, g_api_name);
1750: END IF;
1751:
1752: INSERT INTO AP_INVOICE_LINES_INTERFACE (
1753: invoice_id
1754: ,invoice_line_id
1755: ,line_type_lookup_code
1756: ,amount

Line 1857: from AP_INVOICE_LINES_INTERFACE al

1853: pta.task_number task_num,
1854: al.expenditure_type exp_type,
1855: hr.name exp_org,
1856: al.amount
1857: from AP_INVOICE_LINES_INTERFACE al
1858: , ap_interface_rejections ar,
1859: AP_INVOICES_INTERFACE ad,
1860: pa_tasks pta,hr_organization_units hr,
1861: fnd_lookup_values lookup

Line 1863: and ar.parent_table='AP_INVOICE_LINES_INTERFACE'

1859: AP_INVOICES_INTERFACE ad,
1860: pa_tasks pta,hr_organization_units hr,
1861: fnd_lookup_values lookup
1862: where ar.parent_id=al.invoice_line_id
1863: and ar.parent_table='AP_INVOICE_LINES_INTERFACE'
1864: and al.invoice_id=ad.invoice_id
1865: and ad.product_table = 'PA_DEDUCTIONS_ALL'
1866: and al.task_id=pta.task_id
1867: and hr.organization_id=al.expenditure_organization_id

Line 2163: DELETE AP_INVOICE_LINES_INTERFACE WHERE invoice_id IN(

2159: PROCEDURE Delete_Failed_Rec(p_dctn_req_id NUMBER) IS
2160: BEGIN
2161: NULL;
2162:
2163: DELETE AP_INVOICE_LINES_INTERFACE WHERE invoice_id IN(
2164: SELECT invoice_id FROM AP_INVOICES_INTERFACE WHERE
2165: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id));
2166:
2167: DELETE AP_INVOICES_INTERFACE WHERE