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_INVOICE_LINES_INTERFACE

Line 605: AP_IMPORT_INVOICES_PKG.g_invoice_lines_table := 'AP_INVOICE_LINES_INTERFACE';

601: AP_IMPORT_INVOICES_PKG.g_invoice_lines_table := 'AP_PPA_INVOICE_LINES_GT';
602: AP_IMPORT_INVOICES_PKG.g_instructions_table := 'AP_PPA_INSTRUCTIONS_GT';
603: ELSE
604: AP_IMPORT_INVOICES_PKG.g_invoices_table := 'AP_INVOICES_INTERFACE';
605: AP_IMPORT_INVOICES_PKG.g_invoice_lines_table := 'AP_INVOICE_LINES_INTERFACE';
606: AP_IMPORT_INVOICES_PKG.g_instructions_table := NULL;
607: END IF;
608:
609: -- Bug 5448579

Line 850: WHERE parent_table = 'AP_INVOICE_LINES_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));
854: END IF;

Line 852: FROM ap_invoice_lines_interface

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));
854: END IF;
855: --Start of Bug 6801046
856: debug_info := '(Check_lines 3c) Update requestid on the Selected Invoices';

Line 3280: -- Step 3, Delete records for ap_invoice_lines_interface

3276: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
3277: END IF;
3278:
3279: ------------------------------------------------------------------------
3280: -- Step 3, Delete records for ap_invoice_lines_interface
3281: -- Multiple lines
3282: ------------------------------------------------------------------------
3283: debug_info := '(Import_purge 3) Delete records in ' ||
3284: 'ap_invoice_lines_interface...';

Line 3284: 'ap_invoice_lines_interface...';

3280: -- Step 3, Delete records for ap_invoice_lines_interface
3281: -- Multiple lines
3282: ------------------------------------------------------------------------
3283: debug_info := '(Import_purge 3) Delete records in ' ||
3284: 'ap_invoice_lines_interface...';
3285: IF AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' THEN
3286: AP_IMPORT_UTILITIES_PKG.Print(
3287: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
3288: END IF;

Line 3290: DELETE FROM AP_INVOICE_LINES_INTERFACE

3286: AP_IMPORT_UTILITIES_PKG.Print(
3287: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
3288: END IF;
3289:
3290: DELETE FROM AP_INVOICE_LINES_INTERFACE
3291: WHERE invoice_id = l_invoice_id;
3292:
3293: ------------------------------------------------------------------------
3294: -- Step 4, Delete records for ap_invoices_interface

Line 3449: ap_invoice_lines_interface l,

3445: IF (p_group_id IS NULL) THEN
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)

Line 3453: 'AP_INVOICE_LINES_INTERFACE', l.invoice_line_id)

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
3455: AND h.invoice_id = l.invoice_id
3456: AND nvl(r.notify_vendor_flag,'N') = 'Y'
3457: AND h.status = 'REJECTED'

Line 3469: ap_invoice_lines_interface l,

3465: ELSE
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)

Line 3473: 'AP_INVOICE_LINES_INTERFACE', l.invoice_line_id)

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
3475: AND h.invoice_id = l.invoice_id
3476: AND nvl(r.notify_vendor_flag,'N') = 'Y'
3477: AND h.status = 'REJECTED'

Line 3516: FROM ap_invoice_lines_interface l

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';
3519:
3520: debug_info := '(XML Import Purge 4) before deleting header interface';

Line 3518: AND r.parent_table = 'AP_INVOICE_LINES_INTERFACE';

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';
3519:
3520: debug_info := '(XML Import Purge 4) before deleting header interface';
3521: IF AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' THEN
3522: AP_IMPORT_UTILITIES_PKG.Print(

Line 3526: -- Delete from ap_invoice_lines_interface table

3522: AP_IMPORT_UTILITIES_PKG.Print(
3523: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
3524: END IF;
3525:
3526: -- Delete from ap_invoice_lines_interface table
3527: FORALL i IN nvl(h_list.FIRST,0) .. nvl(h_list.LAST,-1)
3528: DELETE FROM ap_invoice_lines_interface l
3529: WHERE l.invoice_id = h_list(i);
3530:

Line 3528: DELETE FROM ap_invoice_lines_interface l

3524: END IF;
3525:
3526: -- Delete from ap_invoice_lines_interface table
3527: FORALL i IN nvl(h_list.FIRST,0) .. nvl(h_list.LAST,-1)
3528: DELETE FROM ap_invoice_lines_interface l
3529: WHERE l.invoice_id = h_list(i);
3530:
3531: debug_info := '(XML Import Purge 5) before deleting line interface';
3532: IF AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' THEN

Line 3607: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'

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);
3611:

Line 3609: FROM ap_invoice_lines_interface

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);
3611:
3612: BEGIN
3613: