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.QP_SECURITY dependencies on QP_GRANTS

Line 8: v_instance_type qp_grants.instance_type%TYPE; --VARCHAR2(5);

4: FUNCTION GET_OBJECT_ID_FOR_INSTANCE(p_instance_type IN VARCHAR2 default null)
5: RETURN NUMBER IS
6: v_object_id NUMBER := null;
7: v_object_name VARCHAR2(30) := null;
8: v_instance_type qp_grants.instance_type%TYPE; --VARCHAR2(5);
9: BEGIN
10:
11: v_instance_type := nvl(p_instance_type, 'ALL');
12:

Line 42: v_instance_type qp_grants.instance_type%TYPE;--varchar2(10);

38:
39: FUNCTION GET_OBJECT_NAME_FOR_INSTANCE(p_instance_type IN VARCHAR2)
40: RETURN VARCHAR2 IS
41: v_object_name VARCHAR2(30) := null;
42: v_instance_type qp_grants.instance_type%TYPE;--varchar2(10);
43: BEGIN
44: v_instance_type := nvl(p_instance_type, 'ALL');
45:
46: IF(G_PRICELIST_OBJECT = v_instance_type OR

Line 145: CURSOR qp_grants_c ( cp_user_id NUMBER,

141: l_function_id NUMBER;
142: l_object_id NUMBER;
143: error_message VARCHAR2(1000);
144: l_mo_access_mode VARCHAR2(30);
145: CURSOR qp_grants_c ( cp_user_id NUMBER,
146: cp_resp_id NUMBER,
147: cp_org_id NUMBER,
148: cp_function_id NUMBER,
149: cp_object_id NUMBER,

Line 154: FROM qp_grants g

150: cp_instance_id NUMBER,
151: cp_mo_access_mode VARCHAR2
152: ) IS
153: SELECT 'X'
154: FROM qp_grants g
155: WHERE rownum = 1
156: AND g.object_id = cp_object_id
157: AND ( ( g.grantee_type = 'USER' AND
158: g.grantee_id = cp_user_id) OR

Line 233: /* check qp_grants table and see if the fnd_menu_id for the object

229: l_object_name := GET_OBJECT_NAME_FOR_INSTANCE(p_instance_type);
230: -- get function_id from function_name
231: l_function_id := GET_FUNCTION_ID(p_function_name);
232:
233: /* check qp_grants table and see if the fnd_menu_id for the object
234: includes the ask-for function or not
235: if no data found, which means no any access on the object,
236: return DENIED
237: or ask for a function which doesn't be included in the object role,

Line 242: OPEN qp_grants_c(l_user_id,

238: return DENIED;
239: */
240: BEGIN
241: -----------------open cursor here
242: OPEN qp_grants_c(l_user_id,
243: l_resp_id,
244: l_org_id,
245: l_function_id,
246: l_object_id,

Line 249: FETCH qp_grants_c INTO l_result;

245: l_function_id,
246: l_object_id,
247: p_instance_pk1, l_mo_access_mode);
248:
249: FETCH qp_grants_c INTO l_result;
250: CLOSE qp_grants_c;
251:
252: IF ( l_result = 'X') THEN
253: RETURN G_AUTHORIZED;

Line 250: CLOSE qp_grants_c;

246: l_object_id,
247: p_instance_pk1, l_mo_access_mode);
248:
249: FETCH qp_grants_c INTO l_result;
250: CLOSE qp_grants_c;
251:
252: IF ( l_result = 'X') THEN
253: RETURN G_AUTHORIZED;
254: END IF;

Line 380: FROM qp_grants g

376: cp_function_id NUMBER,
377: cp_object_id NUMBER
378: ) IS
379: SELECT g.instance_id
380: FROM qp_grants g
381: WHERE ((g.grantee_type = 'USER' AND
382: g.grantee_id = cp_user_id) OR
383: (g.grantee_type = 'RESP' AND
384: g.grantee_id = cp_resp_id) OR

Line 405: FROM qp_grants g

401: cp_object_id NUMBER,
402: cp_instance_type VARCHAR2
403: ) IS
404: SELECT g.instance_id
405: FROM qp_grants g
406: WHERE ((g.grantee_type = 'USER' AND
407: g.grantee_id = cp_user_id) OR
408: (g.grantee_type = 'RESP' AND
409: g.grantee_id = cp_resp_id) OR

Line 540: /*check qp_grants INSTANCE table to get all list_header_ids which

536: l_object_id := GET_OBJECT_ID_FOR_INSTANCE(p_instance_type);
537: l_object_name := GET_OBJECT_NAME_FOR_INSTANCE(p_instance_type);
538: l_function_id := GET_FUNCTION_ID(p_function_name);
539:
540: /*check qp_grants INSTANCE table to get all list_header_ids which
541: can be accessed with the specific function*/
542: IF ( p_instance_type is null) THEN /*get list_headers_id for all types*/
543: OPEN l_grants_list_headers_id_cur(l_user_id,
544: l_resp_id,

Line 730: FROM qp_grants

726: cp_instance_type varchar2,
727: cp_instance_id number,
728: cp_object_id number) IS
729: SELECT 'X'
730: FROM qp_grants
731: WHERE grantee_type = cp_grantee_type AND
732: grantee_id = cp_grantee_id AND
733: instance_type = cp_instance_type AND
734: instance_id = cp_instance_id AND

Line 810: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;

806: OPEN grant_exist_cur(l_grantee_type, l_grantee_id,
807: p_instance_type, p_instance_pk1, l_object_id);
808: FETCH grant_exist_cur INTO l_dummy;
809: IF(grant_exist_cur%NOTFOUND) THEN
810: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;
811: INSERT INTO qp_grants
812: (GRANT_ID,
813: OBJECT_ID,
814: INSTANCE_TYPE,

Line 811: INSERT INTO qp_grants

807: p_instance_type, p_instance_pk1, l_object_id);
808: FETCH grant_exist_cur INTO l_dummy;
809: IF(grant_exist_cur%NOTFOUND) THEN
810: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;
811: INSERT INTO qp_grants
812: (GRANT_ID,
813: OBJECT_ID,
814: INSTANCE_TYPE,
815: INSTANCE_ID,

Line 842: UPDATE qp_grants

838: sysdate, --l_creation_date,
839: l_created_by,
840: l_last_update_login );
841: ELSE /*update the existing one*/
842: UPDATE qp_grants
843: SET MENU_ID = l_menu_id,
844: START_DATE = sysdate ,
845: END_DATE = null,
846: LAST_UPDATE_DATE = sysdate,

Line 850: FROM qp_grants

846: LAST_UPDATE_DATE = sysdate,
847: LAST_UPDATED_BY = l_created_by,
848: LAST_UPDATE_LOGIN = l_last_update_login
849: WHERE GRANT_ID = (select grant_id
850: FROM qp_grants
851: WHERE grantee_type = l_grantee_type AND
852: grantee_id = l_grantee_id AND
853: instance_type = p_instance_type AND
854: instance_id = p_instance_pk1 AND

Line 897: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;

893: OPEN grant_exist_cur(l_grantee_type, l_grantee_id,
894: p_instance_type, p_instance_pk1, l_object_id);
895: FETCH grant_exist_cur INTO l_dummy;
896: IF(grant_exist_cur%NOTFOUND) THEN
897: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;
898: INSERT INTO qp_grants
899: (GRANT_ID,
900: OBJECT_ID,
901: INSTANCE_TYPE,

Line 898: INSERT INTO qp_grants

894: p_instance_type, p_instance_pk1, l_object_id);
895: FETCH grant_exist_cur INTO l_dummy;
896: IF(grant_exist_cur%NOTFOUND) THEN
897: SELECT QP_GRANTS_S.nextval INTO l_grant_id FROM DUAL;
898: INSERT INTO qp_grants
899: (GRANT_ID,
900: OBJECT_ID,
901: INSTANCE_TYPE,
902: INSTANCE_ID,

Line 929: UPDATE qp_grants

925: sysdate, --l_creation_date,
926: l_created_by,
927: l_last_update_login );
928: ELSE /*update the existing one*/
929: UPDATE qp_grants
930: SET MENU_ID = l_menu_id,
931: START_DATE = sysdate ,
932: END_DATE = null,
933: LAST_UPDATE_DATE = sysdate,

Line 937: FROM qp_grants

933: LAST_UPDATE_DATE = sysdate,
934: LAST_UPDATED_BY = l_created_by,
935: LAST_UPDATE_LOGIN = l_last_update_login
936: WHERE GRANT_ID = (select grant_id
937: FROM qp_grants
938: WHERE grantee_type = l_grantee_type AND
939: grantee_id = l_grantee_id AND
940: instance_type = p_instance_type AND
941: instance_id = p_instance_pk1 AND

Line 1114: CURSOR qp_grants_c ( cp_user_id NUMBER,

1110: FUNCTION GET_UPDATE_ALLOWED (p_object_name IN VARCHAR2, p_list_header_id IN NUMBER)
1111: RETURN VARCHAR2 IS
1112:
1113: l_result VARCHAR2(1);
1114: CURSOR qp_grants_c ( cp_user_id NUMBER,
1115: cp_resp_id NUMBER,
1116: cp_org_id NUMBER,
1117: cp_function_id NUMBER,
1118: cp_instance_id NUMBER

Line 1121: FROM qp_grants g

1117: cp_function_id NUMBER,
1118: cp_instance_id NUMBER
1119: ) IS
1120: SELECT 'X'
1121: FROM qp_grants g
1122: WHERE rownum = 1
1123: AND ( ( g.grantee_type = 'USER' AND
1124: g.grantee_id = cp_user_id) OR
1125: ( g.grantee_type = 'RESP' AND

Line 1149: OPEN qp_grants_c(qp_SECURITY.get_user_id ,

1145: l_result := 'Y';
1146: return l_result;
1147: end if;
1148:
1149: OPEN qp_grants_c(qp_SECURITY.get_user_id ,
1150: qp_SECURITY.get_resp_id ,
1151: qp_SECURITY.get_org_id ,
1152: qp_SECURITY.get_menu_maintain_id,
1153: p_list_header_id);

Line 1155: FETCH qp_grants_c INTO l_result;

1151: qp_SECURITY.get_org_id ,
1152: qp_SECURITY.get_menu_maintain_id,
1153: p_list_header_id);
1154:
1155: FETCH qp_grants_c INTO l_result;
1156: CLOSE qp_grants_c;
1157:
1158: IF ( l_result = 'X') THEN
1159: RETURN 'Y';

Line 1156: CLOSE qp_grants_c;

1152: qp_SECURITY.get_menu_maintain_id,
1153: p_list_header_id);
1154:
1155: FETCH qp_grants_c INTO l_result;
1156: CLOSE qp_grants_c;
1157:
1158: IF ( l_result = 'X') THEN
1159: RETURN 'Y';
1160: END IF;