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 ,
801: SYSDATE ,
802: fnd_global.conc_login_id ,
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 ,
801: SYSDATE ,
802: fnd_global.conc_login_id ,
803: fnd_global.conc_request_id ,--Request Id
804: fnd_global.prog_appl_id ,--Program Application ID
798: fnd_global.user_id ,
799: SYSDATE ,
800: fnd_global.user_id ,
801: SYSDATE ,
802: fnd_global.conc_login_id ,
803: fnd_global.conc_request_id ,--Request Id
804: fnd_global.prog_appl_id ,--Program Application ID
805: fnd_global.conc_program_id ,--Program Id
806: fnd_global.conc_login_id ,--Program Login ID
799: SYSDATE ,
800: fnd_global.user_id ,
801: SYSDATE ,
802: fnd_global.conc_login_id ,
803: fnd_global.conc_request_id ,--Request Id
804: fnd_global.prog_appl_id ,--Program Application ID
805: fnd_global.conc_program_id ,--Program Id
806: fnd_global.conc_login_id ,--Program Login ID
807: 1
800: fnd_global.user_id ,
801: SYSDATE ,
802: fnd_global.conc_login_id ,
803: fnd_global.conc_request_id ,--Request Id
804: fnd_global.prog_appl_id ,--Program Application ID
805: fnd_global.conc_program_id ,--Program Id
806: fnd_global.conc_login_id ,--Program Login ID
807: 1
808: FROM DUAL
801: SYSDATE ,
802: fnd_global.conc_login_id ,
803: fnd_global.conc_request_id ,--Request Id
804: fnd_global.prog_appl_id ,--Program Application ID
805: fnd_global.conc_program_id ,--Program Id
806: fnd_global.conc_login_id ,--Program Login ID
807: 1
808: FROM DUAL
809: WHERE
802: fnd_global.conc_login_id ,
803: fnd_global.conc_request_id ,--Request Id
804: fnd_global.prog_appl_id ,--Program Application ID
805: fnd_global.conc_program_id ,--Program Id
806: fnd_global.conc_login_id ,--Program Login ID
807: 1
808: FROM DUAL
809: WHERE
810: --Re-runnability
846: THEN Initcap(formula_code)
847: ELSE
848: formula_code
849: END,
850: fnd_global.user_id ,
851: SYSDATE ,
852: fnd_global.user_id ,
853: SYSDATE ,
854: fnd_global.conc_login_id,
848: formula_code
849: END,
850: fnd_global.user_id ,
851: SYSDATE ,
852: fnd_global.user_id ,
853: SYSDATE ,
854: fnd_global.conc_login_id,
855: l.language_code ,
856: userenv('LANG')
850: fnd_global.user_id ,
851: SYSDATE ,
852: fnd_global.user_id ,
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')
903: 'ADD' ,
904: 'MIGRATED' ,
905: SYSDATE ,
906: SYSDATE ,
907: fnd_global.user_id ,
908: fnd_global.user_id ,
909: fnd_global.conc_login_id ,
910: fnd_global.conc_request_id ,--Request Id
911: fnd_global.prog_appl_id ,--Program Application ID
904: 'MIGRATED' ,
905: SYSDATE ,
906: SYSDATE ,
907: fnd_global.user_id ,
908: fnd_global.user_id ,
909: fnd_global.conc_login_id ,
910: fnd_global.conc_request_id ,--Request Id
911: fnd_global.prog_appl_id ,--Program Application ID
912: fnd_global.conc_program_id ,--Program Id
905: SYSDATE ,
906: SYSDATE ,
907: fnd_global.user_id ,
908: fnd_global.user_id ,
909: fnd_global.conc_login_id ,
910: fnd_global.conc_request_id ,--Request Id
911: fnd_global.prog_appl_id ,--Program Application ID
912: fnd_global.conc_program_id ,--Program Id
913: fnd_global.conc_login_id ,--Program Login ID
906: SYSDATE ,
907: fnd_global.user_id ,
908: fnd_global.user_id ,
909: fnd_global.conc_login_id ,
910: fnd_global.conc_request_id ,--Request Id
911: fnd_global.prog_appl_id ,--Program Application ID
912: fnd_global.conc_program_id ,--Program Id
913: fnd_global.conc_login_id ,--Program Login ID
914: 1
907: fnd_global.user_id ,
908: fnd_global.user_id ,
909: fnd_global.conc_login_id ,
910: fnd_global.conc_request_id ,--Request Id
911: fnd_global.prog_appl_id ,--Program Application ID
912: fnd_global.conc_program_id ,--Program Id
913: fnd_global.conc_login_id ,--Program Login ID
914: 1
915:
908: fnd_global.user_id ,
909: fnd_global.conc_login_id ,
910: fnd_global.conc_request_id ,--Request Id
911: fnd_global.prog_appl_id ,--Program Application ID
912: fnd_global.conc_program_id ,--Program Id
913: fnd_global.conc_login_id ,--Program Login ID
914: 1
915:
916: FROM DUAL
909: fnd_global.conc_login_id ,
910: fnd_global.conc_request_id ,--Request Id
911: fnd_global.prog_appl_id ,--Program Application ID
912: fnd_global.conc_program_id ,--Program Id
913: fnd_global.conc_login_id ,--Program Login ID
914: 1
915:
916: FROM DUAL
917: WHERE
959: 'ADD' ,
960: 'MIGRATED' ,
961: SYSDATE ,
962: SYSDATE ,
963: fnd_global.user_id ,
964: fnd_global.user_id ,
965: fnd_global.conc_login_id ,
966: fnd_global.conc_request_id ,--Request Id
967: fnd_global.prog_appl_id ,--Program Application ID
960: 'MIGRATED' ,
961: SYSDATE ,
962: SYSDATE ,
963: fnd_global.user_id ,
964: fnd_global.user_id ,
965: fnd_global.conc_login_id ,
966: fnd_global.conc_request_id ,--Request Id
967: fnd_global.prog_appl_id ,--Program Application ID
968: fnd_global.conc_program_id ,--Program Id
961: SYSDATE ,
962: SYSDATE ,
963: fnd_global.user_id ,
964: fnd_global.user_id ,
965: fnd_global.conc_login_id ,
966: fnd_global.conc_request_id ,--Request Id
967: fnd_global.prog_appl_id ,--Program Application ID
968: fnd_global.conc_program_id ,--Program Id
969: fnd_global.conc_login_id ,--Program Login ID
962: SYSDATE ,
963: fnd_global.user_id ,
964: fnd_global.user_id ,
965: fnd_global.conc_login_id ,
966: fnd_global.conc_request_id ,--Request Id
967: fnd_global.prog_appl_id ,--Program Application ID
968: fnd_global.conc_program_id ,--Program Id
969: fnd_global.conc_login_id ,--Program Login ID
970: 1
963: fnd_global.user_id ,
964: fnd_global.user_id ,
965: fnd_global.conc_login_id ,
966: fnd_global.conc_request_id ,--Request Id
967: fnd_global.prog_appl_id ,--Program Application ID
968: fnd_global.conc_program_id ,--Program Id
969: fnd_global.conc_login_id ,--Program Login ID
970: 1
971: FROM zx_tax_relations_t t
964: fnd_global.user_id ,
965: fnd_global.conc_login_id ,
966: fnd_global.conc_request_id ,--Request Id
967: fnd_global.prog_appl_id ,--Program Application ID
968: fnd_global.conc_program_id ,--Program Id
969: fnd_global.conc_login_id ,--Program Login ID
970: 1
971: FROM zx_tax_relations_t t
972: WHERE t.child_regime_code = p_child_regime_code
965: fnd_global.conc_login_id ,
966: fnd_global.conc_request_id ,--Request Id
967: fnd_global.prog_appl_id ,--Program Application ID
968: fnd_global.conc_program_id ,--Program Id
969: fnd_global.conc_login_id ,--Program Login ID
970: 1
971: FROM zx_tax_relations_t t
972: WHERE t.child_regime_code = p_child_regime_code
973: AND t.child_tax_code = p_child_tax_code
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 ,
1088: fnd_global.conc_login_id,
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 ,
1088: fnd_global.conc_login_id,
1089: fnd_global.conc_request_id ,--Request Id
1090: fnd_global.prog_appl_id ,--Program Application ID
1084: fnd_global.user_id ,
1085: SYSDATE ,
1086: fnd_global.user_id ,
1087: SYSDATE ,
1088: fnd_global.conc_login_id,
1089: fnd_global.conc_request_id ,--Request Id
1090: fnd_global.prog_appl_id ,--Program Application ID
1091: fnd_global.conc_program_id ,--Program Id
1092: fnd_global.conc_login_id ,--Program Login ID
1085: SYSDATE ,
1086: fnd_global.user_id ,
1087: SYSDATE ,
1088: fnd_global.conc_login_id,
1089: fnd_global.conc_request_id ,--Request Id
1090: fnd_global.prog_appl_id ,--Program Application ID
1091: fnd_global.conc_program_id ,--Program Id
1092: fnd_global.conc_login_id ,--Program Login ID
1093: 1
1086: fnd_global.user_id ,
1087: SYSDATE ,
1088: fnd_global.conc_login_id,
1089: fnd_global.conc_request_id ,--Request Id
1090: fnd_global.prog_appl_id ,--Program Application ID
1091: fnd_global.conc_program_id ,--Program Id
1092: fnd_global.conc_login_id ,--Program Login ID
1093: 1
1094: FROM DUAL
1087: SYSDATE ,
1088: fnd_global.conc_login_id,
1089: fnd_global.conc_request_id ,--Request Id
1090: fnd_global.prog_appl_id ,--Program Application ID
1091: fnd_global.conc_program_id ,--Program Id
1092: fnd_global.conc_login_id ,--Program Login ID
1093: 1
1094: FROM DUAL
1095: WHERE
1088: fnd_global.conc_login_id,
1089: fnd_global.conc_request_id ,--Request Id
1090: fnd_global.prog_appl_id ,--Program Application ID
1091: fnd_global.conc_program_id ,--Program Id
1092: fnd_global.conc_login_id ,--Program Login ID
1093: 1
1094: FROM DUAL
1095: WHERE
1096: --Re-runnability
1137: THEN Initcap(tax_rule_code)
1138: ELSE
1139: tax_rule_code
1140: END,
1141: fnd_global.user_id ,
1142: SYSDATE ,
1143: fnd_global.user_id ,
1144: SYSDATE ,
1145: fnd_global.conc_login_id,
1139: tax_rule_code
1140: END,
1141: fnd_global.user_id ,
1142: SYSDATE ,
1143: fnd_global.user_id ,
1144: SYSDATE ,
1145: fnd_global.conc_login_id,
1146: l.language_code ,
1147: userenv('LANG')
1141: fnd_global.user_id ,
1142: SYSDATE ,
1143: fnd_global.user_id ,
1144: SYSDATE ,
1145: fnd_global.conc_login_id,
1146: l.language_code ,
1147: userenv('LANG')
1148: FROM fnd_languages l, zx_rules_b rules
1149: WHERE l.installed_flag IN ('I', 'B')
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 ,
1233: fnd_global.user_id ,
1234: SYSDATE ,
1235: fnd_global.conc_login_id ,
1229: p_tax_condition_id , --condition set id
1230: p_tax_exception_id , --exception set id
1231: fnd_global.user_id ,
1232: SYSDATE ,
1233: fnd_global.user_id ,
1234: SYSDATE ,
1235: fnd_global.conc_login_id ,
1236: fnd_global.conc_request_id ,--Request Id
1237: fnd_global.prog_appl_id ,--Program Application ID
1231: fnd_global.user_id ,
1232: SYSDATE ,
1233: fnd_global.user_id ,
1234: SYSDATE ,
1235: fnd_global.conc_login_id ,
1236: fnd_global.conc_request_id ,--Request Id
1237: fnd_global.prog_appl_id ,--Program Application ID
1238: fnd_global.conc_program_id ,--Program Id
1239: fnd_global.conc_login_id ,--Program Login ID
1232: SYSDATE ,
1233: fnd_global.user_id ,
1234: SYSDATE ,
1235: fnd_global.conc_login_id ,
1236: fnd_global.conc_request_id ,--Request Id
1237: fnd_global.prog_appl_id ,--Program Application ID
1238: fnd_global.conc_program_id ,--Program Id
1239: fnd_global.conc_login_id ,--Program Login ID
1240: 1
1233: fnd_global.user_id ,
1234: SYSDATE ,
1235: fnd_global.conc_login_id ,
1236: fnd_global.conc_request_id ,--Request Id
1237: fnd_global.prog_appl_id ,--Program Application ID
1238: fnd_global.conc_program_id ,--Program Id
1239: fnd_global.conc_login_id ,--Program Login ID
1240: 1
1241:
1234: SYSDATE ,
1235: fnd_global.conc_login_id ,
1236: fnd_global.conc_request_id ,--Request Id
1237: fnd_global.prog_appl_id ,--Program Application ID
1238: fnd_global.conc_program_id ,--Program Id
1239: fnd_global.conc_login_id ,--Program Login ID
1240: 1
1241:
1242: FROM dual
1235: fnd_global.conc_login_id ,
1236: fnd_global.conc_request_id ,--Request Id
1237: fnd_global.prog_appl_id ,--Program Application ID
1238: fnd_global.conc_program_id ,--Program Id
1239: fnd_global.conc_login_id ,--Program Login ID
1240: 1
1241:
1242: FROM dual
1243: WHERE