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_MIGRATE_UTIL

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 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 1067: SUBSTRB('O_TB_' || p_tax,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),

1063:
1064:
1065: SELECT DECODE(SIGN(LENGTHB('O_TB_' || p_tax) - 30),
1066: 1,
1067: SUBSTRB('O_TB_' || p_tax,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
1068: 'O_TB_' || p_tax)
1069: INTO l_tax_rule_code
1070: FROM DUAL;
1071: