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 356: Retreive information from ap_system_parameters */

352: --Bug: 2902340: added the IF condition
353: If l_invoice_exists ='Y' Then
354:
355: /* STEP 2 :
356: Retreive information from ap_system_parameters */
357:
358: debug_info := 'retrieve information from ap_system_parameters';
359:
360: SELECT

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

354:
355: /* STEP 2 :
356: Retreive information from ap_system_parameters */
357:
358: debug_info := 'retrieve information from ap_system_parameters';
359:
360: SELECT
361: set_of_books_id,
362: base_currency_code,

Line 370: FROM ap_system_parameters

366: l_set_of_books_id,
367: l_base_currency_code,
368: l_gl_date_from_rect_flag,
369: l_auto_tax_calc_flag_sys
370: FROM ap_system_parameters
371: WHERE org_id = l_org_id ;
372:
373: --Bug :2024697
374: --Shared Services - Profile_Options : Added the following code so as get the