DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on FND_NUMBER

Line 2376: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))

2372: SELECT tc1.tax_category_id tax_category_id
2373: ,tc1.threshold_check_grp_by grp_attr_name
2374: ,tcl1.tax_attribute_value grp_attr_value
2375: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2376: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2377: charged_tax
2378: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2379: calculated_tax
2380: ,rl1.customer_trx_line_id inv_line_number

Line 2378: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))

2374: ,tcl1.tax_attribute_value grp_attr_value
2375: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2376: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2377: charged_tax
2378: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2379: calculated_tax
2380: ,rl1.customer_trx_line_id inv_line_number
2381: ,r1.customer_trx_id header_trx_id
2382: FROM ra_customer_trx r1

Line 2409: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))

2405: SELECT tc1.tax_category_id tax_category_id
2406: ,tc1.threshold_check_grp_by grp_attr_name
2407: ,tcl1.tax_attribute_value grp_attr_value
2408: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2409: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2410: charged_tax
2411: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2412: calculated_tax
2413: ,rl1.customer_trx_line_id inv_line_number

Line 2411: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))

2407: ,tcl1.tax_attribute_value grp_attr_value
2408: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2409: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2410: charged_tax
2411: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2412: calculated_tax
2413: ,rl1.customer_trx_line_id inv_line_number
2414: ,r1.customer_trx_id header_trx_id
2415: FROM ra_customer_trx r1

Line 2442: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))

2438: SELECT tc1.tax_category_id tax_category_id
2439: ,tc1.threshold_check_grp_by grp_attr_name
2440: ,tcl1.tax_attribute_value grp_attr_value
2441: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2442: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2443: charged_tax
2444: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2445: calculated_tax
2446: ,rl1.customer_trx_line_id inv_line_number

Line 2444: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))

2440: ,tcl1.tax_attribute_value grp_attr_value
2441: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2442: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2443: charged_tax
2444: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2445: calculated_tax
2446: ,rl1.customer_trx_line_id inv_line_number
2447: ,r1.customer_trx_id header_trx_id
2448: FROM ra_customer_trx r1

Line 2475: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))

2471: SELECT tc1.tax_category_id tax_category_id
2472: ,tc1.threshold_check_grp_by grp_attr_name
2473: ,tcl1.tax_attribute_value grp_attr_value
2474: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2475: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2476: charged_tax
2477: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2478: calculated_tax
2479: ,rl1.customer_trx_line_id inv_line_number

Line 2477: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))

2473: ,tcl1.tax_attribute_value grp_attr_value
2474: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2475: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2476: charged_tax
2477: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2478: calculated_tax
2479: ,rl1.customer_trx_line_id inv_line_number
2480: ,r1.customer_trx_id header_trx_id
2481: FROM ra_customer_trx r1

Line 4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines

4328: -- set the default global attributes for the tax lines
4329: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;
4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4331:
4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4334: fnd_number.number_to_canonical (v_base_amount);
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);

Line 4334: fnd_number.number_to_canonical (v_base_amount);

4330: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4331:
4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4334: fnd_number.number_to_canonical (v_base_amount);
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines

Line 4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);

4332: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4333: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4334: fnd_number.number_to_canonical (v_base_amount);
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);

Line 4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines

4334: fnd_number.number_to_canonical (v_base_amount);
4335: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4342: fnd_number.number_to_canonical( v_calculated_tax_amount);

Line 4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);

4336: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4337:
4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4342: fnd_number.number_to_canonical( v_calculated_tax_amount);
4343:
4344: -- Added following 1 line to take care of bug# 787259

Line 4342: fnd_number.number_to_canonical( v_calculated_tax_amount);

4338: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4339: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4340: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4341: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4342: fnd_number.number_to_canonical( v_calculated_tax_amount);
4343:
4344: -- Added following 1 line to take care of bug# 787259
4345: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_amount := v_base_amount;
4346: END IF;