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.

APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_FORMULA_B

Line 34: l_formula_code zx_formula_b.formula_code%TYPE;

30: l_tax_exception_id ar_tax_group_codes_all.tax_exception_id%TYPE;
31: l_tax_group_id ar_tax_group_codes_all.tax_group_id%TYPE;
32:
33:
34: l_formula_code zx_formula_b.formula_code%TYPE;
35:
36: l_discount_flag CHAR;
37: l_charge_flag CHAR;
38:

Line 330: l_formula_code := ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S');

326:
327: IF l_child_precedence <> 1 THEN
328:
329: IF SIGN(LENGTHB(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30) > 0 THEN
330: l_formula_code := ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S');
331: IF LengthB(l_formula_code) + LengthB(SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB') - 30 > 0 THEN
332: l_formula_code := SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||
333: SubStrB(l_formula_code,(LengthB(l_formula_code) + LengthB(SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB') - 29));
334: ELSE

Line 543: l_formula_code := ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S');

539: -- there will be only one record in the Formula Details
540: -- which will be that of the ParentRegime / ParentTax.
541:
542: IF SIGN(LENGTHB(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30) > 0 THEN
543: l_formula_code := ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S');
544: IF LengthB(l_formula_code) + LengthB(SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB') - 30 > 0 THEN
545: l_formula_code := SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||
546: SubStrB(l_formula_code,(LengthB(l_formula_code) + LengthB(SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB') - 29));
547: ELSE

Line 607: -- INSERT INTO zx_formula_b with taxable_basis_type = 'LINE_AMOUNT';

603: arp_util_tax.debug('Case 4:after create_rules');
604:
605: ELSIF l_child_taxable_basis <> 'PRIOR_TAX' THEN
606: -- then create formula header with taxable basis type as LineAmount.
607: -- INSERT INTO zx_formula_b with taxable_basis_type = 'LINE_AMOUNT';
608: -- it is in decode of create_formula()
609:
610: IF SIGN(LENGTHB(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30) > 0 THEN
611: l_formula_code := ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S');

Line 611: l_formula_code := ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S');

607: -- INSERT INTO zx_formula_b with taxable_basis_type = 'LINE_AMOUNT';
608: -- it is in decode of create_formula()
609:
610: IF SIGN(LENGTHB(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30) > 0 THEN
611: l_formula_code := ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S');
612: IF LengthB(l_formula_code) + LengthB(SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB') - 30 > 0 THEN
613: l_formula_code := SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||
614: SubStrB(l_formula_code,(LengthB(l_formula_code) + LengthB(SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB') - 29));
615: ELSE

Line 735: (--for zx_formula_b

731: *****************************************************************************************/
732:
733:
734: PROCEDURE CREATE_FORMULA
735: (--for zx_formula_b
736: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
737: p_formula_code IN zx_formula_b.formula_code%TYPE,
738: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
739: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,

Line 737: p_formula_code IN zx_formula_b.formula_code%TYPE,

733:
734: PROCEDURE CREATE_FORMULA
735: (--for zx_formula_b
736: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
737: p_formula_code IN zx_formula_b.formula_code%TYPE,
738: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
739: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
740: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
741: p_discount_flag IN CHAR,

Line 754: l_formula_id zx_formula_b.formula_id%TYPE;

750: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,
751: p_tax_code IN zx_rates_b.tax %TYPE,
752: x_return_status OUT NOCOPY VARCHAR2) IS
753:
754: l_formula_id zx_formula_b.formula_id%TYPE;
755:
756: BEGIN
757:
758: -- Inserting values in table zx_formula_b

Line 758: -- Inserting values in table zx_formula_b

754: l_formula_id zx_formula_b.formula_id%TYPE;
755:
756: BEGIN
757:
758: -- Inserting values in table zx_formula_b
759:
760: arp_util_tax.debug('in create_formula() for : '||p_tax_code);
761: BEGIN
762: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B

Line 762: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B

758: -- Inserting values in table zx_formula_b
759:
760: arp_util_tax.debug('in create_formula() for : '||p_tax_code);
761: BEGIN
762: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B
763: INSERT INTO zx_formula_b_tmp (
764: formula_type_code,
765: formula_code,
766: tax_regime_code,

Line 763: INSERT INTO zx_formula_b_tmp (

759:
760: arp_util_tax.debug('in create_formula() for : '||p_tax_code);
761: BEGIN
762: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B
763: INSERT INTO zx_formula_b_tmp (
764: formula_type_code,
765: formula_code,
766: tax_regime_code,
767: tax,

Line 811: zx_formula_b_s.NEXTVAL l_formula_id,

807: p_charge_flag,
808: p_charge_flag,
809: p_charge_flag,
810: p_charge_flag,
811: zx_formula_b_s.NEXTVAL l_formula_id,
812: p_content_owner_id,
813: fnd_global.user_id,
814: SYSDATE,
815: fnd_global.user_id,

Line 827: FROM zx_formula_b

823: FROM DUAL
824: WHERE
825: --Re-runnability
826: NOT EXISTS ( SELECT 1
827: FROM zx_formula_b
828: WHERE SUBSTRB(formula_code,1,24) = SUBSTRB(p_formula_code,1,24)
829: AND (effective_from BETWEEN p_start_date and nvl(p_end_date,SYSDATE)
830: OR NVL(effective_to,sysdate) BETWEEN p_start_date and nvl(p_end_date,sysdate))
831: AND tax_regime_code = p_tax_regime_code

Line 870: FROM fnd_languages l, zx_formula_b formula

866: SYSDATE,
867: fnd_global.conc_login_id,
868: l.language_code,
869: userenv('LANG')
870: FROM fnd_languages l, zx_formula_b formula
871: WHERE l.installed_flag IN ('I', 'B')
872: AND formula.record_type_code = 'MIGRATED'
873: AND formula.formula_code = p_formula_code
874: AND NOT EXISTS(SELECT NULL

Line 890: FROM zx_formula_b

886: BEGIN
887: -- Bug 9504903
888: SELECT formula_id
889: INTO l_formula_id
890: FROM zx_formula_b
891: WHERE content_owner_id=p_content_owner_id
892: AND SUBSTRB(formula_code,1,24) = SUBSTRB(p_formula_code,1,24)
893: AND (effective_from BETWEEN p_start_date and nvl(p_end_date,SYSDATE)
894: OR NVL(effective_to,sysdate) BETWEEN p_start_date and nvl(p_end_date,sysdate))

Line 953: FROM zx_formula_details, zx_formula_b

949: WHERE t.child_regime_code = p_child_regime_code
950: AND t.child_tax_code = p_child_tax_code
951: AND t.tax_group_id = p_group_id
952: AND NOT EXISTS (SELECT 1
953: FROM zx_formula_details, zx_formula_b
954: WHERE zx_formula_details.formula_id = l_formula_id
955: AND compounding_tax_regime_code = p_parent_regime_code
956: AND compounding_tax = p_parent_tax_code
957: --AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0

Line 957: --AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0

953: FROM zx_formula_details, zx_formula_b
954: WHERE zx_formula_details.formula_id = l_formula_id
955: AND compounding_tax_regime_code = p_parent_regime_code
956: AND compounding_tax = p_parent_tax_code
957: --AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0
958: )
959: AND rownum = 1;
960:
961: EXCEPTION WHEN OTHERS THEN

Line 1013: FROM zx_formula_details, zx_formula_b

1009: WHERE t.child_regime_code = p_child_regime_code
1010: AND t.child_tax_code = p_child_tax_code
1011: AND t.tax_group_id = p_group_id
1012: AND NOT EXISTS (SELECT 1
1013: FROM zx_formula_details, zx_formula_b
1014: WHERE zx_formula_details.formula_id = l_formula_id -- Bug 8429806
1015: AND compounding_tax_regime_code = p_parent_regime_code
1016: AND compounding_tax = p_parent_tax_code
1017: -- AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0

Line 1017: -- AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0

1013: FROM zx_formula_details, zx_formula_b
1014: WHERE zx_formula_details.formula_id = l_formula_id -- Bug 8429806
1015: AND compounding_tax_regime_code = p_parent_regime_code
1016: AND compounding_tax = p_parent_tax_code
1017: -- AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0
1018: )
1019: and rownum = 1;
1020:
1021: -- the above contains clause is introduced as part of 6718736