eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SERVICEREQUEST_PUB dependencies on FND_GLOBAL

Line 310: -- ID, and login ID to the values from the FND_GLOBAL global variables.

306: -- If the parameter is NULL, then the default value for that attribute is
307: -- returned; otherwise, the passed value is returned. Defaulting rules
308: -- are:
309: -- 1. Defaults the responsibility application ID, responsiblity ID, user
310: -- ID, and login ID to the values from the FND_GLOBAL global variables.
311: -- 2. If Multi-Org is enabled, default the operating unit ID to the value
312: -- from the RDBMS session-level global variable or the profile option;
313: -- otherwise, default to NULL.
314: -- 3. Defaults the inventory organization ID to the value from the

Line 4123: -- FND_GLOBAL.RESP_APPL_ID, FND_GLOBAL.RESP_ID, and FND_GLOBAL.LOGIN_ID

4119: -- Initialize API return status to success
4120: p_return_status := FND_API.G_RET_STS_SUCCESS;
4121:
4122: -- ----------------------------------------------------------------------
4123: -- FND_GLOBAL.RESP_APPL_ID, FND_GLOBAL.RESP_ID, and FND_GLOBAL.LOGIN_ID
4124: -- returns -1 by default, which is an invalid value. FND_GLOBAL.USER_ID
4125: -- is okay, because user ID -1 corresponds to user 'ANONYMOUS.' If
4126: -- FND_GLOBAL returns -1, the variables are set to NULL instead.
4127: -- ----------------------------------------------------------------------

Line 4124: -- returns -1 by default, which is an invalid value. FND_GLOBAL.USER_ID

4120: p_return_status := FND_API.G_RET_STS_SUCCESS;
4121:
4122: -- ----------------------------------------------------------------------
4123: -- FND_GLOBAL.RESP_APPL_ID, FND_GLOBAL.RESP_ID, and FND_GLOBAL.LOGIN_ID
4124: -- returns -1 by default, which is an invalid value. FND_GLOBAL.USER_ID
4125: -- is okay, because user ID -1 corresponds to user 'ANONYMOUS.' If
4126: -- FND_GLOBAL returns -1, the variables are set to NULL instead.
4127: -- ----------------------------------------------------------------------
4128:

Line 4126: -- FND_GLOBAL returns -1, the variables are set to NULL instead.

4122: -- ----------------------------------------------------------------------
4123: -- FND_GLOBAL.RESP_APPL_ID, FND_GLOBAL.RESP_ID, and FND_GLOBAL.LOGIN_ID
4124: -- returns -1 by default, which is an invalid value. FND_GLOBAL.USER_ID
4125: -- is okay, because user ID -1 corresponds to user 'ANONYMOUS.' If
4126: -- FND_GLOBAL returns -1, the variables are set to NULL instead.
4127: -- ----------------------------------------------------------------------
4128:
4129: IF ((p_resp_appl_id IS NULL) AND (FND_GLOBAL.RESP_APPL_ID <> -1)) THEN
4130: -- ID is not passed in, return the default.

Line 4129: IF ((p_resp_appl_id IS NULL) AND (FND_GLOBAL.RESP_APPL_ID <> -1)) THEN

4125: -- is okay, because user ID -1 corresponds to user 'ANONYMOUS.' If
4126: -- FND_GLOBAL returns -1, the variables are set to NULL instead.
4127: -- ----------------------------------------------------------------------
4128:
4129: IF ((p_resp_appl_id IS NULL) AND (FND_GLOBAL.RESP_APPL_ID <> -1)) THEN
4130: -- ID is not passed in, return the default.
4131: p_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4132:
4133: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

Line 4131: p_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

4127: -- ----------------------------------------------------------------------
4128:
4129: IF ((p_resp_appl_id IS NULL) AND (FND_GLOBAL.RESP_APPL_ID <> -1)) THEN
4130: -- ID is not passed in, return the default.
4131: p_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4132:
4133: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4134: THEN
4135: FND_LOG.String

Line 4137: , 'The Value of profile FND_GLOBAL.RESP_APPL_ID :' || p_resp_appl_id

4133: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4134: THEN
4135: FND_LOG.String
4136: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4137: , 'The Value of profile FND_GLOBAL.RESP_APPL_ID :' || p_resp_appl_id
4138: );
4139: END IF;
4140: END IF;
4141:

Line 4142: IF ((p_resp_id IS NULL) AND (FND_GLOBAL.RESP_ID <> -1)) THEN

4138: );
4139: END IF;
4140: END IF;
4141:
4142: IF ((p_resp_id IS NULL) AND (FND_GLOBAL.RESP_ID <> -1)) THEN
4143: p_resp_id := FND_GLOBAL.RESP_ID;
4144:
4145: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4146: THEN

Line 4143: p_resp_id := FND_GLOBAL.RESP_ID;

4139: END IF;
4140: END IF;
4141:
4142: IF ((p_resp_id IS NULL) AND (FND_GLOBAL.RESP_ID <> -1)) THEN
4143: p_resp_id := FND_GLOBAL.RESP_ID;
4144:
4145: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4146: THEN
4147: FND_LOG.String

Line 4149: , 'The Value of profile FND_GLOBAL.RESP_ID :' || p_resp_id

4145: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4146: THEN
4147: FND_LOG.String
4148: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4149: , 'The Value of profile FND_GLOBAL.RESP_ID :' || p_resp_id
4150: );
4151: END IF;
4152: END IF;
4153:

Line 4155: p_user_id := FND_GLOBAL.USER_ID;

4151: END IF;
4152: END IF;
4153:
4154: IF (p_user_id IS NULL) THEN
4155: p_user_id := FND_GLOBAL.USER_ID;
4156:
4157: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4158: THEN
4159: FND_LOG.String

Line 4161: , 'The Value of profile FND_GLOBAL.USER_ID :' || p_user_id

4157: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4158: THEN
4159: FND_LOG.String
4160: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4161: , 'The Value of profile FND_GLOBAL.USER_ID :' || p_user_id
4162: );
4163: END IF;
4164: END IF;
4165:

Line 4167: (FND_GLOBAL.LOGIN_ID NOT IN (-1,0))) THEN

4163: END IF;
4164: END IF;
4165:
4166: IF ((p_login_id = FND_API.G_MISS_NUM) AND
4167: (FND_GLOBAL.LOGIN_ID NOT IN (-1,0))) THEN
4168: p_login_id := FND_GLOBAL.LOGIN_ID;
4169:
4170: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4171: THEN

Line 4168: p_login_id := FND_GLOBAL.LOGIN_ID;

4164: END IF;
4165:
4166: IF ((p_login_id = FND_API.G_MISS_NUM) AND
4167: (FND_GLOBAL.LOGIN_ID NOT IN (-1,0))) THEN
4168: p_login_id := FND_GLOBAL.LOGIN_ID;
4169:
4170: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4171: THEN
4172: FND_LOG.String

Line 4174: , 'The Value of profile FND_GLOBAL.LOGIN_ID :' || p_login_id

4170: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4171: THEN
4172: FND_LOG.String
4173: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4174: , 'The Value of profile FND_GLOBAL.LOGIN_ID :' || p_login_id
4175: );
4176: END IF;
4177: ELSE
4178: p_login_id := NULL;

Line 6400: AND problem.SECURITY_GROUP_ID = fnd_global.lookup_security_group(problem.LOOKUP_TYPE, problem.VIEW_APPLICATION_ID)

6396: WHERE problem.lookup_code = inc.problem_code
6397: AND problem.lookup_type = 'REQUEST_PROBLEM_CODE'
6398: AND problem.LANGUAGE = userenv('LANG')
6399: AND problem.View_APPLICATION_ID = 170
6400: AND problem.SECURITY_GROUP_ID = fnd_global.lookup_security_group(problem.LOOKUP_TYPE, problem.VIEW_APPLICATION_ID)
6401: ) Problemcode
6402: ,inc.resolution_code ResolutioncodeId
6403: ,(SELECT resolution.meaning
6404: FROM FND_LOOKUP_VALUES resolution

Line 6409: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE, resolution.VIEW_APPLICATION_ID)

6405: WHERE resolution.lookup_code = inc.resolution_code
6406: AND resolution.lookup_type = 'REQUEST_RESOLUTION_CODE'
6407: AND resolution.LANGUAGE = userenv('LANG')
6408: AND resolution.View_APPLICATION_ID = 170
6409: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE, resolution.VIEW_APPLICATION_ID)
6410: ) Resolutioncode
6411: ,inc.publish_flag PublishFlag
6412: ,(SELECT channel.meaning
6413: FROM FND_LOOKUP_VALUES channel

Line 6418: AND channel.SECURITY_GROUP_ID = fnd_global.lookup_security_group(channel.LOOKUP_TYPE,channel.VIEW_APPLICATION_ID)

6414: WHERE channel.lookup_code = inc.sr_creation_channel
6415: AND channel.lookup_type = 'CS_SR_CREATION_CHANNEL'
6416: AND channel.LANGUAGE = userenv('LANG')
6417: AND channel.View_APPLICATION_ID = 170
6418: AND channel.SECURITY_GROUP_ID = fnd_global.lookup_security_group(channel.LOOKUP_TYPE,channel.VIEW_APPLICATION_ID)
6419: ) SrCreationChannel
6420: ,tl.summary Summary
6421: ,tl.resolution_summary ResolutionSummary
6422: ,(select usr.user_name

Line 6432: AND cont_type_lkup.SECURITY_GROUP_ID = fnd_global.lookup_security_group(cont_type_lkup.LOOKUP_TYPE, cont_type_lkup.VIEW_APPLICATION_ID)

6428: where sr_cont.contact_type=cont_type_lkup.lookup_code
6429: and cont_type_lkup.lookup_type = 'CS_SR_CONTACT_TYPE'
6430: AND cont_type_lkup.LANGUAGE = userenv('LANG')
6431: AND cont_type_lkup.View_APPLICATION_ID = 170
6432: AND cont_type_lkup.SECURITY_GROUP_ID = fnd_global.lookup_security_group(cont_type_lkup.LOOKUP_TYPE, cont_type_lkup.VIEW_APPLICATION_ID)
6433: )ContactType
6434: ,csz_servicerequest_util_pvt.get_contact_name(sr_cont.contact_type,
6435: sr_cont.party_id,
6436: inc.customer_id) ContactName

Line 6516: and cust_type_lkup.SECURITY_GROUP_ID = fnd_global.lookup_security_group(cust_type_lkup.LOOKUP_TYPE,cust_type_lkup.VIEW_APPLICATION_ID)

6512: WHERE party.party_type = cust_type_lkup.lookup_code
6513: AND cust_type_lkup.lookup_type='CS_SR_CALLER_TYPE'
6514: and cust_type_lkup.LANGUAGE = userenv('LANG')
6515: and cust_type_lkup.View_APPLICATION_ID = 170
6516: and cust_type_lkup.SECURITY_GROUP_ID = fnd_global.lookup_security_group(cust_type_lkup.LOOKUP_TYPE,cust_type_lkup.VIEW_APPLICATION_ID)
6517: ) CustomerType
6518: ,decode(sr_cont.contact_type,'EMPLOYEE', (select phone_number
6519: from per_phones per
6520: where per.phone_id = sr_cont.contact_point_id)