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 FND_PROFILE

Line 186: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);

182: -- only. For setup time, we use 'GLOBAL' as a grantee, and if a pricing
183: -- entity is granted to 'GLOBAL' with a specific function, it becomes
184: -- globally accessed with such function.
185:
186: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);
187: IF(l_security_control = G_SECURITY_OFF) THEN /*always return authorized*/
188: RETURN G_AUTHORIZED;
189: ELSE /*security is on*/
190: IF(( p_function_name is NULL) or (p_instance_type is NULL)

Line 217: l_org_id := FND_PROFILE.VALUE('ORG_ID');

213:
214: -- Default the operating unit id if not passed in
215: /*
216: IF( p_org_id is NULL) THEN
217: l_org_id := FND_PROFILE.VALUE('ORG_ID');
218: ELSE
219: l_org_id := p_org_id;
220: END IF;
221: */

Line 431: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);

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:
433: IF(l_security_control = G_SECURITY_OFF) THEN
434: /*return all list_headers_id */
435: IF( p_instance_type = G_PRICELIST_OBJECT) THEN

Line 526: l_org_id := to_number(FND_PROFILE.VALUE('ORG_ID'));

522:
523: -- Default the operating unit id if not passed in
524: /*
525: IF( p_org_id is NULL) THEN
526: l_org_id := to_number(FND_PROFILE.VALUE('ORG_ID'));
527: ELSE
528: l_org_id := p_org_id;
529: END IF;
530: */

Line 759: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);

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
761: /*security is off, do nothing*/
762: l_security_default_viewonly := G_SECURITY_LEVEL_NONE;
763: l_security_default_maintain := G_SECURITY_LEVEL_NONE;

Line 765: l_security_default_viewonly := nvl(FND_PROFILE.value(G_SECURITY_DEFAULT_VIEWONLY), G_SECURITY_LEVEL_GLOBAL);

761: /*security is off, do nothing*/
762: l_security_default_viewonly := G_SECURITY_LEVEL_NONE;
763: l_security_default_maintain := G_SECURITY_LEVEL_NONE;
764: ELSE/*security is on*/
765: l_security_default_viewonly := nvl(FND_PROFILE.value(G_SECURITY_DEFAULT_VIEWONLY), G_SECURITY_LEVEL_GLOBAL);
766: l_security_default_maintain := nvl(FND_PROFILE.value(G_SECURITY_DEFAULT_MAINTAIN), G_SECURITY_LEVEL_GLOBAL);
767: END IF;
768:
769: --in case l_security_default_viewonly == l_security_default_maintain,

Line 766: l_security_default_maintain := nvl(FND_PROFILE.value(G_SECURITY_DEFAULT_MAINTAIN), G_SECURITY_LEVEL_GLOBAL);

762: l_security_default_viewonly := G_SECURITY_LEVEL_NONE;
763: l_security_default_maintain := G_SECURITY_LEVEL_NONE;
764: ELSE/*security is on*/
765: l_security_default_viewonly := nvl(FND_PROFILE.value(G_SECURITY_DEFAULT_VIEWONLY), G_SECURITY_LEVEL_GLOBAL);
766: l_security_default_maintain := nvl(FND_PROFILE.value(G_SECURITY_DEFAULT_MAINTAIN), G_SECURITY_LEVEL_GLOBAL);
767: END IF;
768:
769: --in case l_security_default_viewonly == l_security_default_maintain,
770: -- we only take l_security_default_maintain privilege

Line 779: --l_grantee_id :=nvl(p_org_id, FND_PROFILE.VALUE('ORG_ID'));

775: l_grantee_type := 'GLOBAL';
776: l_grantee_id := -1;
777: ELSIF(l_security_default_viewonly = G_SECURITY_LEVEL_OU) THEN
778: l_grantee_type := 'OU';
779: --l_grantee_id :=nvl(p_org_id, FND_PROFILE.VALUE('ORG_ID'));
780: --added for MOAC
781: l_grantee_id := nvl(p_org_id, QP_UTIL.get_org_id);
782: ELSIF(l_security_default_viewonly = G_SECURITY_LEVEL_RESP) THEN
783: l_grantee_type := 'RESP';

Line 869: --l_grantee_id :=nvl(p_org_id, FND_PROFILE.VALUE('ORG_ID'));

865: l_grantee_type := 'GLOBAL';
866: l_grantee_id := -1;
867: ELSIF(l_security_default_maintain = G_SECURITY_LEVEL_OU) THEN
868: l_grantee_type := 'OU';
869: --l_grantee_id :=nvl(p_org_id, FND_PROFILE.VALUE('ORG_ID'));
870: --added for MOAC
871: l_grantee_id := nvl(p_org_id, QP_UTIL.get_org_id);
872: ELSIF(l_security_default_maintain = G_SECURITY_LEVEL_RESP) THEN
873: l_grantee_type := 'RESP';

Line 962: nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);

958: RETURN VARCHAR2 IS
959: l_security_control varchar2(5);
960: BEGIN
961: l_security_control :=
962: nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);
963: IF(l_security_control = G_SECURITY_OFF) THEN
964: RETURN 'N';
965: ELSE
966: RETURN 'Y';

Line 990: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);

986: l_return_status varchar2(1);
987: l_user_name varchar2(80);
988: l_security_control varchar2(5);
989: BEGIN
990: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);
991: IF(l_security_control = G_SECURITY_OFF) THEN /*always return authorized*/
992: RETURN '(1=1)';
993: ELSE /*security is on*/
994: FND_DATA_SECURITY.get_security_predicate(

Line 1028: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);

1024: l_return_status varchar2(1);
1025: l_user_name varchar2(80);
1026: l_security_control varchar2(5);
1027: BEGIN
1028: l_security_control := nvl(FND_PROFILE.value(G_SECURITY_CONTROL_PROFILE), G_SECURITY_OFF);
1029: IF(l_security_control = G_SECURITY_OFF) THEN /*always return authorized*/
1030: RETURN '(1=1)';
1031: ELSE /*security is on*/
1032: FND_DATA_SECURITY.get_security_predicate(

Line 1075: --G_ORG_ID := FND_PROFILE.VALUE ('ORG_ID');

1071: RETURN NUMBER IS
1072: BEGIN
1073: If G_ORG_ID Is NULL
1074: Then
1075: --G_ORG_ID := FND_PROFILE.VALUE ('ORG_ID');
1076: --added for MOAC
1077: G_ORG_ID := QP_UTIL.get_org_id;
1078: End If;
1079:

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: