APPS.IEM_SERVICEREQUEST_PVT dependencies on FND_PROFILE

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

68: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
69: l_cs_version_number NUMBER:=3.0;
70:
71:
72: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
73: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
74:
75: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
76: l_msg_count NUMBER := 0;

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

69: l_cs_version_number NUMBER:=3.0;
70:
71:
72: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
73: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
74:
75: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
76: l_msg_count NUMBER := 0;
77: l_msg_data VARCHAR2(2000);

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

380:
381: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
382: l_cs_version_number NUMBER:=3.0;
383:
384: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
385: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
386:
387: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
388: l_msg_count NUMBER := 0;

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

381: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
382: l_cs_version_number NUMBER:=3.0;
383:
384: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
385: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
386:
387: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
388: l_msg_count NUMBER := 0;
389: l_msg_data VARCHAR2(2000);

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

1027: THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030:
1031: FND_PROFILE.Get('IEM_SR_SUM_PREFIX', l_summary_prefix);
1032:
1033: l_summary := l_summary_prefix||' : '|| p_subject ;
1034:
1035:

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

1083: END IF;
1084: END IF;
1085:
1086: -- abhgauta - Debug for Bug 6373644
1087: l_auto_assign := fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML');
1088:
1089: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');
1090:
1091:

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

1085:
1086: -- abhgauta - Debug for Bug 6373644
1087: l_auto_assign := fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML');
1088:
1089: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');
1090:
1091:
1092: CS_ServiceRequest_PUB.Create_ServiceRequest (
1093: p_api_version => l_cs_version_number,