eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KB_SECURITY_PVT dependencies on FND_GLOBAL

Line 148: l_current_user NUMBER := FND_GLOBAL.user_id;

144: ) IS
145:
146: l_check NUMBER := 0;
147: l_current_position NUMBER;
148: l_current_user NUMBER := FND_GLOBAL.user_id;
149: l_date DATE := SYSDATE;
150: l_login NUMBER := FND_GLOBAL.login_id;
151: l_new_position NUMBER;
152: l_position NUMBER;

Line 150: l_login NUMBER := FND_GLOBAL.login_id;

146: l_check NUMBER := 0;
147: l_current_position NUMBER;
148: l_current_user NUMBER := FND_GLOBAL.user_id;
149: l_date DATE := SYSDATE;
150: l_login NUMBER := FND_GLOBAL.login_id;
151: l_new_position NUMBER;
152: l_position NUMBER;
153: l_position_check NUMBER :=0;
154: l_rowid VARCHAR2(30) := null;

Line 466: l_current_user NUMBER := FND_GLOBAL.user_id;

462: X_MSG_COUNT OUT NOCOPY NUMBER
463: ) IS
464:
465: l_check NUMBER := 0;
466: l_current_user NUMBER := FND_GLOBAL.user_id;
467: l_date DATE := SYSDATE;
468: l_login NUMBER := FND_GLOBAL.login_id;
469:
470: CURSOR Check_Update (v_vis_id NUMBER,

Line 468: l_login NUMBER := FND_GLOBAL.login_id;

464:
465: l_check NUMBER := 0;
466: l_current_user NUMBER := FND_GLOBAL.user_id;
467: l_date DATE := SYSDATE;
468: l_login NUMBER := FND_GLOBAL.login_id;
469:
470: CURSOR Check_Update (v_vis_id NUMBER,
471: v_name VARCHAR2,
472: v_desc VARCHAR2 ) IS

Line 678: l_current_user NUMBER := FND_GLOBAL.user_id;

674: l_vis_count NUMBER;
675: l_position NUMBER;
676: l_request_id NUMBER;
677: l_return_status VARCHAR2(1);
678: l_current_user NUMBER := FND_GLOBAL.user_id;
679:
680: BEGIN
681: SAVEPOINT Delete_Visibility_PVT;
682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 715: Last_updated_By = FND_GLOBAL.User_id

711: -- We will nolonger Delete the Visibility - We will End Date it instead
712: UPDATE CS_KB_VISIBILITIES_B
713: SET End_Date_Active = sysdate - 0.001,
714: Last_Update_date = sysdate,
715: Last_updated_By = FND_GLOBAL.User_id
716: WHERE Visibility_Id = P_VISIBILITY_ID;
717: --dbms_output.put_line('before vis count = '||l_vis_count);
718: OPEN CHECK_VISIBILITY;
719: FETCH CHECK_VISIBILITY INTO l_vis_count;

Line 933: l_current_user NUMBER := FND_GLOBAL.user_id;

929: X_MSG_COUNT OUT NOCOPY NUMBER
930: ) IS
931:
932: l_check NUMBER;
933: l_current_user NUMBER := FND_GLOBAL.user_id;
934: l_date DATE := SYSDATE;
935: l_login NUMBER := FND_GLOBAL.login_id;
936: l_rowid VARCHAR2(30) := null;
937: l_seq NUMBER;

Line 935: l_login NUMBER := FND_GLOBAL.login_id;

931:
932: l_check NUMBER;
933: l_current_user NUMBER := FND_GLOBAL.user_id;
934: l_date DATE := SYSDATE;
935: l_login NUMBER := FND_GLOBAL.login_id;
936: l_rowid VARCHAR2(30) := null;
937: l_seq NUMBER;
938:
939: CURSOR Check_Insert (v_cg_id NUMBER) IS

Line 1133: l_current_user NUMBER := FND_GLOBAL.user_id;

1129: X_MSG_COUNT OUT NOCOPY NUMBER
1130: ) IS
1131:
1132: l_check NUMBER;
1133: l_current_user NUMBER := FND_GLOBAL.user_id;
1134: l_date DATE := SYSDATE;
1135: l_login NUMBER := FND_GLOBAL.login_id;
1136:
1137: CURSOR Check_Update IS

Line 1135: l_login NUMBER := FND_GLOBAL.login_id;

1131:
1132: l_check NUMBER;
1133: l_current_user NUMBER := FND_GLOBAL.user_id;
1134: l_date DATE := SYSDATE;
1135: l_login NUMBER := FND_GLOBAL.login_id;
1136:
1137: CURSOR Check_Update IS
1138: SELECT COUNT(*)
1139: FROM CS_KB_CATEGORY_GROUPS_VL

Line 1313: l_current_user NUMBER := FND_GLOBAL.user_id;

1309: SELECT count(*)
1310: FROM CS_KB_CAT_GROUP_FLOWS
1311: WHERE category_group_id = P_CATEGORY_GROUP_ID;
1312:
1313: l_current_user NUMBER := FND_GLOBAL.user_id;
1314: l_member_count NUMBER;
1315: l_flow_count NUMBER;
1316: l_valid NUMBER;
1317:

Line 1576: l_current_user NUMBER := FND_GLOBAL.user_id;

1572: X_MSG_COUNT OUT NOCOPY NUMBER
1573: ) IS
1574:
1575: l_check NUMBER;
1576: l_current_user NUMBER := FND_GLOBAL.user_id;
1577: l_date DATE := SYSDATE;
1578: l_login NUMBER := FND_GLOBAL.login_id;
1579: l_rowid VARCHAR2(30) := null;
1580: l_valid_cg NUMBER;

Line 1578: l_login NUMBER := FND_GLOBAL.login_id;

1574:
1575: l_check NUMBER;
1576: l_current_user NUMBER := FND_GLOBAL.user_id;
1577: l_date DATE := SYSDATE;
1578: l_login NUMBER := FND_GLOBAL.login_id;
1579: l_rowid VARCHAR2(30) := null;
1580: l_valid_cg NUMBER;
1581: l_valid_cat NUMBER;
1582: l_request_id NUMBER;

Line 1828: l_current_user NUMBER := FND_GLOBAL.user_id;

1824: WHERE category_group_id = P_CATEGORY_GROUP_ID
1825: AND category_id = P_CATEGORY_ID;
1826:
1827:
1828: l_current_user NUMBER := FND_GLOBAL.user_id;
1829: l_valid NUMBER;
1830: l_request_id NUMBER;
1831: l_return_status VARCHAR2(1);
1832:

Line 2010: l_current_user NUMBER := FND_GLOBAL.user_id;

2006: child_cat_id_list NumTabType;
2007: vis_id_list NumTabType;
2008: position_list NumTabType;
2009:
2010: l_current_user NUMBER := FND_GLOBAL.user_id;
2011: l_date DATE := SYSDATE;
2012: l_login NUMBER := FND_GLOBAL.login_id;
2013:
2014: BEGIN

Line 2012: l_login NUMBER := FND_GLOBAL.login_id;

2008: position_list NumTabType;
2009:
2010: l_current_user NUMBER := FND_GLOBAL.user_id;
2011: l_date DATE := SYSDATE;
2012: l_login NUMBER := FND_GLOBAL.login_id;
2013:
2014: BEGIN
2015: OPEN GET_CHILD_CATEGORIES;
2016: FETCH GET_CHILD_CATEGORIES BULK COLLECT INTO child_cat_id_list, vis_id_list, position_list;

Line 2168: l_current_user NUMBER := FND_GLOBAL.user_id;

2164: cat_grp_id_list NumTabType;
2165:
2166: l_cat_valid NUMBER;
2167: l_position NUMBER;
2168: l_current_user NUMBER := FND_GLOBAL.user_id;
2169: l_date DATE := SYSDATE;
2170: l_login NUMBER := FND_GLOBAL.login_id;
2171:
2172: BEGIN

Line 2170: l_login NUMBER := FND_GLOBAL.login_id;

2166: l_cat_valid NUMBER;
2167: l_position NUMBER;
2168: l_current_user NUMBER := FND_GLOBAL.user_id;
2169: l_date DATE := SYSDATE;
2170: l_login NUMBER := FND_GLOBAL.login_id;
2171:
2172: BEGIN
2173: SAVEPOINT Add_Cat_To_Denorm_PVT;
2174: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 2308: l_current_user NUMBER := FND_GLOBAL.user_id;

2304: l_cat_id NUMBER;
2305: l_vis_id NUMBER;
2306: l_position NUMBER;
2307:
2308: l_current_user NUMBER := FND_GLOBAL.user_id;
2309: l_date DATE := SYSDATE;
2310: l_login NUMBER := FND_GLOBAL.login_id;
2311:
2312: BEGIN

Line 2310: l_login NUMBER := FND_GLOBAL.login_id;

2306: l_position NUMBER;
2307:
2308: l_current_user NUMBER := FND_GLOBAL.user_id;
2309: l_date DATE := SYSDATE;
2310: l_login NUMBER := FND_GLOBAL.login_id;
2311:
2312: BEGIN
2313: SAVEPOINT Upd_Cat_To_Denorm_PVT;
2314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 2517: l_current_user NUMBER := FND_GLOBAL.user_id;

2513: vis_id_list NumTabType;
2514: position_list NumTabType;
2515:
2516:
2517: l_current_user NUMBER := FND_GLOBAL.user_id;
2518: l_date DATE := SYSDATE;
2519: l_login NUMBER := FND_GLOBAL.login_id;
2520:
2521: -- l_count NUMBER :=0;

Line 2519: l_login NUMBER := FND_GLOBAL.login_id;

2515:
2516:
2517: l_current_user NUMBER := FND_GLOBAL.user_id;
2518: l_date DATE := SYSDATE;
2519: l_login NUMBER := FND_GLOBAL.login_id;
2520:
2521: -- l_count NUMBER :=0;
2522: l_return VARCHAR2(10) := 'TRUE';
2523:

Line 2604: l_current_user NUMBER := FND_GLOBAL.user_id;

2600: vis_id_list NumTabType;
2601: position_list NumTabType;
2602: child_grp_id_list NumTabType;
2603:
2604: l_current_user NUMBER := FND_GLOBAL.user_id;
2605: l_date DATE := SYSDATE;
2606: l_login NUMBER := FND_GLOBAL.login_id;
2607:
2608: -- l_count NUMBER :=0;

Line 2606: l_login NUMBER := FND_GLOBAL.login_id;

2602: child_grp_id_list NumTabType;
2603:
2604: l_current_user NUMBER := FND_GLOBAL.user_id;
2605: l_date DATE := SYSDATE;
2606: l_login NUMBER := FND_GLOBAL.login_id;
2607:
2608: -- l_count NUMBER :=0;
2609: l_return VARCHAR2(10) := 'TRUE';
2610:

Line 2928: -- Responsibility retrieved from FND_GLOBAL

2924: -- --> The users Statement Visibility allows access to all of the Solutions
2925: -- Statements
2926: --
2927: -- 2) If P_USER_ID is passed as -1 then the api will use the current User and
2928: -- Responsibility retrieved from FND_GLOBAL
2929: -- Used By:
2930: -- 1) Sending WF Notifications --> CS_KB_WF_PKG.Start_wf_processing
2931: -- 2) Check-Out button Logic on View Solution -->
2932: -- End of comments

Line 2940: WHERE u.user_id = decode(P_USER_ID, -1, FND_GLOBAL.USER_ID, P_USER_ID)

2936: CURSOR GET_USER_RESPONSIBILITIES IS
2937: SELECT u.User_id, rg.responsibility_id, rg.responsibility_application_id
2938: FROM fnd_user_resp_groups rg,
2939: fnd_user u
2940: WHERE u.user_id = decode(P_USER_ID, -1, FND_GLOBAL.USER_ID, P_USER_ID)
2941: AND u.user_id = rg.user_id
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:

Line 2942: AND rg.responsibility_id = decode(P_USER_ID, -1, FND_GLOBAL.RESP_ID, rg.responsibility_id)

2938: FROM fnd_user_resp_groups rg,
2939: fnd_user u
2940: WHERE u.user_id = decode(P_USER_ID, -1, FND_GLOBAL.USER_ID, P_USER_ID)
2941: AND u.user_id = rg.user_id
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',