APPS.IEM_SERVICEREQUEST_PVT dependencies on FND_PROFILE

Line 78: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

74: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
75: l_cs_version_number NUMBER:=3.0;
76:
77:
78: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
79: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
80:
81: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
82: l_msg_count NUMBER := 0;

Line 79: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;

75: l_cs_version_number NUMBER:=3.0;
76:
77:
78: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
79: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
80:
81: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
82: l_msg_count NUMBER := 0;
83: l_msg_data VARCHAR2(2000);

Line 390: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

386:
387: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
388: l_cs_version_number NUMBER:=3.0;
389:
390: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
391: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
392:
393: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
394: l_msg_count NUMBER := 0;

Line 391: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;

387: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
388: l_cs_version_number NUMBER:=3.0;
389:
390: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
391: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
392:
393: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
394: l_msg_count NUMBER := 0;
395: l_msg_data VARCHAR2(2000);

Line 1045: FND_PROFILE.Get('IEM_SR_SUM_PREFIX', l_summary_prefix);

1041: THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044:
1045: FND_PROFILE.Get('IEM_SR_SUM_PREFIX', l_summary_prefix);
1046:
1047: l_summary := l_summary_prefix||' : '|| p_subject ;
1048:
1049:

Line 1138: l_auto_assign := fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML');

1134: --end siahmed bug 12663292 fixing the issue bill to ship to site id
1135:
1136:
1137: -- abhgauta - Debug for Bug 6373644
1138: l_auto_assign := fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML');
1139:
1140: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');
1141:
1142:

Line 1140: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');

1136:
1137: -- abhgauta - Debug for Bug 6373644
1138: l_auto_assign := fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML');
1139:
1140: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');
1141:
1142:
1143: CS_ServiceRequest_PUB.Create_ServiceRequest (
1144: p_api_version => l_cs_version_number,