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,
816: SYSDATE,
817: fnd_global.conc_login_id,
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,
816: SYSDATE,
817: fnd_global.conc_login_id,
818: fnd_global.conc_request_id, --Request Id
819: fnd_global.prog_appl_id, --Program Application ID
813: fnd_global.user_id,
814: SYSDATE,
815: fnd_global.user_id,
816: SYSDATE,
817: fnd_global.conc_login_id,
818: fnd_global.conc_request_id, --Request Id
819: fnd_global.prog_appl_id, --Program Application ID
820: fnd_global.conc_program_id, --Program Id
821: fnd_global.conc_login_id, --Program Login ID
814: SYSDATE,
815: fnd_global.user_id,
816: SYSDATE,
817: fnd_global.conc_login_id,
818: fnd_global.conc_request_id, --Request Id
819: fnd_global.prog_appl_id, --Program Application ID
820: fnd_global.conc_program_id, --Program Id
821: fnd_global.conc_login_id, --Program Login ID
822: 1
815: fnd_global.user_id,
816: SYSDATE,
817: fnd_global.conc_login_id,
818: fnd_global.conc_request_id, --Request Id
819: fnd_global.prog_appl_id, --Program Application ID
820: fnd_global.conc_program_id, --Program Id
821: fnd_global.conc_login_id, --Program Login ID
822: 1
823: FROM DUAL
816: SYSDATE,
817: fnd_global.conc_login_id,
818: fnd_global.conc_request_id, --Request Id
819: fnd_global.prog_appl_id, --Program Application ID
820: fnd_global.conc_program_id, --Program Id
821: fnd_global.conc_login_id, --Program Login ID
822: 1
823: FROM DUAL
824: WHERE
817: fnd_global.conc_login_id,
818: fnd_global.conc_request_id, --Request Id
819: fnd_global.prog_appl_id, --Program Application ID
820: fnd_global.conc_program_id, --Program Id
821: fnd_global.conc_login_id, --Program Login ID
822: 1
823: FROM DUAL
824: WHERE
825: --Re-runnability
859: THEN Initcap(formula_code)
860: ELSE
861: formula_code
862: END,
863: fnd_global.user_id,
864: SYSDATE,
865: fnd_global.user_id,
866: SYSDATE,
867: fnd_global.conc_login_id,
861: formula_code
862: END,
863: fnd_global.user_id,
864: SYSDATE,
865: fnd_global.user_id,
866: SYSDATE,
867: fnd_global.conc_login_id,
868: l.language_code,
869: userenv('LANG')
863: fnd_global.user_id,
864: SYSDATE,
865: fnd_global.user_id,
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')
936: 'ADD',
937: 'MIGRATED',
938: SYSDATE,
939: SYSDATE,
940: fnd_global.user_id,
941: fnd_global.user_id,
942: fnd_global.conc_login_id,
943: fnd_global.conc_request_id, --Request Id
944: fnd_global.prog_appl_id, --Program Application ID
937: 'MIGRATED',
938: SYSDATE,
939: SYSDATE,
940: fnd_global.user_id,
941: fnd_global.user_id,
942: fnd_global.conc_login_id,
943: fnd_global.conc_request_id, --Request Id
944: fnd_global.prog_appl_id, --Program Application ID
945: fnd_global.conc_program_id, --Program Id
938: SYSDATE,
939: SYSDATE,
940: fnd_global.user_id,
941: fnd_global.user_id,
942: fnd_global.conc_login_id,
943: fnd_global.conc_request_id, --Request Id
944: fnd_global.prog_appl_id, --Program Application ID
945: fnd_global.conc_program_id, --Program Id
946: fnd_global.conc_login_id, --Program Login ID
939: SYSDATE,
940: fnd_global.user_id,
941: fnd_global.user_id,
942: fnd_global.conc_login_id,
943: fnd_global.conc_request_id, --Request Id
944: fnd_global.prog_appl_id, --Program Application ID
945: fnd_global.conc_program_id, --Program Id
946: fnd_global.conc_login_id, --Program Login ID
947: 1
940: fnd_global.user_id,
941: fnd_global.user_id,
942: fnd_global.conc_login_id,
943: fnd_global.conc_request_id, --Request Id
944: fnd_global.prog_appl_id, --Program Application ID
945: fnd_global.conc_program_id, --Program Id
946: fnd_global.conc_login_id, --Program Login ID
947: 1
948: FROM zx_tax_relations_t t
941: fnd_global.user_id,
942: fnd_global.conc_login_id,
943: fnd_global.conc_request_id, --Request Id
944: fnd_global.prog_appl_id, --Program Application ID
945: fnd_global.conc_program_id, --Program Id
946: fnd_global.conc_login_id, --Program Login ID
947: 1
948: FROM zx_tax_relations_t t
949: WHERE t.child_regime_code = p_child_regime_code
942: fnd_global.conc_login_id,
943: fnd_global.conc_request_id, --Request Id
944: fnd_global.prog_appl_id, --Program Application ID
945: fnd_global.conc_program_id, --Program Id
946: fnd_global.conc_login_id, --Program Login ID
947: 1
948: FROM zx_tax_relations_t t
949: WHERE t.child_regime_code = p_child_regime_code
950: AND t.child_tax_code = p_child_tax_code
996: 'ADD',
997: 'MIGRATED',
998: SYSDATE,
999: SYSDATE,
1000: fnd_global.user_id,
1001: fnd_global.user_id,
1002: fnd_global.conc_login_id,
1003: fnd_global.conc_request_id, --Request Id
1004: fnd_global.prog_appl_id, --Program Application ID
997: 'MIGRATED',
998: SYSDATE,
999: SYSDATE,
1000: fnd_global.user_id,
1001: fnd_global.user_id,
1002: fnd_global.conc_login_id,
1003: fnd_global.conc_request_id, --Request Id
1004: fnd_global.prog_appl_id, --Program Application ID
1005: fnd_global.conc_program_id, --Program Id
998: SYSDATE,
999: SYSDATE,
1000: fnd_global.user_id,
1001: fnd_global.user_id,
1002: fnd_global.conc_login_id,
1003: fnd_global.conc_request_id, --Request Id
1004: fnd_global.prog_appl_id, --Program Application ID
1005: fnd_global.conc_program_id, --Program Id
1006: fnd_global.conc_login_id, --Program Login ID
999: SYSDATE,
1000: fnd_global.user_id,
1001: fnd_global.user_id,
1002: fnd_global.conc_login_id,
1003: fnd_global.conc_request_id, --Request Id
1004: fnd_global.prog_appl_id, --Program Application ID
1005: fnd_global.conc_program_id, --Program Id
1006: fnd_global.conc_login_id, --Program Login ID
1007: 1
1000: fnd_global.user_id,
1001: fnd_global.user_id,
1002: fnd_global.conc_login_id,
1003: fnd_global.conc_request_id, --Request Id
1004: fnd_global.prog_appl_id, --Program Application ID
1005: fnd_global.conc_program_id, --Program Id
1006: fnd_global.conc_login_id, --Program Login ID
1007: 1
1008: FROM zx_tax_relations_t t
1001: fnd_global.user_id,
1002: fnd_global.conc_login_id,
1003: fnd_global.conc_request_id, --Request Id
1004: fnd_global.prog_appl_id, --Program Application ID
1005: fnd_global.conc_program_id, --Program Id
1006: fnd_global.conc_login_id, --Program Login ID
1007: 1
1008: FROM zx_tax_relations_t t
1009: WHERE t.child_regime_code = p_child_regime_code
1002: fnd_global.conc_login_id,
1003: fnd_global.conc_request_id, --Request Id
1004: fnd_global.prog_appl_id, --Program Application ID
1005: fnd_global.conc_program_id, --Program Id
1006: fnd_global.conc_login_id, --Program Login ID
1007: 1
1008: FROM zx_tax_relations_t t
1009: WHERE t.child_regime_code = p_child_regime_code
1010: AND t.child_tax_code = p_child_tax_code
1117: 'MIGRATED',
1118: 'STCC',
1119: p_content_owner_id,
1120: zx_rules_b_s.NEXTVAL,
1121: fnd_global.user_id,
1122: SYSDATE,
1123: fnd_global.user_id,
1124: SYSDATE,
1125: fnd_global.conc_login_id,
1119: p_content_owner_id,
1120: zx_rules_b_s.NEXTVAL,
1121: fnd_global.user_id,
1122: SYSDATE,
1123: fnd_global.user_id,
1124: SYSDATE,
1125: fnd_global.conc_login_id,
1126: fnd_global.conc_request_id, --Request Id
1127: fnd_global.prog_appl_id, --Program Application ID
1121: fnd_global.user_id,
1122: SYSDATE,
1123: fnd_global.user_id,
1124: SYSDATE,
1125: fnd_global.conc_login_id,
1126: fnd_global.conc_request_id, --Request Id
1127: fnd_global.prog_appl_id, --Program Application ID
1128: fnd_global.conc_program_id, --Program Id
1129: fnd_global.conc_login_id, --Program Login ID
1122: SYSDATE,
1123: fnd_global.user_id,
1124: SYSDATE,
1125: fnd_global.conc_login_id,
1126: fnd_global.conc_request_id, --Request Id
1127: fnd_global.prog_appl_id, --Program Application ID
1128: fnd_global.conc_program_id, --Program Id
1129: fnd_global.conc_login_id, --Program Login ID
1130: 1
1123: fnd_global.user_id,
1124: SYSDATE,
1125: fnd_global.conc_login_id,
1126: fnd_global.conc_request_id, --Request Id
1127: fnd_global.prog_appl_id, --Program Application ID
1128: fnd_global.conc_program_id, --Program Id
1129: fnd_global.conc_login_id, --Program Login ID
1130: 1
1131: FROM DUAL
1124: SYSDATE,
1125: fnd_global.conc_login_id,
1126: fnd_global.conc_request_id, --Request Id
1127: fnd_global.prog_appl_id, --Program Application ID
1128: fnd_global.conc_program_id, --Program Id
1129: fnd_global.conc_login_id, --Program Login ID
1130: 1
1131: FROM DUAL
1132: WHERE
1125: fnd_global.conc_login_id,
1126: fnd_global.conc_request_id, --Request Id
1127: fnd_global.prog_appl_id, --Program Application ID
1128: fnd_global.conc_program_id, --Program Id
1129: fnd_global.conc_login_id, --Program Login ID
1130: 1
1131: FROM DUAL
1132: WHERE
1133: --Re-runnability
1175: THEN Initcap(tax_rule_code)
1176: ELSE
1177: tax_rule_code
1178: END,
1179: fnd_global.user_id,
1180: SYSDATE,
1181: fnd_global.user_id,
1182: SYSDATE,
1183: fnd_global.conc_login_id,
1177: tax_rule_code
1178: END,
1179: fnd_global.user_id,
1180: SYSDATE,
1181: fnd_global.user_id,
1182: SYSDATE,
1183: fnd_global.conc_login_id,
1184: l.language_code,
1185: userenv('LANG')
1179: fnd_global.user_id,
1180: SYSDATE,
1181: fnd_global.user_id,
1182: SYSDATE,
1183: fnd_global.conc_login_id,
1184: l.language_code,
1185: userenv('LANG')
1186: FROM fnd_languages l, zx_rules_b rules
1187: WHERE l.installed_flag IN ('I', 'B')
1285: p_condition_group_id,
1286: l_tax_rule_id, -- zx_rules_b.tax_rule_id(based on rule created above)8429806
1287: p_tax_condition_id, --condition set id
1288: p_tax_exception_id, --exception set id
1289: fnd_global.user_id,
1290: SYSDATE,
1291: fnd_global.user_id,
1292: SYSDATE,
1293: fnd_global.conc_login_id,
1287: p_tax_condition_id, --condition set id
1288: p_tax_exception_id, --exception set id
1289: fnd_global.user_id,
1290: SYSDATE,
1291: fnd_global.user_id,
1292: SYSDATE,
1293: fnd_global.conc_login_id,
1294: fnd_global.conc_request_id, --Request Id
1295: fnd_global.prog_appl_id, --Program Application ID
1289: fnd_global.user_id,
1290: SYSDATE,
1291: fnd_global.user_id,
1292: SYSDATE,
1293: fnd_global.conc_login_id,
1294: fnd_global.conc_request_id, --Request Id
1295: fnd_global.prog_appl_id, --Program Application ID
1296: fnd_global.conc_program_id, --Program Id
1297: fnd_global.conc_login_id, --Program Login ID
1290: SYSDATE,
1291: fnd_global.user_id,
1292: SYSDATE,
1293: fnd_global.conc_login_id,
1294: fnd_global.conc_request_id, --Request Id
1295: fnd_global.prog_appl_id, --Program Application ID
1296: fnd_global.conc_program_id, --Program Id
1297: fnd_global.conc_login_id, --Program Login ID
1298: 1
1291: fnd_global.user_id,
1292: SYSDATE,
1293: fnd_global.conc_login_id,
1294: fnd_global.conc_request_id, --Request Id
1295: fnd_global.prog_appl_id, --Program Application ID
1296: fnd_global.conc_program_id, --Program Id
1297: fnd_global.conc_login_id, --Program Login ID
1298: 1
1299: FROM dual
1292: SYSDATE,
1293: fnd_global.conc_login_id,
1294: fnd_global.conc_request_id, --Request Id
1295: fnd_global.prog_appl_id, --Program Application ID
1296: fnd_global.conc_program_id, --Program Id
1297: fnd_global.conc_login_id, --Program Login ID
1298: 1
1299: FROM dual
1300: WHERE
1293: fnd_global.conc_login_id,
1294: fnd_global.conc_request_id, --Request Id
1295: fnd_global.prog_appl_id, --Program Application ID
1296: fnd_global.conc_program_id, --Program Id
1297: fnd_global.conc_login_id, --Program Login ID
1298: 1
1299: FROM dual
1300: WHERE
1301: --Re-runnability