APPS.PVX_CHANNEL_TYPE_PVT dependencies on FND_GLOBAL

Line 120: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY

116: ,l_channel_type_rec.channel_lookup_type
117: ,l_channel_type_rec.channel_lookup_code
118: ,l_channel_type_rec.indirect_channel_flag
119: ,SYSDATE -- LAST_UPDATE_DATE
120: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
121: ,SYSDATE -- CREATION_DATE
122: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
123: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
124: ,l_object_version_number -- object_version_number

Line 122: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY

118: ,l_channel_type_rec.indirect_channel_flag
119: ,SYSDATE -- LAST_UPDATE_DATE
120: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
121: ,SYSDATE -- CREATION_DATE
122: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
123: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
124: ,l_object_version_number -- object_version_number
125: ,l_channel_type_rec.rank
126: );

Line 123: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN

119: ,SYSDATE -- LAST_UPDATE_DATE
120: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
121: ,SYSDATE -- CREATION_DATE
122: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
123: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
124: ,l_object_version_number -- object_version_number
125: ,l_channel_type_rec.rank
126: );
127:

Line 386: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)

382:
383: UPDATE PV_CHANNEL_TYPES
384: SET
385: last_update_date = SYSDATE
386: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
387: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
388: ,channel_lookup_type = l_channel_type_rec.channel_lookup_type
389: ,channel_lookup_code = l_channel_type_rec.channel_lookup_code
390: ,indirect_channel_flag = l_channel_type_rec.indirect_channel_flag

Line 387: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)

383: UPDATE PV_CHANNEL_TYPES
384: SET
385: last_update_date = SYSDATE
386: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
387: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
388: ,channel_lookup_type = l_channel_type_rec.channel_lookup_type
389: ,channel_lookup_code = l_channel_type_rec.channel_lookup_code
390: ,indirect_channel_flag = l_channel_type_rec.indirect_channel_flag
391: ,object_version_number = l_channel_type_rec.object_version_number + 1