33: BEGIN
34:
35: /* if user_id = -1, it means this procedure is called from a
36: remote database */
37: /*IF FND_GLOBAL.USER_ID = -1 THEN
38: */
39:
40: -- Debug snippet start
41: log_message('Inside PROCEDURE INITIALIZE');
72: WHEN OTHERS THEN RAISE;
73:
74: END;
75:
76: FND_GLOBAL.APPS_INITIALIZE( l_user_id,
77: l_resp_id,
78: l_application_id);
79:
80: /* END IF;*/
168: FROM FND_USER
169: WHERE USER_NAME = p_user_name;
170:
171:
172: if (fnd_global.user_id = -1) then
173: /* called from a remote database */
174:
175:
176: SELECT APPLICATION_ID
184: FROM FND_responsibility_vl
185: WHERE responsibility_name = p_resp_name
186: AND application_Id = l_application_id;
187:
188: FND_GLOBAL.APPS_INITIALIZE( l_user_id, l_resp_id, l_application_id);
189:
190: end if;
191:
192: /*
277: ||' DELIVER_TO_REQUESTOR_ID,'
278: ||' SUGGESTED_VENDOR_ID,'
279: ||' SUGGESTED_VENDOR_SITE,'
280: || l_user_id||','
281: --||' FND_GLOBAL.USER_ID,'
282: ||' SYSDATE,'
283: ||' LAST_UPDATE_LOGIN,'
284: ||' SYSDATE,'
285: || l_user_id||','
282: ||' SYSDATE,'
283: ||' LAST_UPDATE_LOGIN,'
284: ||' SYSDATE,'
285: || l_user_id||','
286: --||' FND_GLOBAL.USER_ID,'
287: ||' INTERFACE_SOURCE_CODE,'
288: ||' SOURCE_TYPE_CODE,'
289: ||' DESTINATION_TYPE_CODE,'
290: ||' QUANTITY,'
587: ||' DELIVER_TO_REQUESTOR_ID,'
588: ||' SUGGESTED_VENDOR_ID,'
589: ||' SUGGESTED_VENDOR_SITE,'
590: || l_user_id||','
591: --||' FND_GLOBAL.USER_ID,'
592: ||' SYSDATE,'
593: ||' LAST_UPDATE_LOGIN,'
594: ||' SYSDATE,'
595: || l_user_id||','
592: ||' SYSDATE,'
593: ||' LAST_UPDATE_LOGIN,'
594: ||' SYSDATE,'
595: || l_user_id||','
596: --||' FND_GLOBAL.USER_ID,'
597: ||' INTERFACE_SOURCE_CODE,'
598: ||' SOURCE_TYPE_CODE,'
599: ||' DESTINATION_TYPE_CODE,'
600: ||' QUANTITY,'