DBA Data[Home] [Help]

APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_RULES_B_S

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:

Line 1083: zx_rules_b_s.NEXTVAL ,

1079: p_enabled_flag ,
1080: 'MIGRATED' ,
1081: 'STCC' ,
1082: p_content_owner_id ,
1083: zx_rules_b_s.NEXTVAL ,
1084: fnd_global.user_id ,
1085: SYSDATE ,
1086: fnd_global.user_id ,
1087: SYSDATE ,

Line 1228: zx_rules_b_s.CURRVAL , -- zx_rules_b.tax_rule_id(based on rule created above)

1224: NULL ,
1225: zx_process_results_s.NEXTVAL ,
1226: p_content_owner_id , -- also used in insert of zx_rules_b also
1227: p_condition_group_id ,
1228: zx_rules_b_s.CURRVAL , -- zx_rules_b.tax_rule_id(based on rule created above)
1229: p_tax_condition_id , --condition set id
1230: p_tax_exception_id , --exception set id
1231: fnd_global.user_id ,
1232: SYSDATE ,