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_SECURITY

Line 1: PACKAGE BODY QP_SECURITY AS

1: PACKAGE BODY QP_SECURITY AS
2: /* $Header: QPXSECUB.pls 120.3.12010000.2 2008/08/29 10:47:21 hmohamme ship $ */
3: G_MENU_MAINTAIN_ID NUMBER := null;
4: FUNCTION GET_OBJECT_ID_FOR_INSTANCE(p_instance_type IN VARCHAR2 default null)
5: RETURN NUMBER IS

Line 424: QP_SECURITY_CONTROL: ON/OFF

420: (g.end_date IS NULL OR g.end_date >= l_sysdate) AND
421: g.start_date <= l_sysdate;
422: BEGIN
423: /* we have three profile for security
424: QP_SECURITY_CONTROL: ON/OFF
425: QP_SECUIRTY_DEFAULT_VIEW: NONE, OU, RESP, USER
426: QP_SECURITY_DEFAULT_UPDATE: NONE, OU, RESP, USER
427: */
428: /* check 'QP_SECURITY_CONTROL' profile to see security is on/off.

Line 426: QP_SECURITY_DEFAULT_UPDATE: NONE, OU, RESP, USER

422: BEGIN
423: /* we have three profile for security
424: QP_SECURITY_CONTROL: ON/OFF
425: QP_SECUIRTY_DEFAULT_VIEW: NONE, OU, RESP, USER
426: QP_SECURITY_DEFAULT_UPDATE: NONE, OU, RESP, USER
427: */
428: /* check 'QP_SECURITY_CONTROL' profile to see security is on/off.
429: In case of 'OFF', return all object ids
430: */

Line 428: /* check 'QP_SECURITY_CONTROL' profile to see security is on/off.

424: QP_SECURITY_CONTROL: ON/OFF
425: QP_SECUIRTY_DEFAULT_VIEW: NONE, OU, RESP, USER
426: QP_SECURITY_DEFAULT_UPDATE: NONE, OU, RESP, USER
427: */
428: /* check 'QP_SECURITY_CONTROL' profile to see security is on/off.
429: In case of 'OFF', return all object ids
430: */
431: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);
432:

Line 738: QP_SECURITY_DEFAULT_UPDATE: GLOBAL, OU, RESP, USER, NONE

734: instance_id = cp_instance_id AND
735: object_id = cp_object_id ;
736: BEGIN
737: /* QP_SECUIRTY_DEFAULT_VIEW: GLOBAL, OU, RESP, USER, NONE
738: QP_SECURITY_DEFAULT_UPDATE: GLOBAL, OU, RESP, USER, NONE
739: */
740: /* validate p_instance_pk1
741: */
742: OPEN list_header_id_exist_cur(p_instance_pk1);

Line 756: /* check 'QP_SECURITY_CONTROL' profile to see security is on/off.

752: END IF; /*else 'AGR'='AGR' || 'PRL'='PRL'. pass validation*/
753: END IF; /*else, new id*/
754: CLOSE list_header_id_exist_cur;
755:
756: /* check 'QP_SECURITY_CONTROL' profile to see security is on/off.
757: In case of 'OFF', return default is GLOBAL MAINTAIN
758: */
759: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);
760: IF(l_security_control = G_SECURITY_OFF) THEN

Line 999: p_user_name => qp_security.g_user_name,

995: p_api_version => 1.0,
996: p_function => 'QP_SECU_VIEW',
997: p_object_name => 'QP_LIST_HEADERS',
998: p_grant_instance_type =>'SET',
999: p_user_name => qp_security.g_user_name,
1000: x_predicate => l_predicate,
1001: x_return_status => l_return_status);
1002:
1003: IF(l_return_status = 'T') THEN

Line 1037: p_user_name => qp_security.g_user_name,

1033: p_api_version => 1.0,
1034: p_function => 'QP_SECU_VIEW',
1035: p_object_name => 'QP_LIST_HEADERS',
1036: p_grant_instance_type =>'SET',
1037: p_user_name => qp_security.g_user_name,
1038: x_predicate => l_predicate,
1039: x_return_status => l_return_status);
1040:
1041: IF(l_return_status = 'T') THEN

Line 1144: if(FND_PROFILE.value('QP_SECURITY_CONTROL') = 'OFF') then

1140: AND g.start_date <= sysdate;
1141:
1142: BEGIN
1143:
1144: if(FND_PROFILE.value('QP_SECURITY_CONTROL') = 'OFF') then
1145: l_result := 'Y';
1146: return l_result;
1147: end if;
1148:

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 1150: qp_SECURITY.get_resp_id ,

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);
1154:

Line 1151: qp_SECURITY.get_org_id ,

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);
1154:
1155: FETCH qp_grants_c INTO l_result;

Line 1152: qp_SECURITY.get_menu_maintain_id,

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);
1154:
1155: FETCH qp_grants_c INTO l_result;
1156: CLOSE qp_grants_c;

Line 1171: p_user_name => qp_SECURITY.g_user_name );

1167: p_instance_pk2_value => null,
1168: p_instance_pk3_value => null,
1169: p_instance_pk4_value => null,
1170: p_instance_pk5_value => null,
1171: p_user_name => qp_SECURITY.g_user_name );
1172: IF(l_result = 'F') THEN
1173: RETURN 'N';
1174: ELSIF(l_result = 'T') THEN
1175: RETURN 'Y';

Line 1258: END QP_SECURITY;

1254: When OTHERS Then
1255: return null;
1256: END QP_ORG_SECURITY;
1257:
1258: END QP_SECURITY;