DBA Data[Home] [Help]

APPS.AP_XML_INVOICE_INBOUND_PKG dependencies on AP_LOOKUP_CODES

Line 9: from ap_lookup_codes

5:
6: l_displayed_field VARCHAR2(80);
7: cursor l_token_csr(c_lookup_code in VARCHAR2) is
8: select displayed_field
9: from ap_lookup_codes
10: where lookup_type = 'XML TOKEN NAME'
11: and lookup_code = p_lookup_code;
12:
13: begin

Line 330: from ap_lookup_codes

326: p_calling_sequence VARCHAR2) as
327:
328: cursor l_invoice_line_number_csr is
329: select fnd_global.tab||displayed_field||': '
330: from ap_lookup_codes
331: where lookup_type = 'XML TOKEN NAME' and
332: lookup_code = 'INVOICE LINE NUMBER';
333:
334: cursor l_invoice_number_csr is

Line 336: from ap_lookup_codes

332: lookup_code = 'INVOICE LINE NUMBER';
333:
334: cursor l_invoice_number_csr is
335: select displayed_field||': '
336: from ap_lookup_codes
337: where lookup_type = 'XML TOKEN NAME' and
338: lookup_code = 'INVOICE NUMBER';
339:
340: cursor l_email_csr(c_request_id in NUMBER) is

Line 397: ap_lookup_codes lc

393: -- Bug 4065112 ends
394:
395: from ap_invoices_interface h,
396: ap_interface_rejections r,
397: ap_lookup_codes lc
398: where h.request_id = c_request_id
399: and nvl(r.notify_vendor_flag, 'N') = 'Y'
400: and h.invoice_id = r.parent_id
401: and r.parent_table = 'AP_INVOICES_INTERFACE'

Line 455: ap_lookup_codes lc

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
458: and nvl(r.notify_vendor_flag, 'N') = 'Y'
459: and l.invoice_line_id = r.parent_id