DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on FND_GLOBAL

Line 4: G_responsibility_id NUMBER :=FND_GLOBAL.RESP_ID;

1: package body PA_SECURITY_PVT AS
2: /* $Header: PASECPVB.pls 120.17 2011/09/19 22:12:02 skkoppul ship $ */
3: G_PKG_NAME varchar2(30) :='PA_SECURITY_PVT';
4: G_responsibility_id NUMBER :=FND_GLOBAL.RESP_ID;
5: G_user_id NUMBER:=FND_GLOBAL.USER_ID;
6: G_source_type VARCHAR2(30) := '';
7: G_source_id NUMBER;
8: G_grantee_key VARCHAR2(240) := '';

Line 5: G_user_id NUMBER:=FND_GLOBAL.USER_ID;

1: package body PA_SECURITY_PVT AS
2: /* $Header: PASECPVB.pls 120.17 2011/09/19 22:12:02 skkoppul ship $ */
3: G_PKG_NAME varchar2(30) :='PA_SECURITY_PVT';
4: G_responsibility_id NUMBER :=FND_GLOBAL.RESP_ID;
5: G_user_id NUMBER:=FND_GLOBAL.USER_ID;
6: G_source_type VARCHAR2(30) := '';
7: G_source_id NUMBER;
8: G_grantee_key VARCHAR2(240) := '';
9: G_debug_flag varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 24: G_responsibility_id := FND_GLOBAL.RESP_ID;

20: is
21: l_emp_id NUMBER;
22: l_cust_id NUMBER;
23: BEGIN
24: G_responsibility_id := FND_GLOBAL.RESP_ID;
25: G_user_id := FND_GLOBAL.USER_ID;
26: G_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
27: G_project_roles_ins_set_id := get_instance_set_id(G_project_roles_ins_set_name);
28:

Line 25: G_user_id := FND_GLOBAL.USER_ID;

21: l_emp_id NUMBER;
22: l_cust_id NUMBER;
23: BEGIN
24: G_responsibility_id := FND_GLOBAL.RESP_ID;
25: G_user_id := FND_GLOBAL.USER_ID;
26: G_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
27: G_project_roles_ins_set_id := get_instance_set_id(G_project_roles_ins_set_name);
28:
29: SELECT employee_id, person_party_id -- Bug 4527617. Replaced customer_id with person_party_id.

Line 51: IF G_source_id is null OR (G_user_id is not null and G_user_id<>FND_GLOBAL.USER_ID) THEN

47: FUNCTION get_resource_source_id RETURN NUMBER
48: IS
49: BEGIN
50: --Bug#11778245 - Addition starts
51: IF G_source_id is null OR (G_user_id is not null and G_user_id<>FND_GLOBAL.USER_ID) THEN
52: Init_global;
53: END IF;
54: --Bug#11778245 - Addition end
55: RETURN G_source_id;

Line 62: IF G_source_type_id is null OR (G_user_id is not null and G_user_id<>FND_GLOBAL.USER_ID) THEN

58: FUNCTION get_resource_type_id RETURN NUMBER
59: IS
60: BEGIN
61: --Bug#11778245 - Addition starts
62: IF G_source_type_id is null OR (G_user_id is not null and G_user_id<>FND_GLOBAL.USER_ID) THEN
63: Init_global;
64: END IF;
65: --Bug#11778245 - Addition end
66: RETURN G_source_type_id;

Line 77: p_source_id IN NUMBER DEFAULT FND_GLOBAL.USER_ID,

73: END get_project_system_status_code;
74:
75: FUNCTION get_grantee_key(
76: p_source_type IN VARCHAR2 DEFAULT 'USER',
77: p_source_id IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
78: p_HZ_WF_Synch IN VARCHAR2 DEFAULT 'N') -- Modified default value to 'N' for bug 3471913
79: RETURN VARCHAR2 IS
80: l_emp_id NUMBER;
81: l_cust_id NUMBER;

Line 704: fnd_global.resp_appl_id);

700:
701: v_resource_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',
702: G_USER_ID,
703: G_RESPONSIBILITY_ID ,
704: fnd_global.resp_appl_id);
705: IF v_resource_super_user = 'Y' THEN
706:
707: pa_debug.G_err_stage := 'check FND function security';
708:

Line 2746: l_old_resp_id := FND_GLOBAL.RESP_ID;

2742: x_msg_data := null;
2743: x_return_status := fnd_api.g_ret_sts_success;
2744: x_has_access := 'N';
2745:
2746: l_old_resp_id := FND_GLOBAL.RESP_ID;
2747: l_old_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2748: l_user_id := FND_GLOBAL.USER_ID;
2749:
2750: IF G_debug_flag = 'Y' THEN

Line 2747: l_old_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

2743: x_return_status := fnd_api.g_ret_sts_success;
2744: x_has_access := 'N';
2745:
2746: l_old_resp_id := FND_GLOBAL.RESP_ID;
2747: l_old_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2748: l_user_id := FND_GLOBAL.USER_ID;
2749:
2750: IF G_debug_flag = 'Y' THEN
2751: pa_debug.write_file('check_access_exist: ' || 'LOG',' p_privilege '||p_privilege||' l_user_id '||l_user_id);

Line 2748: l_user_id := FND_GLOBAL.USER_ID;

2744: x_has_access := 'N';
2745:
2746: l_old_resp_id := FND_GLOBAL.RESP_ID;
2747: l_old_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2748: l_user_id := FND_GLOBAL.USER_ID;
2749:
2750: IF G_debug_flag = 'Y' THEN
2751: pa_debug.write_file('check_access_exist: ' || 'LOG',' p_privilege '||p_privilege||' l_user_id '||l_user_id);
2752: END IF;

Line 2756: FND_GLOBAL.Apps_Initialize

2752: END IF;
2753: --Get the responsibility that has access to view budget.
2754: FOR user_resp_rec IN user_resp_csr(l_user_id) LOOP
2755:
2756: FND_GLOBAL.Apps_Initialize
2757: ( user_id => l_user_id
2758: , resp_id => user_resp_rec.responsibility_id
2759: , resp_appl_id => user_resp_rec.application_id
2760: );

Line 2794: FND_GLOBAL.Apps_Initialize

2790: pa_debug.write_file('check_access_exist: ' || 'LOG',' x_has_access '||x_has_access);
2791: pa_debug.write_file('check_access_exist: ' || 'LOG',' x_resp_key '||x_resp_key||' x_appl_short_name '||x_appl_short_name);
2792: END IF;
2793:
2794: FND_GLOBAL.Apps_Initialize
2795: ( user_id => l_user_id
2796: , resp_id => l_old_resp_id
2797: , resp_appl_id => l_old_resp_appl_id
2798: );