DBA Data[Home] [Help]

APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;

187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;
188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
189: l_receipt_uom rcv_shipment_lines.unit_of_measure%TYPE;
190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;
191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
193: l_batch_control_flag ap_system_parameters.batch_control_flag%TYPE;
194: l_gl_date_from_rect_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
195: l_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;

Line 192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;

188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
189: l_receipt_uom rcv_shipment_lines.unit_of_measure%TYPE;
190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;
191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
193: l_batch_control_flag ap_system_parameters.batch_control_flag%TYPE;
194: l_gl_date_from_rect_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
195: l_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
196: l_accts_pay_ccid po_vendor_sites.accts_pay_code_combination_id%TYPE;

Line 193: l_batch_control_flag ap_system_parameters.batch_control_flag%TYPE;

189: l_receipt_uom rcv_shipment_lines.unit_of_measure%TYPE;
190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;
191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
193: l_batch_control_flag ap_system_parameters.batch_control_flag%TYPE;
194: l_gl_date_from_rect_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
195: l_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
196: l_accts_pay_ccid po_vendor_sites.accts_pay_code_combination_id%TYPE;
197:

Line 194: l_gl_date_from_rect_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;

190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;
191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
193: l_batch_control_flag ap_system_parameters.batch_control_flag%TYPE;
194: l_gl_date_from_rect_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
195: l_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
196: l_accts_pay_ccid po_vendor_sites.accts_pay_code_combination_id%TYPE;
197:
198: --4552701, added the fields below

Line 250: l_auto_tax_calc_flag_sys ap_system_parameters.auto_tax_calc_flag%TYPE;

246: l_po_dist_id NUMBER ; --Bug fix:1413339
247: l_derive_type_rcv_curr VARCHAR2(10); --Bug fix:1891850
248: l_derive_type_payment_curr VARCHAR2(10); --Bug fix:1891850
249: -- Bug fix : 1971188 - definition of variables
250: l_auto_tax_calc_flag_sys ap_system_parameters.auto_tax_calc_flag%TYPE;
251: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
252:
253: --Bug: 2902340
254: l_match_option po_line_locations.match_option%TYPE;

Line 363: Retreive information from ap_system_parameters */

359: --Bug: 2902340: added the IF condition
360: If l_invoice_exists ='Y' Then
361:
362: /* STEP 2 :
363: Retreive information from ap_system_parameters */
364:
365: debug_info := 'retrieve information from ap_system_parameters';
366:
367: SELECT

Line 365: debug_info := 'retrieve information from ap_system_parameters';

361:
362: /* STEP 2 :
363: Retreive information from ap_system_parameters */
364:
365: debug_info := 'retrieve information from ap_system_parameters';
366:
367: SELECT
368: set_of_books_id,
369: base_currency_code,

Line 377: FROM ap_system_parameters

373: l_set_of_books_id,
374: l_base_currency_code,
375: l_gl_date_from_rect_flag,
376: l_auto_tax_calc_flag_sys
377: FROM ap_system_parameters
378: WHERE org_id = l_org_id ;
379:
380: --Bug :2024697
381: --Shared Services - Profile_Options : Added the following code so as get the