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.

[Home] [Help]

APPS.AP_MATCHING_PKG dependencies on AP_INVOICES

Line 166: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;

162: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
163: G_Period_Name gl_period_statuses.period_name%TYPE;
164: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
165: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
166: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;
167: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
168: G_Precision fnd_currencies.precision%TYPE;
169: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
170: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;

Line 167: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;

163: G_Period_Name gl_period_statuses.period_name%TYPE;
164: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
165: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
166: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;
167: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
168: G_Precision fnd_currencies.precision%TYPE;
169: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
170: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
171: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;

Line 174: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;

170: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
171: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
172: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
173: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
174: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
175: G_Allow_PA_Override varchar2(1);
176: G_Pa_Expenditure_Date_Default varchar2(50);
177: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;
178: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;

Line 184: G_Invoice_Date ap_invoices.invoice_date%TYPE;

180: G_Project_ID pa_projects_all.project_id%TYPE;
181: G_Task_ID pa_tasks.task_id%TYPE;
182: G_Award_ID po_distributions_all.award_id%TYPE;
183: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
184: G_Invoice_Date ap_invoices.invoice_date%TYPE;
185: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
186: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
187: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
188: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;

Line 191: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;

187: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
188: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
189: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
190: -- Removed for bug 4277744
191: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
192: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
193: G_Shipment_Type po_line_locations.shipment_type%TYPE;
194: G_Org_id ap_invoices.org_id%TYPE;
195: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;

Line 194: G_Org_id ap_invoices.org_id%TYPE;

190: -- Removed for bug 4277744
191: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
192: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
193: G_Shipment_Type po_line_locations.shipment_type%TYPE;
194: G_Org_id ap_invoices.org_id%TYPE;
195: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
196: G_User_Id number;
197: G_Login_Id number;
198: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;

Line 212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;

208: G_Line_Expenditure_Org_Id ap_invoice_lines.expenditure_organization_id%TYPE ;
209: G_Line_Base_Amount ap_invoice_lines.base_amount%TYPE ;
210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;

Line 214: G_Vendor_Id ap_invoices.vendor_id%TYPE;

210: G_Line_Awt_Group_Id ap_invoice_lines.awt_group_id%TYPE ;
211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218: G_Release_Amount_Net_Of_Tax ap_invoices_all.release_amount_net_of_tax%TYPE;

Line 215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;

211: G_Line_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218: G_Release_Amount_Net_Of_Tax ap_invoices_all.release_amount_net_of_tax%TYPE;
219: --Bugfix:5565310

Line 218: G_Release_Amount_Net_Of_Tax ap_invoices_all.release_amount_net_of_tax%TYPE;

214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218: G_Release_Amount_Net_Of_Tax ap_invoices_all.release_amount_net_of_tax%TYPE;
219: --Bugfix:5565310
220: G_intended_use zx_lines_det_factors.line_intended_use%type;
221: G_product_type zx_lines_det_factors.product_type%type;
222: G_product_category zx_lines_det_factors.product_category%type;

Line 227: G_source ap_invoices_all.source%type;

223: G_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
224: G_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
225: G_assessable_value zx_lines_det_factors.assessable_value%type;
226: G_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
227: G_source ap_invoices_all.source%type;
228: G_recurring_payment_id ap_invoices.recurring_payment_id%TYPE; -- Bug 7305223
229: G_PAY_AWT_GROUP_ID ap_invoices_all.pay_awt_group_id%TYPE; -- bug8222382
230: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; -- bug8222382
231:

Line 228: G_recurring_payment_id ap_invoices.recurring_payment_id%TYPE; -- Bug 7305223

224: G_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
225: G_assessable_value zx_lines_det_factors.assessable_value%type;
226: G_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
227: G_source ap_invoices_all.source%type;
228: G_recurring_payment_id ap_invoices.recurring_payment_id%TYPE; -- Bug 7305223
229: G_PAY_AWT_GROUP_ID ap_invoices_all.pay_awt_group_id%TYPE; -- bug8222382
230: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; -- bug8222382
231:
232: PROCEDURE Base_Credit_PO_Match(X_match_mode IN VARCHAR2,

Line 229: G_PAY_AWT_GROUP_ID ap_invoices_all.pay_awt_group_id%TYPE; -- bug8222382

225: G_assessable_value zx_lines_det_factors.assessable_value%type;
226: G_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
227: G_source ap_invoices_all.source%type;
228: G_recurring_payment_id ap_invoices.recurring_payment_id%TYPE; -- Bug 7305223
229: G_PAY_AWT_GROUP_ID ap_invoices_all.pay_awt_group_id%TYPE; -- bug8222382
230: G_Line_Pay_Awt_Group_Id ap_invoice_lines.pay_awt_group_id%TYPE ; -- bug8222382
231:
232: PROCEDURE Base_Credit_PO_Match(X_match_mode IN VARCHAR2,
233: X_invoice_id IN NUMBER,

Line 280: l_product_org_id ap_invoices.org_id%TYPE;

276: l_error_code varchar2(2000);
277: l_po_line_location_id po_line_locations.line_location_id%TYPE;
278: l_dummy number;
279: -- bug 7577673: start
280: l_product_org_id ap_invoices.org_id%TYPE;
281: l_allow_tax_code_override varchar2(10);
282: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
283: -- bug 7577673: end
284:

Line 381: p_entity_code => 'AP_INVOICES',

377: APPL_SHORT_NAME => 'SQLAP',
378: FUNC_SHORT_NAME => 'NONE',
379: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
380: p_event_class_code => l_ref_doc_event_class_code,
381: p_entity_code => 'AP_INVOICES',
382: p_application_id => 200,
383: p_internal_organization_id => g_org_id);
384: -- bug 7577673: end
385:

Line 902: FROM ap_invoices_all ai ,

898: g_source,
899: g_recurring_payment_id, -- Bug 7305223
900: /* Bug 5572876, using base tables */
901: g_pay_awt_group_id -- bug 8222382
902: FROM ap_invoices_all ai ,
903: ap_system_parameters_all asp,
904: ap_suppliers pv,
905: ap_supplier_sites_all pvs,
906: financials_system_params_all fsp,

Line 4488: FROM ap_invoices ai,

4484: AIL.PRODUCT_TYPE, --product_type
4485: AIL.PRODUCT_CATEGORY, --product_category
4486: AIL.USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
4487: g_pay_awt_group_id --pay_awt_group_id bug8222382
4488: FROM ap_invoices ai,
4489: ap_invoice_lines ail,
4490: po_line_locations_ap_v pll
4491: WHERE ai.invoice_id = x_corrected_invoice_id
4492: AND ail.invoice_id = ai.invoice_id

Line 5436: p_entity_code => 'AP_INVOICES',

5432: APPL_SHORT_NAME => 'SQLAP',
5433: FUNC_SHORT_NAME => 'NONE',
5434: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
5435: p_event_class_code => l_ref_doc_event_class_code,
5436: p_entity_code => 'AP_INVOICES',
5437: p_application_id => 200,
5438: p_internal_organization_id => g_org_id);
5439: -- bug 7577673: end
5440:

Line 5671: p_entity_code => 'AP_INVOICES',

5667: APPL_SHORT_NAME => 'SQLAP',
5668: FUNC_SHORT_NAME => 'NONE',
5669: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
5670: p_event_class_code => l_ref_doc_event_class_code,
5671: p_entity_code => 'AP_INVOICES',
5672: p_application_id => 200,
5673: p_internal_organization_id => g_org_id);
5674:
5675: AP_Etax_Services_Pkg.Get_Po_Tax_Attributes(