eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IMPORT_INVOICES_PKG dependencies on AP_INTERFACE_REJECTIONS

Line 543: TYPE numlist is TABLE OF ap_interface_rejections.parent_id%TYPE;

539:
540: l_allow_interest_invoices VARCHAR2(1); --bugfix:4113223
541: l_option_defined_org NUMBER; -- bug 5140002
542:
543: TYPE numlist is TABLE OF ap_interface_rejections.parent_id%TYPE;
544:
545: enums numlist;
546: --bug:4930111
547: l_add_days_settlement_date NUMBER;

Line 831: debug_info := '(Check_lines 3b) Delete invoices from ap_interface_rejections';

827: or (p_org_id is NULL AND
828: org_id is NULL));
829: END IF;
830:
831: debug_info := '(Check_lines 3b) Delete invoices from ap_interface_rejections';
832:
833: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
834: AP_IMPORT_UTILITIES_PKG.Print(
835: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);

Line 839: --The PPA Rejections will be deleted from ap_interface_rejections

835: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
836: END IF;
837:
838: -- Retropricing
839: --The PPA Rejections will be deleted from ap_interface_rejections
840: -- in the After Report Trigger of APXIIMPT.
841: IF enums.COUNT > 0 THEN
842:
843: ForALL i IN enums.FIRST .. enums.LAST

Line 844: DELETE FROM ap_interface_rejections

840: -- in the After Report Trigger of APXIIMPT.
841: IF enums.COUNT > 0 THEN
842:
843: ForALL i IN enums.FIRST .. enums.LAST
844: DELETE FROM ap_interface_rejections
845: WHERE parent_table = 'AP_INVOICES_INTERFACE'
846: AND parent_id = enums(i);
847:
848: ForALL i IN enums.FIRST .. enums.LAST

Line 849: DELETE FROM ap_interface_rejections

845: WHERE parent_table = 'AP_INVOICES_INTERFACE'
846: AND parent_id = enums(i);
847:
848: ForALL i IN enums.FIRST .. enums.LAST
849: DELETE FROM ap_interface_rejections
850: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
851: AND parent_id IN (SELECT invoice_line_id
852: FROM ap_invoice_lines_interface
853: WHERE invoice_id = enums(i));

Line 3450: ap_interface_rejections r

3446: SELECT h.invoice_id BULK COLLECT
3447: INTO h_list
3448: FROM ap_invoices_interface h,
3449: ap_invoice_lines_interface l,
3450: ap_interface_rejections r
3451: WHERE DECODE(r.parent_table, 'AP_INVOICES_INTERFACE',
3452: h.invoice_id,
3453: 'AP_INVOICE_LINES_INTERFACE', l.invoice_line_id)
3454: = r.parent_id

Line 3470: ap_interface_rejections r

3466: SELECT h.invoice_id BULK COLLECT
3467: INTO h_list
3468: FROM ap_invoices_interface h,
3469: ap_invoice_lines_interface l,
3470: ap_interface_rejections r
3471: WHERE DECODE(r.parent_table, 'AP_INVOICES_INTERFACE',
3472: h.invoice_id,
3473: 'AP_INVOICE_LINES_INTERFACE', l.invoice_line_id)
3474: = r.parent_id

Line 3503: DELETE FROM ap_interface_rejections r

3499: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
3500: END IF;
3501:
3502: FORALL i IN nvl(h_list.FIRST,0) .. nvl(h_list.LAST,-1)
3503: DELETE FROM ap_interface_rejections r
3504: WHERE r.parent_id = h_list(i)
3505: AND r.parent_table = 'AP_INVOICES_INTERFACE';
3506:
3507: debug_info := '(XML Import Purge 3) before deleting line rejections';

Line 3514: DELETE FROM ap_interface_rejections r

3510: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
3511: END IF;
3512:
3513: FORALL i IN nvl(h_list.FIRST,0) .. nvl(h_list.LAST,-1)
3514: DELETE FROM ap_interface_rejections r
3515: WHERE r.parent_id IN (SELECT l.invoice_line_id
3516: FROM ap_invoice_lines_interface l
3517: WHERE l.invoice_id = h_list(i) )
3518: AND r.parent_table = 'AP_INVOICE_LINES_INTERFACE';

Line 3599: FROM ap_interface_rejections

3595: CURSOR c_rejections IS
3596: SELECT parent_table,
3597: parent_id,
3598: reject_lookup_code
3599: FROM ap_interface_rejections
3600: WHERE parent_table = 'AP_INVOICES_INTERFACE'
3601: AND parent_id = p_invoice_interface_id
3602: UNION
3603: SELECT parent_table,

Line 3606: FROM ap_interface_rejections

3602: UNION
3603: SELECT parent_table,
3604: parent_id,
3605: reject_lookup_code
3606: FROM ap_interface_rejections
3607: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
3608: AND parent_id IN (SELECT invoice_line_id
3609: FROM ap_invoice_lines_interface
3610: WHERE invoice_id = p_invoice_interface_id);