DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on DUAL

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 4817: SELECT (MO_GLOBAL.get_current_org_id()) orgId from dual;

4813: rec_UserId c_getUserId%rowtype;
4814:
4815: cursor c_getOrgId
4816: is
4817: SELECT (MO_GLOBAL.get_current_org_id()) orgId from dual;
4818: rec_OrgId c_getOrgId%rowtype;
4819:
4820: cursor c_getEnvInfo
4821: is

Line 4827: FROM dual;

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;
4829:
4830: cursor c_getICXSessionDetails(p_session_id VARCHAR2)
4831: is

Line 4857: SELECT sys_context('multi_org2','current_org_id') sys_context from dual;

4853: rec_MOTempTableInfo c_getMOTempTableInfo%rowtype;
4854:
4855: cursor c_getSysContext
4856: is
4857: SELECT sys_context('multi_org2','current_org_id') sys_context from dual;
4858: rec_SysContext c_getSysContext%rowtype;
4859:
4860: Begin
4861: IF (IBE_UTIL.G_DEBUGON = l_true) THEN