DBA Data[Home] [Help]

APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_MIGRATE_UTIL

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

1026:
1027:
1028: SELECT DECODE(SIGN(LENGTHB('O_TB_' || p_tax) - 30),
1029: 1,
1030: SUBSTRB('O_TB_' || p_tax,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
1031: 'O_TB_' || p_tax)
1032: INTO l_tax_rule_code
1033: FROM DUAL;
1034: