233: BEGIN
234:
235:
236: SELECT
237: FND_GLOBAL.USER_ID,
238: FND_GLOBAL.USER_NAME,
239: FND_GLOBAL.RESP_NAME,
240: FND_GLOBAL.APPLICATION_NAME,
241: FND_GLOBAL.RESP_APPL_ID
234:
235:
236: SELECT
237: FND_GLOBAL.USER_ID,
238: FND_GLOBAL.USER_NAME,
239: FND_GLOBAL.RESP_NAME,
240: FND_GLOBAL.APPLICATION_NAME,
241: FND_GLOBAL.RESP_APPL_ID
242: INTO v_user_id,
235:
236: SELECT
237: FND_GLOBAL.USER_ID,
238: FND_GLOBAL.USER_NAME,
239: FND_GLOBAL.RESP_NAME,
240: FND_GLOBAL.APPLICATION_NAME,
241: FND_GLOBAL.RESP_APPL_ID
242: INTO v_user_id,
243: l_user_name,
236: SELECT
237: FND_GLOBAL.USER_ID,
238: FND_GLOBAL.USER_NAME,
239: FND_GLOBAL.RESP_NAME,
240: FND_GLOBAL.APPLICATION_NAME,
241: FND_GLOBAL.RESP_APPL_ID
242: INTO v_user_id,
243: l_user_name,
244: l_resp_name,
237: FND_GLOBAL.USER_ID,
238: FND_GLOBAL.USER_NAME,
239: FND_GLOBAL.RESP_NAME,
240: FND_GLOBAL.APPLICATION_NAME,
241: FND_GLOBAL.RESP_APPL_ID
242: INTO v_user_id,
243: l_user_name,
244: l_resp_name,
245: l_application_name,