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