APPS.AP_XML_INVOICE_INBOUND_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 32: update ap_invoice_lines_interface

28: begin
29: ap_debug_pkg.print('Y',
30: 'AP_XML_INVOICE_INBOUND_PKG.correct_freight_line(+)');
31:
32: update ap_invoice_lines_interface
33: set DIST_CODE_COMBINATION_ID =
34: (select FREIGHT_CODE_COMBINATION_ID
35: from ap_system_parameters_all sys,ap_invoices_interface h
36: where sys.org_id = h.org_id and h.invoice_id = p_invoice_id)

Line 55: UPDATE AP_INVOICE_LINES_INTERFACE

51: procedure correct_line_type(p_invoice_id in number) as
52: begin
53: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND.correct_line_type(+)');
54: --
55: UPDATE AP_INVOICE_LINES_INTERFACE
56: SET LINE_TYPE_LOOKUP_CODE = 'MISCELLANEOUS'
57: WHERE LINE_TYPE_LOOKUP_CODE NOT IN ('ITEM', 'TAX', 'FREIGHT') and
58: INVOICE_ID = p_invoice_id;
59: --

Line 453: ap_invoice_lines_interface l,

449: -- Bug 4065112 starts
450: ,group_id, external_doc_ref
451: -- Bug 4065112 ends
452: from ap_invoices_interface h,
453: ap_invoice_lines_interface l,
454: ap_interface_rejections r,
455: ap_lookup_codes lc
456: where h.request_id = c_request_id
457: and h.invoice_id = l.invoice_id

Line 460: and r.parent_table = 'AP_INVOICE_LINES_INTERFACE'

456: where h.request_id = c_request_id
457: and h.invoice_id = l.invoice_id
458: and nvl(r.notify_vendor_flag, 'N') = 'Y'
459: and l.invoice_line_id = r.parent_id
460: and r.parent_table = 'AP_INVOICE_LINES_INTERFACE'
461: and h.vendor_email_address = c_vendor_email_address
462: and lc.lookup_code = r.reject_lookup_code
463: and lc.lookup_type = 'REJECT CODE'
464: order by 1, 2;

Line 833: UPDATE ap_invoice_lines_interface

829: begin
830:
831: -- if any tax line is not affiliated with a particular item line
832: -- affiliate it with all item lines
833: UPDATE ap_invoice_lines_interface
834: SET taxable_flag = 'Y'
835: WHERE line_type_lookup_code = 'ITEM'
836: AND invoice_id IN
837: (SELECT h.invoice_id

Line 838: FROM ap_invoices_interface h, ap_invoice_lines_interface l

834: SET taxable_flag = 'Y'
835: WHERE line_type_lookup_code = 'ITEM'
836: AND invoice_id IN
837: (SELECT h.invoice_id
838: FROM ap_invoices_interface h, ap_invoice_lines_interface l
839: WHERE h.invoice_id = l.invoice_id
840: AND h.source = 'XML GATEWAY'
841: AND h.group_id = p_group_id
842: AND l.line_type_lookup_code = 'TAX'

Line 860: UPDATE ap_invoice_lines_interface

856: +===========================================================================*/
857: procedure set_taxable_flag2(p_item_line_id in number) as
858: begin
859:
860: UPDATE ap_invoice_lines_interface
861: SET taxable_flag = 'Y'
862: WHERE invoice_line_id = p_item_line_id;
863:
864: end set_taxable_flag2;

Line 936: UPDATE AP_INVOICE_LINES_INTERFACE

932: NVL(l_org_id,TO_NUMBER(NVL(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
933: ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10)), '-99')));
934:
935: -- update freight and misc lines
936: UPDATE AP_INVOICE_LINES_INTERFACE
937: SET DIST_CODE_COMBINATION_ID =
938: decode(LINE_TYPE_LOOKUP_CODE,'FREIGHT',l_freight_ccid,
939: 'MISCELLANEOUS',l_misc_ccid),
940: PRORATE_ACROSS_FLAG =