APPS.CS_KB_SECURITY_PVT dependencies on FND_PROFILE

Line 2699: WHERE Category_Group_id = fnd_profile.value('CS_KB_ASSIGNED_CATEGORY_GROUP')

2695:
2696: CURSOR GET_CATEGORY_GROUP IS
2697: SELECT Category_Group_Id
2698: FROM CS_KB_CATEGORY_GROUPS_B
2699: WHERE Category_Group_id = fnd_profile.value('CS_KB_ASSIGNED_CATEGORY_GROUP')
2700: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
2701: AND nvl(End_Date_Active, sysdate+1);
2702:
2703: id NUMBER ;

Line 2740: WHERE VISIBILITY_ID = fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')

2736:
2737: CURSOR GET_POSITION IS
2738: SELECT Position
2739: FROM CS_KB_VISIBILITIES_B
2740: WHERE VISIBILITY_ID = fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
2741: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
2742: AND nvl(End_Date_Active, sysdate+1);
2743:
2744: id number;

Line 2782: AND lookup_code = fnd_profile.value('CS_KB_ASSIGNED_STATEMENT_VISIBILITY_LEVEL')

2778: CURSOR GET_STMT_VISIBILITY IS
2779: SELECT lookup_code
2780: FROM cs_lookups
2781: WHERE lookup_type = 'CS_KB_ACCESS_LEVEL'
2782: AND lookup_code = fnd_profile.value('CS_KB_ASSIGNED_STATEMENT_VISIBILITY_LEVEL')
2783: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
2784: AND nvl(End_Date_Active, sysdate+1);
2785:
2786: id number;

Line 2946: SELECT TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_CATEGORY_GROUP',

2942: AND rg.responsibility_id = decode(P_USER_ID, -1, FND_GLOBAL.RESP_ID, rg.responsibility_id)
2943: AND sysdate between nvl(rg.start_date, sysdate) and nvl(rg.end_date, sysdate);
2944:
2945: CURSOR GET_USER_SECURITY_PROFILES (v_user NUMBER, v_resp NUMBER, v_app NUMBER) IS
2946: SELECT TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_CATEGORY_GROUP',
2947: v_user,
2948: v_resp,
2949: v_app ) ),
2950: TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL',

Line 2950: TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL',

2946: SELECT TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_CATEGORY_GROUP',
2947: v_user,
2948: v_resp,
2949: v_app ) ),
2950: TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL',
2951: v_user,
2952: v_resp,
2953: v_app ) ),
2954: TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_STATEMENT_VISIBILITY_LEVEL',

Line 2954: TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_STATEMENT_VISIBILITY_LEVEL',

2950: TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL',
2951: v_user,
2952: v_resp,
2953: v_app ) ),
2954: TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_STATEMENT_VISIBILITY_LEVEL',
2955: v_user,
2956: v_resp,
2957: v_app ))
2958: FROM dual;