APPS.AP_WEB_UTILITIES_PKG dependencies on FND_PROFILE

Line 86: p_resp_id => FND_PROFILE.VALUE('RESP_ID'),

82: FETCH l_userIdCursor INTO l_FNDUserID;
83: l_cCardEnabled := VALUE_SPECIFIC(
84: p_name => 'SSE_ENABLE_CREDIT_CARD',
85: p_user_id => l_FNDUserID,
86: p_resp_id => FND_PROFILE.VALUE('RESP_ID'),
87: p_apps_id => FND_PROFILE.VALUE('RESP_APPL_ID') );
88: EXIT WHEN (l_userIdCursor%NOTFOUND) OR (nvl(l_cCardEnabled,'N') = 'Y');
89: END LOOP;
90: CLOSE l_userIdCursor;

Line 87: p_apps_id => FND_PROFILE.VALUE('RESP_APPL_ID') );

83: l_cCardEnabled := VALUE_SPECIFIC(
84: p_name => 'SSE_ENABLE_CREDIT_CARD',
85: p_user_id => l_FNDUserID,
86: p_resp_id => FND_PROFILE.VALUE('RESP_ID'),
87: p_apps_id => FND_PROFILE.VALUE('RESP_APPL_ID') );
88: EXIT WHEN (l_userIdCursor%NOTFOUND) OR (nvl(l_cCardEnabled,'N') = 'Y');
89: END LOOP;
90: CLOSE l_userIdCursor;
91: ELSE

Line 92: FND_PROFILE.GET('SSE_ENABLE_CREDIT_CARD', l_cCardEnabled);

88: EXIT WHEN (l_userIdCursor%NOTFOUND) OR (nvl(l_cCardEnabled,'N') = 'Y');
89: END LOOP;
90: CLOSE l_userIdCursor;
91: ELSE
92: FND_PROFILE.GET('SSE_ENABLE_CREDIT_CARD', l_cCardEnabled);
93: END IF;
94:
95: return (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(p_employeeId, l_has) AND
96: l_has = 'Y' AND l_cCardEnabled = 'Y');

Line 567: FND_PROFILE.GET('AP_WEB_ALLOW_CREDIT_LINES',

563: -------------------------
564: l_credit_line_profile_option varchar2(1) := 'N';
565: l_allow_credit_lines Boolean := FALSE;
566: BEGIN
567: FND_PROFILE.GET('AP_WEB_ALLOW_CREDIT_LINES',
568: l_credit_line_profile_option);
569:
570: if (l_credit_line_profile_option = 'Y') then
571: l_allow_credit_lines := TRUE;

Line 2934: l_web_user_id Number := FND_PROFILE.VALUE('USER_ID');

2930: p_user_id IN NUMBER default null,
2931: p_resp_id IN NUMBER default null,
2932: p_apps_id IN NUMBER default null)
2933: RETURN VARCHAR2 IS
2934: l_web_user_id Number := FND_PROFILE.VALUE('USER_ID');
2935:
2936: BEGIN
2937: IF (l_web_user_id = p_user_id) THEN
2938: return FND_PROFILE.VALUE(NAME => p_name);

Line 2938: return FND_PROFILE.VALUE(NAME => p_name);

2934: l_web_user_id Number := FND_PROFILE.VALUE('USER_ID');
2935:
2936: BEGIN
2937: IF (l_web_user_id = p_user_id) THEN
2938: return FND_PROFILE.VALUE(NAME => p_name);
2939: ELSE
2940: return FND_PROFILE.VALUE_SPECIFIC(NAME => p_name,
2941: USER_ID => p_user_id,
2942: RESPONSIBILITY_ID => p_resp_id,

Line 2940: return FND_PROFILE.VALUE_SPECIFIC(NAME => p_name,

2936: BEGIN
2937: IF (l_web_user_id = p_user_id) THEN
2938: return FND_PROFILE.VALUE(NAME => p_name);
2939: ELSE
2940: return FND_PROFILE.VALUE_SPECIFIC(NAME => p_name,
2941: USER_ID => p_user_id,
2942: RESPONSIBILITY_ID => p_resp_id,
2943: APPLICATION_ID => p_apps_id);
2944: END IF;