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 333: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S'),

329: IF l_child_precedence <> 1 THEN
330:
331: SELECT DECODE( SIGN( LENGTH(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30),
332: 1,
333: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S'),
334: l_tax_group_code||'_'||l_child_tax_code||'_TB')
335: INTO l_formula_code
336: FROM DUAL;
337:

Line 553: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),

549: -- which will be that of the ParentRegime / ParentTax.
550:
551: SELECT DECODE(SIGN(LENGTH(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30),
552: 1,
553: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),
554: l_tax_group_code||'_'||l_child_tax_code||'_TB')
555: INTO l_formula_code
556: FROM DUAL;
557:

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

608: arp_util_tax.debug('Case 4:after create_rules');
609:
610: ELSIF l_child_taxable_basis <> 'PRIOR_TAX' THEN
611: -- then create formula header with taxable basis type as LineAmount.
612: -- INSERT INTO zx_formula_b with taxable_basis_type = 'LINE_AMOUNT';
613: -- it is in decode of create_formula()
614:
615: SELECT DECODE(SIGN(LENGTH(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30),
616: 1,

Line 617: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),

613: -- it is in decode of create_formula()
614:
615: SELECT DECODE(SIGN(LENGTH(l_tax_group_code||'_'||l_child_tax_code||'_TB') - 30),
616: 1,
617: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),
618: l_tax_group_code||'_'||l_child_tax_code||'_TB')
619: INTO l_formula_code
620: FROM DUAL;
621:

Line 720: (--for zx_formula_b

716: *****************************************************************************************/
717:
718:
719: PROCEDURE CREATE_FORMULA
720: (--for zx_formula_b
721: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
722: p_formula_code IN zx_formula_b.formula_code%TYPE,
723: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
724: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,

Line 722: p_formula_code IN zx_formula_b.formula_code%TYPE,

718:
719: PROCEDURE CREATE_FORMULA
720: (--for zx_formula_b
721: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
722: p_formula_code IN zx_formula_b.formula_code%TYPE,
723: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
724: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
725: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
726: p_discount_flag IN CHAR,

Line 739: l_formula_id zx_formula_b.formula_id%TYPE;

735: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,
736: p_tax_code IN zx_rates_b.tax %TYPE,
737: x_return_status OUT NOCOPY VARCHAR2) IS
738:
739: l_formula_id zx_formula_b.formula_id%TYPE;
740:
741: BEGIN
742:
743: -- Inserting values in table zx_formula_b

Line 743: -- Inserting values in table zx_formula_b

739: l_formula_id zx_formula_b.formula_id%TYPE;
740:
741: BEGIN
742:
743: -- Inserting values in table zx_formula_b
744:
745: arp_util_tax.debug('in create_formula() for : '||p_tax_code);
746: BEGIN
747: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B

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

743: -- Inserting values in table zx_formula_b
744:
745: arp_util_tax.debug('in create_formula() for : '||p_tax_code);
746: BEGIN
747: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B
748: INSERT INTO zx_formula_b_tmp (
749: formula_type_code ,
750: formula_code ,
751: tax_regime_code ,

Line 748: INSERT INTO zx_formula_b_tmp (

744:
745: arp_util_tax.debug('in create_formula() for : '||p_tax_code);
746: BEGIN
747: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B
748: INSERT INTO zx_formula_b_tmp (
749: formula_type_code ,
750: formula_code ,
751: tax_regime_code ,
752: tax ,

Line 796: zx_formula_b_s.NEXTVAL l_formula_id,

792: p_charge_flag ,
793: p_charge_flag ,
794: p_charge_flag ,
795: p_charge_flag ,
796: zx_formula_b_s.NEXTVAL l_formula_id,
797: p_content_owner_id ,
798: fnd_global.user_id ,
799: SYSDATE ,
800: fnd_global.user_id ,

Line 812: FROM zx_formula_b

808: FROM DUAL
809: WHERE
810: --Re-runnability
811: NOT EXISTS ( SELECT 1
812: FROM zx_formula_b
813: WHERE SUBSTRB(formula_code,1,24) = SUBSTRB(p_formula_code,1,24)
814: AND (effective_from BETWEEN
815: p_start_date and nvl(p_end_date,SYSDATE)
816: OR

Line 857: FROM fnd_languages l, zx_formula_b formula

853: SYSDATE ,
854: fnd_global.conc_login_id,
855: l.language_code ,
856: userenv('LANG')
857: FROM fnd_languages l, zx_formula_b formula
858: WHERE l.installed_flag IN ('I', 'B')
859: AND formula.record_type_code = 'MIGRATED'
860: AND formula.formula_code = p_formula_code
861: AND NOT EXISTS(SELECT NULL

Line 900: zx_formula_b_s.CURRVAL ,

896: object_version_number
897: )
898: SELECT
899: zx_formula_details_s.NEXTVAL ,
900: zx_formula_b_s.CURRVAL ,
901: p_parent_regime_code ,
902: p_parent_tax_code ,
903: 'ADD' ,
904: 'MIGRATED' ,

Line 920: FROM zx_formula_details, zx_formula_b

916: FROM DUAL
917: WHERE
918: --Re-runnability
919: NOT EXISTS (SELECT 1
920: FROM zx_formula_details, zx_formula_b
921: WHERE zx_formula_details.formula_id = zx_formula_b.formula_id
922: AND compounding_tax_regime_code = p_parent_regime_code
923: AND compounding_tax = p_parent_tax_code);
924:

Line 921: WHERE zx_formula_details.formula_id = zx_formula_b.formula_id

917: WHERE
918: --Re-runnability
919: NOT EXISTS (SELECT 1
920: FROM zx_formula_details, zx_formula_b
921: WHERE zx_formula_details.formula_id = zx_formula_b.formula_id
922: AND compounding_tax_regime_code = p_parent_regime_code
923: AND compounding_tax = p_parent_tax_code);
924:
925: EXCEPTION WHEN OTHERS THEN

Line 956: zx_formula_b_s.CURRVAL ,

952: program_login_id ,
953: object_version_number
954: )
955: SELECT zx_formula_details_s.NEXTVAL ,
956: zx_formula_b_s.CURRVAL ,
957: parent_tax_code ,
958: parent_regime_code ,
959: 'ADD' ,
960: 'MIGRATED' ,

Line 976: FROM zx_formula_details, zx_formula_b

972: WHERE t.child_regime_code = p_child_regime_code
973: AND t.child_tax_code = p_child_tax_code
974: AND t.tax_group_id = p_group_id
975: AND NOT EXISTS (SELECT 1
976: FROM zx_formula_details, zx_formula_b
977: WHERE zx_formula_details.formula_id = zx_formula_b.formula_id
978: AND compounding_tax_regime_code = p_parent_regime_code
979: AND compounding_tax = p_parent_tax_code
980: AND

Line 977: WHERE zx_formula_details.formula_id = zx_formula_b.formula_id

973: AND t.child_tax_code = p_child_tax_code
974: AND t.tax_group_id = p_group_id
975: AND NOT EXISTS (SELECT 1
976: FROM zx_formula_details, zx_formula_b
977: WHERE zx_formula_details.formula_id = zx_formula_b.formula_id
978: AND compounding_tax_regime_code = p_parent_regime_code
979: AND compounding_tax = p_parent_tax_code
980: AND
981: contains(zx_formula_b.formula_code, t.tax_group_code) > 0

Line 981: contains(zx_formula_b.formula_code, t.tax_group_code) > 0

977: WHERE zx_formula_details.formula_id = zx_formula_b.formula_id
978: AND compounding_tax_regime_code = p_parent_regime_code
979: AND compounding_tax = p_parent_tax_code
980: AND
981: contains(zx_formula_b.formula_code, t.tax_group_code) > 0
982: )
983: and rownum = 1;
984:
985: -- the above contains clause is introduced as part of 6718736