35: p_unit_selling_price IN NUMBER,
36: p_org_id IN NUMBER) IS --Bug fix 2367111
37:
38: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
39: l_location_structure_id ar_system_parameters.location_structure_id%type;
40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
37:
38: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
39: l_location_structure_id ar_system_parameters.location_structure_id%type;
40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
39: l_location_structure_id ar_system_parameters.location_structure_id%type;
40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;
40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;
48: l_org_class hr_locations_all.global_attribute1%type;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;
48: l_org_class hr_locations_all.global_attribute1%type;
49: l_taxable_basis ar_vat_tax.taxable_basis%type;
42: l_tax_rounding_allow_override
43: ar_system_parameters.tax_rounding_allow_override%type;
44: l_tax_header_level_flag ar_system_parameters.tax_header_level_flag%type;
45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;
48: l_org_class hr_locations_all.global_attribute1%type;
49: l_taxable_basis ar_vat_tax.taxable_basis%type;
50: l_tax_calculation_plsql_block
254: l_tax_rounding_allow_override,
255: l_tax_header_level_flag,
256: l_tax_rounding_rule,
257: l_tax_rule_set
258: FROM ar_system_parameters_all sys --Bugfix 2367111
259: WHERE nvl(sys.org_id,-99) = nvl(p_org_id,-99); --Bugfix 2367111;
260:
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
558: HZ_CUST_ACCT_SITES ACCT_SITE,
559: HZ_CUST_SITE_USES SITE,
560: HZ_PARTIES PARTY,
561: HZ_CUST_ACCOUNTS CUST_ACCT,
562: AR_SYSTEM_PARAMETERS SYS
563: WHERE SITE.SITE_USE_ID = l_site_use_id
564: AND SITE.SITE_USE_CODE = l_site_use_code
565: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
566: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID