DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on FND_GLOBAL

Line 4282: l_user_id NUMBER :=FND_GLOBAL.USER_ID;

4278: l_api_name CONSTANT VARCHAR2(30) := 'Validate_User_Update';
4279: l_api_version CONSTANT NUMBER := 1.0;
4280: l_db_quote_header_id NUMBER;
4281: l_party_id NUMBER;
4282: l_user_id NUMBER :=FND_GLOBAL.USER_ID;
4283: l_db_user_id NUMBER;
4284: l_privilege_type_code VARCHAR2(10);
4285: l_end_date_active DATE;
4286: l_upgrade_flag varchar2(1) := FND_API.G_TRUE;

Line 4802: select fnd_global.resp_appl_id appId from dual;

4798: ) IS
4799:
4800: cursor c_getAppId
4801: is
4802: select fnd_global.resp_appl_id appId from dual;
4803: rec_AppId c_getAppId%rowtype;
4804:
4805: cursor c_getRespId
4806: is

Line 4807: select fnd_global.resp_id respId from dual;

4803: rec_AppId c_getAppId%rowtype;
4804:
4805: cursor c_getRespId
4806: is
4807: select fnd_global.resp_id respId from dual;
4808: rec_RespId c_getRespId%rowtype;
4809:
4810: cursor c_getUserId
4811: is

Line 4812: select fnd_global.user_id userId from dual;

4808: rec_RespId c_getRespId%rowtype;
4809:
4810: cursor c_getUserId
4811: is
4812: select fnd_global.user_id userId from dual;
4813: rec_UserId c_getUserId%rowtype;
4814:
4815: cursor c_getOrgId
4816: is

Line 4822: SELECT FND_GLOBAL.SESSION_ID session_id

4818: rec_OrgId c_getOrgId%rowtype;
4819:
4820: cursor c_getEnvInfo
4821: is
4822: SELECT FND_GLOBAL.SESSION_ID session_id
4823: ,FND_GLOBAL.USER_NAME user_name
4824: ,FND_GLOBAL.LOGIN_ID login_id
4825: ,userenv('CLIENT_INFO') client_info
4826: ,userenv('LANG') lang

Line 4823: ,FND_GLOBAL.USER_NAME user_name

4819:
4820: cursor c_getEnvInfo
4821: is
4822: SELECT FND_GLOBAL.SESSION_ID session_id
4823: ,FND_GLOBAL.USER_NAME user_name
4824: ,FND_GLOBAL.LOGIN_ID login_id
4825: ,userenv('CLIENT_INFO') client_info
4826: ,userenv('LANG') lang
4827: FROM dual;

Line 4824: ,FND_GLOBAL.LOGIN_ID login_id

4820: cursor c_getEnvInfo
4821: is
4822: SELECT FND_GLOBAL.SESSION_ID session_id
4823: ,FND_GLOBAL.USER_NAME user_name
4824: ,FND_GLOBAL.LOGIN_ID login_id
4825: ,userenv('CLIENT_INFO') client_info
4826: ,userenv('LANG') lang
4827: FROM dual;
4828: rec_EnvInfo c_getEnvInfo%rowtype;