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 73: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;

69: l_current_invoice_status VARCHAR2(1) := 'Y';
70: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
71: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
72: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
73: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
74: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
75: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;

Line 74: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

70: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
71: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
72: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
73: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
74: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
75: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;

Line 75: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

71: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
72: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
73: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
74: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
75: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866

Line 76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

72: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
73: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
74: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
75: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;

Line 77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;

73: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
74: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
75: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;

Line 78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;

74: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
75: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;

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

75: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;

Line 80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;

76: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
84: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;

Line 81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;

77: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
84: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
85: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;

Line 82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;

78: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
84: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
85: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
86: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;

Line 83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;

79: l_pay_awt_group_id AP_INVOICES.PAY_AWT_GROUP_ID%TYPE;--bug6639866
80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
84: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
85: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
86: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;
87: l_temp_invoice_status VARCHAR2(1) := 'Y';

Line 84: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;

80: l_terms_id AP_INVOICES.TERMS_ID%TYPE;
81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
84: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
85: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
86: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;
87: l_temp_invoice_status VARCHAR2(1) := 'Y';
88: l_po_exists_flag VARCHAR2(1) := 'N';

Line 85: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;

81: l_terms_date AP_INVOICES.TERMS_DATE%TYPE;
82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
84: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
85: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
86: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;
87: l_temp_invoice_status VARCHAR2(1) := 'Y';
88: l_po_exists_flag VARCHAR2(1) := 'N';
89: current_calling_sequence VARCHAR2(2000);

Line 86: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;

82: l_pay_currency_code AP_INVOICES.PAYMENT_CURRENCY_CODE%TYPE;
83: l_pay_cross_rate_date AP_INVOICES.PAYMENT_CROSS_RATE_DATE%TYPE;
84: l_pay_cross_rate AP_INVOICES.PAYMENT_CROSS_RATE%TYPE;
85: l_pay_cross_rate_type AP_INVOICES.PAYMENT_CROSS_RATE_TYPE%TYPE;
86: l_invoice_base_amount AP_INVOICES.BASE_AMOUNT%TYPE;
87: l_temp_invoice_status VARCHAR2(1) := 'Y';
88: l_po_exists_flag VARCHAR2(1) := 'N';
89: current_calling_sequence VARCHAR2(2000);
90: debug_info VARCHAR2(500);

Line 283: THEN UPDATE ap_invoices_interface

279:
280: --added nvl for bug 7314487
281: IF l_temp_vendor_id is NULL
282: AND nvl(p_invoice_rec.invoice_type_lookup_code,'STANDARD') <> 'PAYMENT REQUEST'
283: THEN UPDATE ap_invoices_interface
284: SET vendor_id = l_vendor_id
285: WHERE invoice_id = p_invoice_rec.invoice_id;
286: END IF;
287:

Line 2732: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;

2728:
2729: invoice_num_check_failure EXCEPTION;
2730: l_invoice_count NUMBER;
2731: l_count_in_history_invoices NUMBER;
2732: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
2733: l_current_invoice_status VARCHAR2(1) := 'Y';
2734: current_calling_sequence VARCHAR2(2000);
2735: debug_info VARCHAR2(500);
2736:

Line 2843: FROM ap_invoices

2839: END IF;
2840:
2841: SELECT count(*)
2842: INTO l_invoice_count
2843: FROM ap_invoices
2844: WHERE vendor_id = p_invoice_rec.vendor_id
2845: AND invoice_num = l_invoice_num
2846: AND (party_site_id = p_invoice_rec.party_site_id /*Bug9105666*/
2847: OR (party_site_id is null and p_invoice_rec.party_site_id is null)) /*Bug9105666*/

Line 3507: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;

3503: IS
3504:
3505: awt_group_check_failure EXCEPTION;
3506: l_current_invoice_status VARCHAR2(1) := 'Y';
3507: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
3508: l_awt_group_id_per_name AP_INVOICES.AWT_GROUP_ID%TYPE;
3509: l_inactive_date DATE;
3510: l_inactive_date_per_name DATE;
3511: current_calling_sequence VARCHAR2(2000);

Line 3508: l_awt_group_id_per_name AP_INVOICES.AWT_GROUP_ID%TYPE;

3504:
3505: awt_group_check_failure EXCEPTION;
3506: l_current_invoice_status VARCHAR2(1) := 'Y';
3507: l_awt_group_id AP_INVOICES.AWT_GROUP_ID%TYPE;
3508: l_awt_group_id_per_name AP_INVOICES.AWT_GROUP_ID%TYPE;
3509: l_inactive_date DATE;
3510: l_inactive_date_per_name DATE;
3511: current_calling_sequence VARCHAR2(2000);
3512: debug_info VARCHAR2(500);

Line 3728: l_pay_awt_group_id AP_INVOICES.pay_AWT_GROUP_ID%TYPE;

3724: IS
3725:
3726: pay_awt_group_check_failure EXCEPTION;
3727: l_current_invoice_status VARCHAR2(1) := 'Y';
3728: l_pay_awt_group_id AP_INVOICES.pay_AWT_GROUP_ID%TYPE;
3729: l_pay_awt_group_id_per_name AP_INVOICES.pay_AWT_GROUP_ID%TYPE;
3730: l_inactive_date DATE;
3731: l_inactive_date_per_name DATE;
3732: current_calling_sequence VARCHAR2(2000);

Line 3729: l_pay_awt_group_id_per_name AP_INVOICES.pay_AWT_GROUP_ID%TYPE;

3725:
3726: pay_awt_group_check_failure EXCEPTION;
3727: l_current_invoice_status VARCHAR2(1) := 'Y';
3728: l_pay_awt_group_id AP_INVOICES.pay_AWT_GROUP_ID%TYPE;
3729: l_pay_awt_group_id_per_name AP_INVOICES.pay_AWT_GROUP_ID%TYPE;
3730: l_inactive_date DATE;
3731: l_inactive_date_per_name DATE;
3732: current_calling_sequence VARCHAR2(2000);
3733: debug_info VARCHAR2(500);

Line 5473: FROM ap_invoices

5469: END IF;
5470:
5471: SELECT count(*)
5472: INTO l_invoice_count
5473: FROM ap_invoices
5474: WHERE voucher_num = p_invoice_rec.voucher_num;
5475:
5476: IF (l_invoice_count > 0) THEN
5477: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 6012: l_payment_cross_rate AP_INVOICES_INTERFACE.payment_cross_rate%TYPE;

6008: invalid_pay_curr_code_failure EXCEPTION;
6009: l_current_invoice_status VARCHAR2(1) := 'Y';
6010: l_start_date_active DATE;
6011: l_end_date_active DATE;
6012: l_payment_cross_rate AP_INVOICES_INTERFACE.payment_cross_rate%TYPE;
6013: l_warning VARCHAR2(240);
6014: current_calling_sequence VARCHAR2(2000);
6015: debug_info VARCHAR2(500);
6016:

Line 6383: ap_invoices ai,

6379:
6380: SELECT count(*)
6381: INTO l_count_lines_matched
6382: FROM ap_invoice_lines ail,
6383: ap_invoices ai,
6384: po_line_locations pll
6385: WHERE ai.invoice_num = p_invoice_rec.prepay_num
6386: AND ai.org_id = p_invoice_rec.org_id
6387: AND ail.invoice_id = ai.invoice_id

Line 7416: IF AP_INVOICES_UTILITY_PKG.FV_ENABLED THEN

7412: CLOSE invoice_lines;
7413: END IF;
7414:
7415: --Bug#13464635
7416: IF AP_INVOICES_UTILITY_PKG.FV_ENABLED THEN
7417: l_refresh := 'Y';
7418: ELSE
7419: l_refresh := 'N';
7420: END IF;

Line 8902: -- value corresponding to flexfield JG_AP_INVOICES_LINES

8898: End of Bug 13398814 */
8899:
8900: -----------------------------------------------------
8901: -- Update global_context_code with the right
8902: -- value corresponding to flexfield JG_AP_INVOICES_LINES
8903: -- Bug 13491024 - R1213ITTHRESH.QA: ISSUES WITH ITEM LINE GDF IN ITALIAN AP QUICK INVOICE
8904: -----------------------------------------------------
8905: debug_info := '(Check Lines 28) Update global context code ';
8906: IF AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' THEN

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

12474: l_price_cor_po_header_id,
12475: l_price_cor_po_line_id,
12476: l_price_cor_po_line_loc_id,
12477: l_price_cor_po_distribution_id
12478: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid
12479: WHERE ai.invoice_num = p_invoice_lines_rec.price_correct_inv_num
12480: AND ail.invoice_id = ai.invoice_id
12481: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
12482: AND aid.invoice_id = ail.invoice_id

Line 15787: l_price_correct_inv_id AP_INVOICES.INVOICE_ID%TYPE;

15783: l_qty_billed NUMBER;
15784: debug_info VARCHAR2(2000);
15785: current_calling_sequence VARCHAR2(2000);
15786: l_cascade_receipts_flag VARCHAR2(1);
15787: l_price_correct_inv_id AP_INVOICES.INVOICE_ID%TYPE;
15788:
15789: --Contract Payments
15790: l_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
15791:

Line 17077: AP_INVOICES_PKG.get_expenditure_item_date(

17073: '(v_check_line_project_info 2) Get expenditure item date');
17074: END IF;
17075:
17076: p_invoice_lines_rec.expenditure_item_date :=
17077: AP_INVOICES_PKG.get_expenditure_item_date(
17078: p_invoice_rec.invoice_id,
17079: p_invoice_rec.invoice_date,
17080: p_accounting_date,
17081: NULL,

Line 19005: l_expd_item_date := AP_INVOICES_PKG.get_expenditure_item_date(

19001: IF (p_invoice_lines_rec.expenditure_item_date IS NULL AND
19002: l_expd_item_date IS NULL AND
19003: (p_invoice_lines_rec.project_id IS NOT NULL OR
19004: l_dset_lines_tab(i).project_id IS NOT NULL)) THEN
19005: l_expd_item_date := AP_INVOICES_PKG.get_expenditure_item_date(
19006: p_invoice_rec.invoice_id,
19007: p_invoice_rec.invoice_date,
19008: nvl(p_invoice_lines_rec.accounting_date,
19009: p_gl_date_from_get_info),

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

Line 21451: l_related_inv_id ap_invoices_all.invoice_id%TYPE;

21447:
21448: debug_info VARCHAR2(500);
21449: check_tax_failure EXCEPTION;
21450:
21451: l_related_inv_id ap_invoices_all.invoice_id%TYPE;
21452: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;
21453: l_alloc_not_provided VARCHAR2(1);
21454: l_tax_lines_cannot_coexist VARCHAR2(1);
21455: l_tax_found_in_nontax_line VARCHAR2(1);

Line 21452: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;

21448: debug_info VARCHAR2(500);
21449: check_tax_failure EXCEPTION;
21450:
21451: l_related_inv_id ap_invoices_all.invoice_id%TYPE;
21452: l_exist_tax_line ap_invoices_all.invoice_id%TYPE;
21453: l_alloc_not_provided VARCHAR2(1);
21454: l_tax_lines_cannot_coexist VARCHAR2(1);
21455: l_tax_found_in_nontax_line VARCHAR2(1);
21456:

Line 21512: FROM ap_invoices_all

21508:
21509: BEGIN
21510: SELECT invoice_id
21511: INTO l_related_inv_id
21512: FROM ap_invoices_all
21513: WHERE invoice_id = p_invoice_rec.tax_related_invoice_id
21514: AND vendor_id = p_invoice_rec.vendor_id
21515: AND vendor_site_id = p_invoice_rec.vendor_site_id
21516: AND cancelled_date IS NULL

Line 21597: FROM ap_invoices_interface aii

21593:
21594: BEGIN
21595: SELECT 'Y'
21596: INTO l_alloc_not_provided
21597: FROM ap_invoices_interface aii
21598: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21599: AND 1 < (SELECT COUNT(*)
21600: FROM ap_invoice_lines_interface aili
21601: WHERE aili.line_type_lookup_code <> 'TAX'

Line 21644: FROM ap_invoices_interface aii

21640:
21641: BEGIN
21642: SELECT 'Y'
21643: INTO l_tax_found_in_nontax_line
21644: FROM ap_invoices_interface aii
21645: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21646: AND EXISTS (SELECT 'Y'
21647: FROM ap_invoice_lines_interface ail2
21648: WHERE ail2.invoice_id = aii.invoice_id

Line 21700: FROM ap_invoices_interface aii

21696: IF (NVL(p_invoice_rec.tax_only_flag, 'N') = 'Y') THEN
21697: BEGIN
21698: SELECT 'Y'
21699: INTO l_tax_lines_cannot_coexist
21700: FROM ap_invoices_interface aii
21701: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21702: AND EXISTS (SELECT 'Y'
21703: FROM ap_invoice_lines_interface ail2
21704: WHERE ail2.invoice_id = aii.invoice_id

Line 21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;

21819: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21821:
21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
21827:

Line 21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;

21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21821:
21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
21827:
21828: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;

Line 21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;

21821:
21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
21827:
21828: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
21829: --6412397

Line 21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;

21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;
21825: l_inv_hdr_vendor_site_id ap_invoices_interface.vendor_site_id%TYPE;
21826: l_inv_hdr_inv_type ap_invoices_interface.invoice_type_lookup_code%TYPE;
21827:
21828: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
21829: --6412397
21830:

Line 21887: FROM ap_invoices_interface aii,

21883: /* --Bug 6925674 (Base bug6905106) Starts
21884: BEGIN
21885: SELECT aii.invoice_type_lookup_code
21886: INTO l_inv_hdr_inv_type
21887: FROM ap_invoices_interface aii,
21888: ap_invoice_lines_interface aili
21889: WHERE aii.invoice_id = aili.invoice_id
21890: AND aili.ROWID = p_invoice_lines_rec.row_id;
21891:

Line 22010: FROM ap_invoices_interface aii,

22006: INTO l_inv_hdr_org_id,
22007: l_inv_hdr_vendor_id,
22008: l_inv_hdr_vendor_site_id,
22009: l_inv_hdr_inv_type
22010: FROM ap_invoices_interface aii,
22011: ap_invoice_lines_interface aili
22012: WHERE aii.invoice_id = aili.invoice_id
22013: AND aili.ROWID = p_invoice_lines_rec.row_id;
22014:

Line 22162: p_entity_code => 'AP_INVOICES',

22158: FUNC_SHORT_NAME => 'NONE',
22159: p_calling_sequence => current_calling_sequence,
22160: --'AP_ETAX_SERVICES_PKG',
22161: p_event_class_code => NULL, --p_event_class_code,
22162: p_entity_code => 'AP_INVOICES',
22163: p_application_id => 200,
22164: p_internal_organization_id => l_inv_hdr_org_id );
22165:
22166:

Line 22768: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;

22764: -- Bug 5448579
22765: l_valid_payment_method IBY_PAYMENT_METHODS_VL.Payment_Method_Code%TYPE;
22766:
22767: --Bug 8213679
22768: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;
22769: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;
22770: --Bug 8213679
22771:
22772:

Line 22769: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;

22765: l_valid_payment_method IBY_PAYMENT_METHODS_VL.Payment_Method_Code%TYPE;
22766:
22767: --Bug 8213679
22768: l_remit_party_id AP_INVOICES_ALL.PARTY_ID%TYPE;
22769: l_remit_party_site_id AP_INVOICES_ALL.PARTY_SITE_ID%TYPE;
22770: --Bug 8213679
22771:
22772:
22773: begin

Line 23118: ap_invoices_pkg.get_payment_attributes(

23114: --end Bug 9133220
23115: END IF;
23116:
23117:
23118: ap_invoices_pkg.get_payment_attributes(
23119: p_le_id =>p_invoice_rec.legal_entity_id,
23120: p_org_id =>p_invoice_rec.org_id,
23121: p_payee_party_id =>nvl(l_remit_party_id,p_invoice_rec.party_id), --Bug 8345877
23122: p_payee_party_site_id =>nvl(l_remit_party_site_id,p_invoice_rec.party_site_id), --Bug 8345877

Line 23467: l_product_org_id ap_invoices.org_id%TYPE;

23463: l_trx_biz_category zx_lines_det_factors.trx_business_category%type;
23464: -- bug 8495005 fix ends
23465:
23466: -- bug 8483345: start
23467: l_product_org_id ap_invoices.org_id%TYPE;
23468: l_allow_tax_code_override varchar2(10);
23469: l_dflt_tax_class_code2 zx_transaction_lines_gt.input_tax_classification_code%type;
23470: -- bug 8483345: end
23471:

Line 23554: p_entity_code => 'AP_INVOICES',

23550: APPL_SHORT_NAME => 'SQLAP',
23551: FUNC_SHORT_NAME => 'NONE',
23552: p_calling_sequence => current_calling_sequence, -- Bug 10050094 'AP_ETAX_SERVICES_PKG',
23553: p_event_class_code => l_ref_doc_event_class_code,
23554: p_entity_code => 'AP_INVOICES',
23555: p_application_id => 200,
23556: p_internal_organization_id => p_invoice_lines_rec.org_id);
23557: -- bug 8483345: end
23558:

Line 24454: AP_INVOICES_UTILITY_PKG.CHECK_GDF_VALID

24450: debug_info);
24451: END IF;
24452:
24453: IF (p_valid_level = 'INVOICE LINE')THEN
24454: AP_INVOICES_UTILITY_PKG.CHECK_GDF_VALID
24455: (p_invoice_line_id, --P_id
24456: 'INV_IMP', --P_calling_mode
24457: 'AP_INVOICE_LINES_INTERFACE', --P_table_name
24458: l_hold_reject_exists_flag, --P_hold_reject_exists_flag