DBA Data[Home] [Help]

APPS.CS_TP_TEMPLATES_PVT dependencies on FND_PROFILE

Line 56: Return FND_PROFILE.VALUE_SPECIFIC(

52: FUNCTION get_date_format_from_user(p_user_id IN NUMBER)
53: RETURN VARCHAR2 AS
54: BEGIN
55: -- get the default date format for this user
56: Return FND_PROFILE.VALUE_SPECIFIC(
57: 'ICX_DATE_FORMAT_MASK',
58: p_user_id,
59: null,
60: null);

Line 73: p_format := FND_PROFILE.VALUE_SPECIFIC(

69: p_format varchar2(100) := null;
70: BEGIN
71: p_user_id := get_user_id;
72: -- get the default date format for this user
73: p_format := FND_PROFILE.VALUE_SPECIFIC(
74: 'ICX_DATE_FORMAT_MASK',
75: p_user_id,
76: null,
77: null);

Line 1104: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_PRODUCT' ) ;

1100:
1101: For i In p_Object_Other_list.FIRST..p_Object_Other_list.last Loop
1102: profileOn := false;
1103: If ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_PRODUCT' ) Then
1104: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_PRODUCT' ) ;
1105: If ( profileValue Is Not Null And profileValue = 'Y' ) Then
1106: profileOn := true;
1107: End If;
1108: Elsif ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_PLATFORM' ) Then

Line 1109: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_PLATFORM' ) ;

1105: If ( profileValue Is Not Null And profileValue = 'Y' ) Then
1106: profileOn := true;
1107: End If;
1108: Elsif ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_PLATFORM' ) Then
1109: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_PLATFORM' ) ;
1110: If ( profileValue is not null And profileValue = 'Y' ) Then
1111: profileOn := true;
1112: End If;
1113: Elsif ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_LINK_URGENCY' ) Then

Line 1114: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_URGENCY' ) ;

1110: If ( profileValue is not null And profileValue = 'Y' ) Then
1111: profileOn := true;
1112: End If;
1113: Elsif ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_LINK_URGENCY' ) Then
1114: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_URGENCY' ) ;
1115: If ( profileValue Is Not Null And profileValue = 'Y' ) Then
1116: profileOn := true;
1117: End If;
1118: Elsif ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_TP_SR_TYPE' ) Then

Line 1119: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_SR_TYPE' ) ;

1115: If ( profileValue Is Not Null And profileValue = 'Y' ) Then
1116: profileOn := true;
1117: End If;
1118: Elsif ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_TP_SR_TYPE' ) Then
1119: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_SR_TYPE' ) ;
1120: If ( profileValue Is Not Null And profileValue = 'Y' ) Then
1121: profileOn := true;
1122: End If;
1123: Elsif ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_TP_SR_PROBCODE' ) Then

Line 1124: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_PROB_CODE' ) ;

1120: If ( profileValue Is Not Null And profileValue = 'Y' ) Then
1121: profileOn := true;
1122: End If;
1123: Elsif ( P_Object_Other_list(i).mOBJECT_CODE = 'IBU_TP_SR_PROBCODE' ) Then
1124: profileValue := fnd_profile.value ( 'IBU_SR_TP_SEARCH_PROB_CODE' ) ;
1125: If ( profileValue Is Not Null And profileValue = 'Y' ) Then
1126: profileOn := true;
1127: End If;
1128: End If;