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

Line 81: g_vendor_id ap_invoices.vendor_id%TYPE;

77: X_Calling_Sequence IN VARCHAR2);
78:
79: --Global Variables
80:
81: g_vendor_id ap_invoices.vendor_id%TYPE;
82: g_vendor_site_id ap_invoices.vendor_site_id%TYPE;
83: g_invoice_date ap_invoices.invoice_date%TYPE;
84: g_batch_id ap_batches.batch_id%TYPE;
85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;

Line 82: g_vendor_site_id ap_invoices.vendor_site_id%TYPE;

78:
79: --Global Variables
80:
81: g_vendor_id ap_invoices.vendor_id%TYPE;
82: g_vendor_site_id ap_invoices.vendor_site_id%TYPE;
83: g_invoice_date ap_invoices.invoice_date%TYPE;
84: g_batch_id ap_batches.batch_id%TYPE;
85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
86: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;

Line 83: g_invoice_date ap_invoices.invoice_date%TYPE;

79: --Global Variables
80:
81: g_vendor_id ap_invoices.vendor_id%TYPE;
82: g_vendor_site_id ap_invoices.vendor_site_id%TYPE;
83: g_invoice_date ap_invoices.invoice_date%TYPE;
84: g_batch_id ap_batches.batch_id%TYPE;
85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
86: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
87: g_exchange_rate ap_invoices.exchange_rate%TYPE;

Line 86: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;

82: g_vendor_site_id ap_invoices.vendor_site_id%TYPE;
83: g_invoice_date ap_invoices.invoice_date%TYPE;
84: g_batch_id ap_batches.batch_id%TYPE;
85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
86: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
87: g_exchange_rate ap_invoices.exchange_rate%TYPE;
88: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;
89: g_accounting_date ap_invoices.gl_date%TYPE;
90: g_period_name gl_period_statuses.period_name%TYPE;

Line 87: g_exchange_rate ap_invoices.exchange_rate%TYPE;

83: g_invoice_date ap_invoices.invoice_date%TYPE;
84: g_batch_id ap_batches.batch_id%TYPE;
85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
86: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
87: g_exchange_rate ap_invoices.exchange_rate%TYPE;
88: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;
89: g_accounting_date ap_invoices.gl_date%TYPE;
90: g_period_name gl_period_statuses.period_name%TYPE;
91: g_set_of_books_id ap_invoices.set_of_books_id%TYPE;

Line 89: g_accounting_date ap_invoices.gl_date%TYPE;

85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
86: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
87: g_exchange_rate ap_invoices.exchange_rate%TYPE;
88: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;
89: g_accounting_date ap_invoices.gl_date%TYPE;
90: g_period_name gl_period_statuses.period_name%TYPE;
91: g_set_of_books_id ap_invoices.set_of_books_id%TYPE;
92: g_type_1099 po_vendors.type_1099%TYPE;
93: g_income_tax_region ap_system_parameters.income_tax_region%TYPE;

Line 91: g_set_of_books_id ap_invoices.set_of_books_id%TYPE;

87: g_exchange_rate ap_invoices.exchange_rate%TYPE;
88: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;
89: g_accounting_date ap_invoices.gl_date%TYPE;
90: g_period_name gl_period_statuses.period_name%TYPE;
91: g_set_of_books_id ap_invoices.set_of_books_id%TYPE;
92: g_type_1099 po_vendors.type_1099%TYPE;
93: g_income_tax_region ap_system_parameters.income_tax_region%TYPE;
94: g_allow_pa_override VARCHAR2(1);
95: g_pa_expenditure_date_default VARCHAR2(50);

Line 101: g_trx_business_category ap_invoices.trx_business_category%TYPE;

97: g_asset_book_type_code fa_book_controls.book_type_code%TYPE;
98: g_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
99: g_user_id number;
100: g_login_id number;
101: g_trx_business_category ap_invoices.trx_business_category%TYPE;
102: G_Org_Id ap_invoices.org_id%TYPE;
103: G_intended_use zx_lines_det_factors.line_intended_use%type;
104: G_product_type zx_lines_det_factors.product_type%type;
105: G_product_category zx_lines_det_factors.product_category%type;

Line 102: G_Org_Id ap_invoices.org_id%TYPE;

98: g_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
99: g_user_id number;
100: g_login_id number;
101: g_trx_business_category ap_invoices.trx_business_category%TYPE;
102: G_Org_Id ap_invoices.org_id%TYPE;
103: G_intended_use zx_lines_det_factors.line_intended_use%type;
104: G_product_type zx_lines_det_factors.product_type%type;
105: G_product_category zx_lines_det_factors.product_category%type;
106: G_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

Line 158: --Retreive certain information from ap_invoices table and

154: current_calling_sequence := 'AP_OTHR_CHRG_MATCH_PKG.othr_chrg_match <-'
155: || X_calling_sequence;
156:
157:
158: --Retreive certain information from ap_invoices table and
159: --ap_system_parameters
160:
161: l_debug_info := 'Select information from ap_invoices';
162:

Line 161: l_debug_info := 'Select information from ap_invoices';

157:
158: --Retreive certain information from ap_invoices table and
159: --ap_system_parameters
160:
161: l_debug_info := 'Select information from ap_invoices';
162:
163: Get_Info(X_Invoice_Id => x_invoice_id,
164: X_Calling_Sequence => current_calling_sequence);
165:

Line 215: From ap_invoices_all ai

211: BEGIN
212:
213: Select invoice_type_lookup_code
214: Into l_invoice_type_lookup_code
215: From ap_invoices_all ai
216: Where ai.invoice_id = x_invoice_id;
217:
218: EXCEPTION
219: When Others then

Line 286: p_entity_code => 'AP_INVOICES',

282: APPL_SHORT_NAME => 'SQLAP',
283: FUNC_SHORT_NAME => 'NONE',
284: p_calling_sequence => 'AP_OTHR_CHRG_MATCH_PKG',
285: p_event_class_code => l_invoice_type_lookup_code,
286: p_entity_code => 'AP_INVOICES',
287: p_application_id => 200,
288: p_internal_organization_id => g_org_id);
289:
290: --

Line 415: FROM ap_invoices_all ai, --bug 5056051

411: g_approval_workflow_flag,
412: g_transfer_flag,
413: g_trx_business_category,
414: g_org_id
415: FROM ap_invoices_all ai, --bug 5056051
416: ap_system_parameters asp,
417: ap_suppliers pv, --bug 5056051
418: ap_supplier_sites pvs --bug 5056051
419: WHERE ai.invoice_id = x_invoice_id