DBA Data[Home] [Help]

APPS.ZX_AR_FORMULA_MIG_PKG dependencies on FND_GLOBAL

Line 798: fnd_global.user_id ,

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 ,

Line 800: fnd_global.user_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

Line 802: fnd_global.conc_login_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

Line 803: fnd_global.conc_request_id ,--Request 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

Line 804: fnd_global.prog_appl_id ,--Program Application ID

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

Line 805: fnd_global.conc_program_id ,--Program 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
809: WHERE

Line 806: fnd_global.conc_login_id ,--Program Login ID

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

Line 850: fnd_global.user_id ,

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,

Line 852: fnd_global.user_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')

Line 854: fnd_global.conc_login_id,

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')

Line 907: fnd_global.user_id ,

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

Line 908: fnd_global.user_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

Line 909: fnd_global.conc_login_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

Line 910: fnd_global.conc_request_id ,--Request 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

Line 911: fnd_global.prog_appl_id ,--Program Application ID

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:

Line 912: fnd_global.conc_program_id ,--Program 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:
916: FROM DUAL

Line 913: fnd_global.conc_login_id ,--Program Login 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
917: WHERE

Line 963: fnd_global.user_id ,

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

Line 964: fnd_global.user_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

Line 965: fnd_global.conc_login_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

Line 966: fnd_global.conc_request_id ,--Request 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

Line 967: fnd_global.prog_appl_id ,--Program Application ID

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

Line 968: fnd_global.conc_program_id ,--Program 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
972: WHERE t.child_regime_code = p_child_regime_code

Line 969: fnd_global.conc_login_id ,--Program Login 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
973: AND t.child_tax_code = p_child_tax_code

Line 1084: fnd_global.user_id ,

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,

Line 1086: fnd_global.user_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

Line 1088: fnd_global.conc_login_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

Line 1089: fnd_global.conc_request_id ,--Request 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

Line 1090: fnd_global.prog_appl_id ,--Program Application ID

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

Line 1091: fnd_global.conc_program_id ,--Program 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
1095: WHERE

Line 1092: fnd_global.conc_login_id ,--Program Login ID

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

Line 1141: fnd_global.user_id ,

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,

Line 1143: fnd_global.user_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')

Line 1145: fnd_global.conc_login_id,

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')

Line 1231: fnd_global.user_id ,

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 ,

Line 1233: fnd_global.user_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

Line 1235: fnd_global.conc_login_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

Line 1236: fnd_global.conc_request_id ,--Request 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

Line 1237: fnd_global.prog_appl_id ,--Program Application ID

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:

Line 1238: fnd_global.conc_program_id ,--Program 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:
1242: FROM dual

Line 1239: fnd_global.conc_login_id ,--Program Login ID

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