53: v_resp_id NUMBER;
54: BEGIN
55:
56: x_return_status := 'S';
57: SELECT fnd_global.resp_id INTO x_resp_id FROM dual;
58: SELECT fnd_global.user_id INTO x_user_id FROM dual;
59:
60: SELECT responsibility_id INTO v_resp_id
61: FROM fnd_responsibility
54: BEGIN
55:
56: x_return_status := 'S';
57: SELECT fnd_global.resp_id INTO x_resp_id FROM dual;
58: SELECT fnd_global.user_id INTO x_user_id FROM dual;
59:
60: SELECT responsibility_id INTO v_resp_id
61: FROM fnd_responsibility
62: WHERE responsibility_key = 'GMD_SECURITY_PROFILE_MGR';