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_GLOBAL

Line 197: l_user_name := FND_GLOBAL.USER_NAME;

193: END IF;
194:
195: -- Default the user name if not passed in
196: IF( p_user_name is NULL) THEN
197: l_user_name := FND_GLOBAL.USER_NAME;
198: ELSE
199: l_user_name := p_user_name;
200: END IF;
201:

Line 208: l_resp_id := FND_GLOBAL.RESP_ID;

204: --GET_ORIG_KEY(l_user_name, l_orig_system, l_orig_system_id);
205:
206: -- Default the responsibility id if not passed in
207: IF( p_resp_id is NULL) THEN
208: l_resp_id := FND_GLOBAL.RESP_ID;
209: ELSE
210: l_resp_id := p_resp_id;
211: END IF;
212: --CHECK_RESP_FOR_USER(l_user_name, l_resp_id);

Line 505: l_user_name := FND_GLOBAL.USER_NAME;

501: END IF;
502:
503: -- Default the user name if not passed in
504: IF( p_user_name is NULL) THEN
505: l_user_name := FND_GLOBAL.USER_NAME;
506: ELSE
507: l_user_name := p_user_name;
508: END IF;
509:

Line 511: --l_user_id := FND_GLOBAL.USER_ID;

507: l_user_name := p_user_name;
508: END IF;
509:
510: l_user_id := GET_USER_ID(l_user_name);
511: --l_user_id := FND_GLOBAL.USER_ID;
512:
513: --GET_ORIG_KEY(l_user_name, l_orig_system, l_orig_system_id);
514:
515: -- Default the responsibility id if not passed in

Line 517: l_resp_id := FND_GLOBAL.RESP_ID;

513: --GET_ORIG_KEY(l_user_name, l_orig_system, l_orig_system_id);
514:
515: -- Default the responsibility id if not passed in
516: IF( p_resp_id is NULL) THEN
517: l_resp_id := FND_GLOBAL.RESP_ID;
518: ELSE
519: l_resp_id := p_resp_id;
520: END IF;
521: --CHECK_RESP_FOR_USER(l_user_name, l_resp_id);

Line 784: l_grantee_id :=nvl(p_resp_id, FND_GLOBAL.RESP_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';
784: l_grantee_id :=nvl(p_resp_id, FND_GLOBAL.RESP_ID);
785: ELSIF(l_security_default_viewonly = G_SECURITY_LEVEL_USER) THEN
786: l_grantee_type := 'USER';
787: l_user_name := nvl(p_user_name, FND_GLOBAL.USER_NAME);
788: l_grantee_id :=GET_USER_ID(l_user_name);

Line 787: l_user_name := nvl(p_user_name, FND_GLOBAL.USER_NAME);

783: l_grantee_type := 'RESP';
784: l_grantee_id :=nvl(p_resp_id, FND_GLOBAL.RESP_ID);
785: ELSIF(l_security_default_viewonly = G_SECURITY_LEVEL_USER) THEN
786: l_grantee_type := 'USER';
787: l_user_name := nvl(p_user_name, FND_GLOBAL.USER_NAME);
788: l_grantee_id :=GET_USER_ID(l_user_name);
789: END IF;
790:
791: /*make sure the wanted privilege is not existing already

Line 799: --l_last_updated_by := GET_USER_ID(nvl(p_user_name, FND_GLOBAL.USER_NAME));

795: l_menu_id := GET_MENU_ID('QP_SECU_VIEWONLY');
796: --l_start_date := sysdate;
797: --l_end_date := null;
798: --l_last_update_date := sysdate;
799: --l_last_updated_by := GET_USER_ID(nvl(p_user_name, FND_GLOBAL.USER_NAME));
800: l_last_updated_by := FND_GLOBAL.USER_ID;
801: --l_creation_date := sysdate;
802: l_created_by := l_last_updated_by;
803: l_last_update_login := FND_GLOBAL.LOGIN_ID ;

Line 800: l_last_updated_by := FND_GLOBAL.USER_ID;

796: --l_start_date := sysdate;
797: --l_end_date := null;
798: --l_last_update_date := sysdate;
799: --l_last_updated_by := GET_USER_ID(nvl(p_user_name, FND_GLOBAL.USER_NAME));
800: l_last_updated_by := FND_GLOBAL.USER_ID;
801: --l_creation_date := sysdate;
802: l_created_by := l_last_updated_by;
803: l_last_update_login := FND_GLOBAL.LOGIN_ID ;
804:

Line 803: l_last_update_login := FND_GLOBAL.LOGIN_ID ;

799: --l_last_updated_by := GET_USER_ID(nvl(p_user_name, FND_GLOBAL.USER_NAME));
800: l_last_updated_by := FND_GLOBAL.USER_ID;
801: --l_creation_date := sysdate;
802: l_created_by := l_last_updated_by;
803: l_last_update_login := FND_GLOBAL.LOGIN_ID ;
804:
805: /*if not existing, insert new*/
806: OPEN grant_exist_cur(l_grantee_type, l_grantee_id,
807: p_instance_type, p_instance_pk1, l_object_id);

Line 874: l_grantee_id :=nvl(p_resp_id, FND_GLOBAL.RESP_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';
874: l_grantee_id :=nvl(p_resp_id, FND_GLOBAL.RESP_ID);
875: ELSIF(l_security_default_maintain = G_SECURITY_LEVEL_USER) THEN
876: l_grantee_type := 'USER';
877: l_user_name := nvl(p_user_name, FND_GLOBAL.USER_NAME);
878: l_grantee_id :=GET_USER_ID(l_user_name);

Line 877: l_user_name := nvl(p_user_name, FND_GLOBAL.USER_NAME);

873: l_grantee_type := 'RESP';
874: l_grantee_id :=nvl(p_resp_id, FND_GLOBAL.RESP_ID);
875: ELSIF(l_security_default_maintain = G_SECURITY_LEVEL_USER) THEN
876: l_grantee_type := 'USER';
877: l_user_name := nvl(p_user_name, FND_GLOBAL.USER_NAME);
878: l_grantee_id :=GET_USER_ID(l_user_name);
879: END IF;
880:
881: l_object_id := GET_OBJECT_ID_FOR_INSTANCE(p_instance_type);

Line 886: --l_last_updated_by := GET_USER_ID(nvl(p_user_name, FND_GLOBAL.USER_NAME));

882: l_menu_id := GET_MENU_ID('QP_SECU_MAINTAIN');
883: --l_start_date := sysdate;
884: l_end_date := null;
885: --l_last_update_date := sysdate;
886: --l_last_updated_by := GET_USER_ID(nvl(p_user_name, FND_GLOBAL.USER_NAME));
887: l_last_updated_by := FND_GLOBAL.USER_ID;
888: --l_creation_date := sysdate;
889: l_created_by := l_last_updated_by;
890: l_last_update_login := FND_GLOBAL.LOGIN_ID ;

Line 887: l_last_updated_by := FND_GLOBAL.USER_ID;

883: --l_start_date := sysdate;
884: l_end_date := null;
885: --l_last_update_date := sysdate;
886: --l_last_updated_by := GET_USER_ID(nvl(p_user_name, FND_GLOBAL.USER_NAME));
887: l_last_updated_by := FND_GLOBAL.USER_ID;
888: --l_creation_date := sysdate;
889: l_created_by := l_last_updated_by;
890: l_last_update_login := FND_GLOBAL.LOGIN_ID ;
891:

Line 890: l_last_update_login := FND_GLOBAL.LOGIN_ID ;

886: --l_last_updated_by := GET_USER_ID(nvl(p_user_name, FND_GLOBAL.USER_NAME));
887: l_last_updated_by := FND_GLOBAL.USER_ID;
888: --l_creation_date := sysdate;
889: l_created_by := l_last_updated_by;
890: l_last_update_login := FND_GLOBAL.LOGIN_ID ;
891:
892: /*if not existing, insert new*/
893: OPEN grant_exist_cur(l_grantee_type, l_grantee_id,
894: p_instance_type, p_instance_pk1, l_object_id);

Line 1064: G_RESP_ID := FND_GLOBAL.RESP_ID;

1060: RETURN NUMBER IS
1061: BEGIN
1062: /* commented for FP 7310389 If G_RESP_ID Is NULL
1063: Then*/
1064: G_RESP_ID := FND_GLOBAL.RESP_ID;
1065: --End If;
1066:
1067: RETURN G_RESP_ID;
1068: END GET_RESP_ID;

Line 1088: G_USER_NAME := FND_GLOBAL.USER_NAME;

1084: RETURN VARCHAR2 IS
1085: BEGIN
1086: If G_USER_NAME Is NULL
1087: Then
1088: G_USER_NAME := FND_GLOBAL.USER_NAME;
1089: End If;
1090:
1091: RETURN G_USER_NAME;
1092: END GET_USER_NAME;