APPS.CLN_NTFYINVC_PKG dependencies on AP_INTERFACE_REJECTIONS

Line 9: l_parent_id AP_INTERFACE_REJECTIONS.PARENT_ID%TYPE;

5:
6: FUNCTION GET_AR_REJECTIONS_STRING(p_invoice_id IN NUMBER)
7: RETURN VARCHAR2 IS
8:
9: l_parent_id AP_INTERFACE_REJECTIONS.PARENT_ID%TYPE;
10: l_reject_code AP_INTERFACE_REJECTIONS.REJECT_LOOKUP_CODE%TYPE;
11: l_error_reject_string VARCHAR2(2000);
12: l_count_failed_rows VARCHAR2(10);
13:

Line 10: l_reject_code AP_INTERFACE_REJECTIONS.REJECT_LOOKUP_CODE%TYPE;

6: FUNCTION GET_AR_REJECTIONS_STRING(p_invoice_id IN NUMBER)
7: RETURN VARCHAR2 IS
8:
9: l_parent_id AP_INTERFACE_REJECTIONS.PARENT_ID%TYPE;
10: l_reject_code AP_INTERFACE_REJECTIONS.REJECT_LOOKUP_CODE%TYPE;
11: l_error_reject_string VARCHAR2(2000);
12: l_count_failed_rows VARCHAR2(10);
13:
14: CURSOR c_header_errors IS

Line 16: FROM AP_INTERFACE_REJECTIONS

12: l_count_failed_rows VARCHAR2(10);
13:
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

Line 22: FROM AP_INTERFACE_REJECTIONS

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
23: WHERE PARENT_ID in (SELECT INVOICE_LINE_ID FROM AP_INVOICE_LINES_INTERFACE WHERE INVOICE_ID = p_invoice_id)
24: AND PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE';
25:
26: BEGIN

Line 42: FROM ap_interface_rejections air

38: INTO l_count_failed_rows
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'

Line 47: 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
48: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
49: AND parent_id in (select invoice_line_id from ap_invoice_lines_interface aili
50: where aili.invoice_id = p_invoice_id)
51: );

Line 1756: FROM AP_INTERFACE_REJECTIONS

1752: l_po_number VARCHAR2(100);
1753:
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

Line 1762: FROM AP_INTERFACE_REJECTIONS

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
1763: WHERE PARENT_ID in (SELECT INVOICE_LINE_ID FROM AP_INVOICE_LINES_INTERFACE WHERE INVOICE_ID = p_invoice_id)
1764: AND PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE';
1765:
1766: BEGIN