DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on FND_GLOBAL

Line 4400: l_user_id NUMBER :=FND_GLOBAL.USER_ID;

4396: l_api_name CONSTANT VARCHAR2(30) := 'Validate_User_Update';
4397: l_api_version CONSTANT NUMBER := 1.0;
4398: l_db_quote_header_id NUMBER;
4399: l_party_id NUMBER;
4400: l_user_id NUMBER :=FND_GLOBAL.USER_ID;
4401: l_db_user_id NUMBER;
4402: l_privilege_type_code VARCHAR2(10);
4403: l_end_date_active DATE;
4404: l_upgrade_flag varchar2(1) := FND_API.G_TRUE;

Line 4944: select fnd_global.resp_appl_id appId from dual;

4940: ) IS
4941:
4942: cursor c_getAppId
4943: is
4944: select fnd_global.resp_appl_id appId from dual;
4945: rec_AppId c_getAppId%rowtype;
4946:
4947: cursor c_getRespId
4948: is

Line 4949: select fnd_global.resp_id respId from dual;

4945: rec_AppId c_getAppId%rowtype;
4946:
4947: cursor c_getRespId
4948: is
4949: select fnd_global.resp_id respId from dual;
4950: rec_RespId c_getRespId%rowtype;
4951:
4952: cursor c_getUserId
4953: is

Line 4954: select fnd_global.user_id userId from dual;

4950: rec_RespId c_getRespId%rowtype;
4951:
4952: cursor c_getUserId
4953: is
4954: select fnd_global.user_id userId from dual;
4955: rec_UserId c_getUserId%rowtype;
4956:
4957: cursor c_getOrgId
4958: is

Line 4964: SELECT FND_GLOBAL.SESSION_ID session_id

4960: rec_OrgId c_getOrgId%rowtype;
4961:
4962: cursor c_getEnvInfo
4963: is
4964: SELECT FND_GLOBAL.SESSION_ID session_id
4965: ,FND_GLOBAL.USER_NAME user_name
4966: ,FND_GLOBAL.LOGIN_ID login_id
4967: ,userenv('CLIENT_INFO') client_info
4968: ,userenv('LANG') lang

Line 4965: ,FND_GLOBAL.USER_NAME user_name

4961:
4962: cursor c_getEnvInfo
4963: is
4964: SELECT FND_GLOBAL.SESSION_ID session_id
4965: ,FND_GLOBAL.USER_NAME user_name
4966: ,FND_GLOBAL.LOGIN_ID login_id
4967: ,userenv('CLIENT_INFO') client_info
4968: ,userenv('LANG') lang
4969: FROM dual;

Line 4966: ,FND_GLOBAL.LOGIN_ID login_id

4962: cursor c_getEnvInfo
4963: is
4964: SELECT FND_GLOBAL.SESSION_ID session_id
4965: ,FND_GLOBAL.USER_NAME user_name
4966: ,FND_GLOBAL.LOGIN_ID login_id
4967: ,userenv('CLIENT_INFO') client_info
4968: ,userenv('LANG') lang
4969: FROM dual;
4970: rec_EnvInfo c_getEnvInfo%rowtype;