APPS.CLN_NTFYINVC_PKG dependencies on AP_INVOICES_INTERFACE

Line 18: AND PARENT_TABLE = 'AP_INVOICES_INTERFACE';

14: CURSOR c_header_errors IS
15: SELECT PARENT_ID, REJECT_LOOKUP_CODE
16: FROM AP_INTERFACE_REJECTIONS
17: WHERE PARENT_ID = p_invoice_id
18: AND PARENT_TABLE = 'AP_INVOICES_INTERFACE';
19:
20: CURSOR c_line_errors IS
21: SELECT PARENT_ID, REJECT_LOOKUP_CODE
22: FROM AP_INTERFACE_REJECTIONS

Line 43: WHERE parent_table = 'AP_INVOICES_INTERFACE'

39: FROM DUAL
40: WHERE EXISTS (
41: SELECT 'x'
42: FROM ap_interface_rejections air
43: WHERE parent_table = 'AP_INVOICES_INTERFACE'
44: AND parent_id = p_invoice_id
45: UNION ALL
46: SELECT 'x'
47: FROM ap_interface_rejections air

Line 1571: UPDATE ap_invoices_interface

1567: IF (l_debug_level <= 1) THEN
1568: cln_debug_pub.Add('l_db_inv_date:' || l_db_inv_date, 1);
1569: END IF;
1570:
1571: UPDATE ap_invoices_interface
1572: SET INVOICE_CURRENCY_CODE = p_inv_curr_code,
1573: INVOICE_AMOUNT = P_inv_amount,
1574: INVOICE_DATE = l_db_inv_date,
1575: INVOICE_NUM = p_proprietary_doc_identifier,

Line 1584: cln_debug_pub.Add('Update ap_invoices_interface, is successful' , 1);

1580:
1581: x_msg_data :='SUCCESS';
1582:
1583: IF (l_debug_level <= 1) THEN
1584: cln_debug_pub.Add('Update ap_invoices_interface, is successful' , 1);
1585: cln_debug_pub.Add('x_return_status: '|| x_return_status , 1);
1586: cln_debug_pub.Add('x_msg_data: '|| x_msg_data , 1);
1587:
1588: END IF;

Line 1758: AND PARENT_TABLE = 'AP_INVOICES_INTERFACE';

1754: CURSOR c_header_errors IS
1755: SELECT PARENT_ID, REJECT_LOOKUP_CODE
1756: FROM AP_INTERFACE_REJECTIONS
1757: WHERE PARENT_ID = p_invoice_id
1758: AND PARENT_TABLE = 'AP_INVOICES_INTERFACE';
1759:
1760: CURSOR c_line_errors IS
1761: SELECT PARENT_ID, REJECT_LOOKUP_CODE
1762: FROM AP_INTERFACE_REJECTIONS

Line 1789: FROM ap_invoices_interface

1785: l_internal_control_number := p_group_id;
1786:
1787: SELECT invoice_num, invoice_date, invoice_amount, po_number
1788: INTO l_invoice_number, l_invoice_date, l_invoice_amount, l_po_number
1789: FROM ap_invoices_interface
1790: WHERE invoice_id = p_invoice_id;
1791:
1792: IF (l_Debug_Level <= 1) THEN
1793: cln_debug_pub.Add('Before inserting data into CLN_AP_INVOICE_REJECTION_ARCH', 1);

Line 1862: FROM ap_invoices_interface

1858:
1859: BEGIN
1860: SELECT invoice_num, po_number, invoice_amount, invoice_date
1861: INTO x_invoice_num, x_po_num, x_invoice_amt, x_invoice_date
1862: FROM ap_invoices_interface
1863: WHERE invoice_id = p_invoice_id;
1864: EXCEPTION
1865: WHEN NO_DATA_FOUND THEN
1866: IF (l_debug_level <= 1) THEN

Line 1867: cln_debug_pub.Add('rows not available in ap_invoices_interface. Querying CLN_AP_INVOICE_REJECTION_ARCH',1);

1863: WHERE invoice_id = p_invoice_id;
1864: EXCEPTION
1865: WHEN NO_DATA_FOUND THEN
1866: IF (l_debug_level <= 1) THEN
1867: cln_debug_pub.Add('rows not available in ap_invoices_interface. Querying CLN_AP_INVOICE_REJECTION_ARCH',1);
1868: END IF;
1869: --The following query should not error out... If it errors out, Its an exception condition
1870: SELECT invoice_number, po_number, invoice_amount, invoice_date
1871: INTO x_invoice_num, x_po_num, x_invoice_amt, x_invoice_date