DBA Data[Home] [Help]

APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on FND_GLOBAL

Line 833: DECODE(p_code_con_rec.last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_code_con_rec.last_updated_by),

829: CURSOR c_pop_rec IS
830: SELECT code_conversion_id,
831: object_version_number,
832: SYSDATE,
833: DECODE(p_code_con_rec.last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_code_con_rec.last_updated_by),
834: DECODE(p_code_con_rec.last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_LOGIN_ID,p_code_con_rec.last_update_login),
835: ORG_ID,
836: supp_trade_profile_id,
837: DECODE( p_code_con_rec.code_conversion_type, FND_API.g_miss_char, code_conversion_type, p_code_con_rec.code_conversion_type),

Line 834: DECODE(p_code_con_rec.last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_LOGIN_ID,p_code_con_rec.last_update_login),

830: SELECT code_conversion_id,
831: object_version_number,
832: SYSDATE,
833: DECODE(p_code_con_rec.last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_code_con_rec.last_updated_by),
834: DECODE(p_code_con_rec.last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_LOGIN_ID,p_code_con_rec.last_update_login),
835: ORG_ID,
836: supp_trade_profile_id,
837: DECODE( p_code_con_rec.code_conversion_type, FND_API.g_miss_char, code_conversion_type, p_code_con_rec.code_conversion_type),
838: external_code,

Line 2943: FND_GLOBAL.USER_ID,

2939: ) VALUES (
2940: l_crt_code_conv(indx).CODE_CONVERSION_ID,
2941: l_crt_code_conv(indx).OBJECT_VERSION_NUMBER,
2942: SYSDATE,
2943: FND_GLOBAL.USER_ID,
2944: SYSDATE,
2945: FND_GLOBAL.USER_ID,
2946: FND_GLOBAL.CONC_LOGIN_ID,
2947: l_crt_code_conv(indx).ORG_ID,

Line 2945: FND_GLOBAL.USER_ID,

2941: l_crt_code_conv(indx).OBJECT_VERSION_NUMBER,
2942: SYSDATE,
2943: FND_GLOBAL.USER_ID,
2944: SYSDATE,
2945: FND_GLOBAL.USER_ID,
2946: FND_GLOBAL.CONC_LOGIN_ID,
2947: l_crt_code_conv(indx).ORG_ID,
2948: l_crt_code_conv(indx).SUPP_TRADE_PROFILE_ID,
2949: DECODE( l_crt_code_conv(indx).code_conversion_type, FND_API.g_miss_char, NULL, l_crt_code_conv(indx).code_conversion_type),

Line 2946: FND_GLOBAL.CONC_LOGIN_ID,

2942: SYSDATE,
2943: FND_GLOBAL.USER_ID,
2944: SYSDATE,
2945: FND_GLOBAL.USER_ID,
2946: FND_GLOBAL.CONC_LOGIN_ID,
2947: l_crt_code_conv(indx).ORG_ID,
2948: l_crt_code_conv(indx).SUPP_TRADE_PROFILE_ID,
2949: DECODE( l_crt_code_conv(indx).code_conversion_type, FND_API.g_miss_char, NULL, l_crt_code_conv(indx).code_conversion_type),
2950: DECODE( l_crt_code_conv(indx).external_code, FND_API.g_miss_char, NULL, l_crt_code_conv(indx).external_code),

Line 2996: last_updated_by = FND_GLOBAL.USER_ID,

2992: Update ozf_supp_code_conversions_all
2993: SET
2994: object_version_number = l_upd_code_conv(indx).object_version_number +1 ,
2995: last_update_date = sysdate,
2996: last_updated_by = FND_GLOBAL.USER_ID,
2997: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
2998: org_id = l_upd_code_conv(indx).org_id,
2999: supp_trade_profile_id = l_upd_code_conv(indx).supp_trade_profile_id ,
3000: code_conversion_type = l_upd_code_conv(indx).code_conversion_type,

Line 2997: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

2993: SET
2994: object_version_number = l_upd_code_conv(indx).object_version_number +1 ,
2995: last_update_date = sysdate,
2996: last_updated_by = FND_GLOBAL.USER_ID,
2997: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
2998: org_id = l_upd_code_conv(indx).org_id,
2999: supp_trade_profile_id = l_upd_code_conv(indx).supp_trade_profile_id ,
3000: code_conversion_type = l_upd_code_conv(indx).code_conversion_type,
3001: external_code = l_upd_code_conv(indx).external_code,

Line 3271: l_process_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID ;

3267: l_process_rec.OBJECT_VERSION_NUMBER := r_pp_data.objVerNum ;
3268: l_process_rec.LAST_UPDATE_DATE := SYSDATE ;
3269:
3270: IF (p_process_setup_tbl(indx).last_updated_by = FND_API.G_MISS_NUM) THEN
3271: l_process_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID ;
3272: ELSE
3273: l_process_rec.LAST_UPDATED_BY := p_process_setup_tbl(indx).last_updated_by ;
3274: END IF ;
3275: