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_VALIDATION_PKG dependencies on AP_INVOICES

Line 56: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;

52: l_current_invoice_status VARCHAR2(1) := 'Y';
53: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
54: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
55: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
56: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
57: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;

Line 57: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

53: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
54: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
55: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
56: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
57: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;

Line 58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

54: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
55: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
56: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
57: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866

Line 59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

55: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
56: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
57: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;

Line 60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;

56: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
57: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;

Line 61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;

57: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;

Line 62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866

58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;

Line 63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;

59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
67: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;

Line 64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;

60: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
67: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
68: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;

Line 65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;

61: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
67: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
68: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
69: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;

Line 66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;

62: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
67: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
68: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
69: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;
70: l_temp_invoice_status VARCHAR2(1) := 'Y';

Line 67: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;

63: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
67: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
68: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
69: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;
70: l_temp_invoice_status VARCHAR2(1) := 'Y';
71: l_po_exists_flag VARCHAR2(1) := 'N';

Line 68: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;

64: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
67: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
68: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
69: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;
70: l_temp_invoice_status VARCHAR2(1) := 'Y';
71: l_po_exists_flag VARCHAR2(1) := 'N';
72: current_calling_sequence VARCHAR2(2000);

Line 69: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;

65: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
66: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
67: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
68: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
69: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;
70: l_temp_invoice_status VARCHAR2(1) := 'Y';
71: l_po_exists_flag VARCHAR2(1) := 'N';
72: current_calling_sequence VARCHAR2(2000);
73: debug_info VARCHAR2(500);

Line 255: THEN UPDATE ap_invoices_interface

251:
252: --added nvl for bug 7314487
253: IF l_temp_vendor_id is NULL
254: AND nvl(p_invoice_rec.invoice_type_lookup_code,'STANDARD') <> 'PAYMENT REQUEST'
255: THEN UPDATE ap_invoices_interface
256: SET vendor_id = l_vendor_id
257: WHERE invoice_id = p_invoice_rec.invoice_id;
258: END IF;
259:

Line 2597: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;

2593:
2594: invoice_num_check_failure EXCEPTION;
2595: l_invoice_count NUMBER;
2596: l_count_in_history_invoices NUMBER;
2597: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
2598: l_current_invoice_status VARCHAR2(1) := 'Y';
2599: current_calling_sequence VARCHAR2(2000);
2600: debug_info VARCHAR2(500);
2601:

Line 2708: FROM ap_invoices

2704: END IF;
2705:
2706: SELECT count(*)
2707: INTO l_invoice_count
2708: FROM ap_invoices
2709: WHERE vendor_id = p_invoice_rec.vendor_id
2710: AND invoice_num = l_invoice_num
2711: AND rownum = 1;
2712:

Line 3310: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;

3306: IS
3307:
3308: awt_group_check_failure EXCEPTION;
3309: l_current_invoice_status VARCHAR2(1) := 'Y';
3310: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
3311: l_awt_group_id_per_name AP_INVOICES.AWT_GROUP_ID%TYPE;
3312: l_inactive_date DATE;
3313: l_inactive_date_per_name DATE;
3314: current_calling_sequence VARCHAR2(2000);

Line 3311: l_awt_group_id_per_name AP_INVOICES.AWT_GROUP_ID%TYPE;

3307:
3308: awt_group_check_failure EXCEPTION;
3309: l_current_invoice_status VARCHAR2(1) := 'Y';
3310: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
3311: l_awt_group_id_per_name AP_INVOICES.AWT_GROUP_ID%TYPE;
3312: l_inactive_date DATE;
3313: l_inactive_date_per_name DATE;
3314: current_calling_sequence VARCHAR2(2000);
3315: debug_info VARCHAR2(500);

Line 3531: l_pay_awt_group_id AP_INVOICES.pay_AWT_GROUP_ID%TYPE;

3527: IS
3528:
3529: pay_awt_group_check_failure EXCEPTION;
3530: l_current_invoice_status VARCHAR2(1) := 'Y';
3531: l_pay_awt_group_id AP_INVOICES.pay_AWT_GROUP_ID%TYPE;
3532: l_pay_awt_group_id_per_name AP_INVOICES.pay_AWT_GROUP_ID%TYPE;
3533: l_inactive_date DATE;
3534: l_inactive_date_per_name DATE;
3535: current_calling_sequence VARCHAR2(2000);

Line 3532: l_pay_awt_group_id_per_name AP_INVOICES.pay_AWT_GROUP_ID%TYPE;

3528:
3529: pay_awt_group_check_failure EXCEPTION;
3530: l_current_invoice_status VARCHAR2(1) := 'Y';
3531: l_pay_awt_group_id AP_INVOICES.pay_AWT_GROUP_ID%TYPE;
3532: l_pay_awt_group_id_per_name AP_INVOICES.pay_AWT_GROUP_ID%TYPE;
3533: l_inactive_date DATE;
3534: l_inactive_date_per_name DATE;
3535: current_calling_sequence VARCHAR2(2000);
3536: debug_info VARCHAR2(500);

Line 5141: FROM ap_invoices

5137: END IF;
5138:
5139: SELECT count(*)
5140: INTO l_invoice_count
5141: FROM ap_invoices
5142: WHERE voucher_num = p_invoice_rec.voucher_num;
5143:
5144: IF (l_invoice_count > 0) THEN
5145: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 5574: l_payment_cross_rate AP_INVOICES_INTERFACE.payment_cross_rate%TYPE;

5570: invalid_pay_curr_code_failure EXCEPTION;
5571: l_current_invoice_status VARCHAR2(1) := 'Y';
5572: l_start_date_active DATE;
5573: l_end_date_active DATE;
5574: l_payment_cross_rate AP_INVOICES_INTERFACE.payment_cross_rate%TYPE;
5575: l_warning VARCHAR2(240);
5576: current_calling_sequence VARCHAR2(2000);
5577: debug_info VARCHAR2(500);
5578:

Line 5942: ap_invoices ai,

5938:
5939: SELECT count(*)
5940: INTO l_count_lines_matched
5941: FROM ap_invoice_lines ail,
5942: ap_invoices ai,
5943: po_line_locations pll
5944: WHERE ai.invoice_num = p_invoice_rec.prepay_num
5945: AND ai.org_id = p_invoice_rec.org_id
5946: AND ail.invoice_id = ai.invoice_id

Line 11349: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid

11345: END IF;
11346:
11347: SELECT DISTINCT ai.invoice_id, ail.amount
11348: INTO l_price_correct_inv_id, l_base_match_amount
11349: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid
11350: WHERE ai.invoice_num = p_invoice_lines_rec.price_correct_inv_num
11351: AND ail.invoice_id = ai.invoice_id
11352: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
11353: AND aid.invoice_id = ail.invoice_id

Line 14401: l_price_correct_inv_id AP_INVOICES.INVOICE_ID%TYPE;

14397: l_qty_billed NUMBER;
14398: debug_info VARCHAR2(2000);
14399: current_calling_sequence VARCHAR2(2000);
14400: l_cascade_receipts_flag VARCHAR2(1);
14401: l_price_correct_inv_id AP_INVOICES.INVOICE_ID%TYPE;
14402:
14403: --Contract Payments
14404: l_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
14405:

Line 15638: AP_INVOICES_PKG.get_expenditure_item_date(

15634: '(v_check_line_project_info 2) Get expenditure item date');
15635: END IF;
15636:
15637: p_invoice_lines_rec.expenditure_item_date :=
15638: AP_INVOICES_PKG.get_expenditure_item_date(
15639: p_invoice_rec.invoice_id,
15640: p_invoice_rec.invoice_date,
15641: p_accounting_date,
15642: NULL,

Line 17328: l_expd_item_date := AP_INVOICES_PKG.get_expenditure_item_date(

17324: IF (p_invoice_lines_rec.expenditure_item_date IS NULL AND
17325: l_expd_item_date IS NULL AND
17326: (p_invoice_lines_rec.project_id IS NOT NULL OR
17327: l_dset_lines_tab(i).project_id IS NOT NULL)) THEN
17328: l_expd_item_date := AP_INVOICES_PKG.get_expenditure_item_date(
17329: p_invoice_rec.invoice_id,
17330: p_invoice_rec.invoice_date,
17331: nvl(p_invoice_lines_rec.accounting_date,
17332: p_gl_date_from_get_info),

Line 19612: | ap_invoices_interface table as part of the eTax Uptake project:

Line 19649: l_related_inv_id ap_invoices_all.invoice_id%TYPE;

19645:
19646: debug_info VARCHAR2(500);
19647: check_tax_failure EXCEPTION;
19648:
19649: l_related_inv_id ap_invoices_all.invoice_id%TYPE;
19650: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;
19651: l_alloc_not_provided VARCHAR2(1);
19652: l_tax_lines_cannot_coexist VARCHAR2(1);
19653: l_tax_found_in_nontax_line VARCHAR2(1);

Line 19650: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;

19646: debug_info VARCHAR2(500);
19647: check_tax_failure EXCEPTION;
19648:
19649: l_related_inv_id ap_invoices_all.invoice_id%TYPE;
19650: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;
19651: l_alloc_not_provided VARCHAR2(1);
19652: l_tax_lines_cannot_coexist VARCHAR2(1);
19653: l_tax_found_in_nontax_line VARCHAR2(1);
19654:

Line 19707: FROM ap_invoices_all

19703:
19704: BEGIN
19705: SELECT invoice_id
19706: INTO l_related_inv_id
19707: FROM ap_invoices_all
19708: WHERE invoice_id = p_invoice_rec.tax_related_invoice_id
19709: AND vendor_id = p_invoice_rec.vendor_id
19710: AND vendor_site_id = p_invoice_rec.vendor_site_id
19711: AND cancelled_date IS NULL

Line 19792: FROM ap_invoices_interface aii

19788:
19789: BEGIN
19790: SELECT 'Y'
19791: INTO l_alloc_not_provided
19792: FROM ap_invoices_interface aii
19793: WHERE aii.invoice_id = p_invoice_rec.invoice_id
19794: AND 1 < (SELECT COUNT(*)
19795: FROM ap_invoice_lines_interface aili
19796: WHERE aili.line_type_lookup_code <> 'TAX'

Line 19839: FROM ap_invoices_interface aii

19835:
19836: BEGIN
19837: SELECT 'Y'
19838: INTO l_tax_found_in_nontax_line
19839: FROM ap_invoices_interface aii
19840: WHERE aii.invoice_id = p_invoice_rec.invoice_id
19841: AND EXISTS (SELECT 'Y'
19842: FROM ap_invoice_lines_interface ail2
19843: WHERE ail2.invoice_id = aii.invoice_id

Line 19895: FROM ap_invoices_interface aii

19891: IF (NVL(p_invoice_rec.tax_only_flag, 'N') = 'Y') THEN
19892: BEGIN
19893: SELECT 'Y'
19894: INTO l_tax_lines_cannot_coexist
19895: FROM ap_invoices_interface aii
19896: WHERE aii.invoice_id = p_invoice_rec.invoice_id
19897: AND EXISTS (SELECT 'Y'
19898: FROM ap_invoice_lines_interface ail2
19899: WHERE ail2.invoice_id = aii.invoice_id

Line 20018: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;

20014: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
20015: l_uom_code mtl_units_of_measure.uom_code%TYPE;
20016:
20017: l_error_code VARCHAR2(500);
20018: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
20019: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
20020: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
20021: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
20022:

Line 20019: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;

20015: l_uom_code mtl_units_of_measure.uom_code%TYPE;
20016:
20017: l_error_code VARCHAR2(500);
20018: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
20019: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
20020: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
20021: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
20022:
20023: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;

Line 20020: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;

20016:
20017: l_error_code VARCHAR2(500);
20018: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
20019: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
20020: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
20021: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
20022:
20023: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
20024: --6412397

Line 20021: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;

20017: l_error_code VARCHAR2(500);
20018: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
20019: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
20020: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
20021: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
20022:
20023: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
20024: --6412397
20025:

Line 20080: FROM ap_invoices_interface aii,

20076: --Bug 6925674 (Base bug6905106) Starts
20077: BEGIN
20078: SELECT aii.invoice_type_lookup_code
20079: INTO l_inv_hdr_inv_type
20080: FROM ap_invoices_interface aii,
20081: ap_invoice_lines_interface aili
20082: WHERE aii.invoice_id = aili.invoice_id
20083: AND aili.ROWID = p_invoice_lines_rec.row_id;
20084:

Line 20201: FROM ap_invoices_interface aii,

20197: INTO l_inv_hdr_org_id,
20198: l_inv_hdr_vendor_id,
20199: l_inv_hdr_vendor_site_id,
20200: l_inv_hdr_inv_type
20201: FROM ap_invoices_interface aii,
20202: ap_invoice_lines_interface aili
20203: WHERE aii.invoice_id = aili.invoice_id
20204: AND aili.ROWID = p_invoice_lines_rec.row_id;
20205:

Line 20337: p_entity_code => 'AP_INVOICES',

20333: FUNC_SHORT_NAME => 'NONE',
20334: p_calling_sequence => current_calling_sequence,
20335: --'AP_ETAX_SERVICES_PKG',
20336: p_event_class_code => NULL, --p_event_class_code,
20337: p_entity_code => 'AP_INVOICES',
20338: p_application_id => 200,
20339: p_internal_organization_id => l_inv_hdr_org_id );
20340:
20341:

Line 20943: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;

20939: -- Bug 5448579
20940: l_valid_payment_method IBY_PAYMENT_METHODS_VL.Payment_Method_Code%TYPE;
20941:
20942: --Bug 8213679
20943: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;
20944: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;
20945: --Bug 8213679
20946:
20947:

Line 20944: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;

20940: l_valid_payment_method IBY_PAYMENT_METHODS_VL.Payment_Method_Code%TYPE;
20941:
20942: --Bug 8213679
20943: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;
20944: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;
20945: --Bug 8213679
20946:
20947:
20948: begin

Line 21277: ap_invoices_pkg.get_payment_attributes(

21273: l_remit_party_site_id := p_invoice_rec.party_site_id;
21274: END IF;
21275:
21276:
21277: ap_invoices_pkg.get_payment_attributes(
21278: p_le_id =>p_invoice_rec.legal_entity_id,
21279: p_org_id =>p_invoice_rec.org_id,
21280: p_payee_party_id =>l_remit_party_id, --Bug 8213679
21281: p_payee_party_site_id =>l_remit_party_site_id, --Bug 8213679