APPS.PA_CI_SECURITY_PKG dependencies on PA_CONTROL_ITEMS_UTILS

Line 27: G_party_id := pa_control_items_utils.getPartyId(p_user_id);

23: BEGIN
24: IF G_user_id <> p_user_id THEN
25: G_user_id := p_user_id;
26: G_resp_id := p_resp_id;
27: G_party_id := pa_control_items_utils.getPartyId(p_user_id);
28: G_proj_auth_tab.DELETE;
29: G_view_proj_i_tab.DELETE;
30: G_view_proj_cr_tab.DELETE;
31: G_view_proj_co_tab.DELETE;

Line 94: G_party_id := pa_control_items_utils.getPartyId(p_user_id);

90: BEGIN
91: IF G_user_id <> p_user_id THEN
92: G_user_id := p_user_id;
93: G_resp_id := p_resp_id;
94: G_party_id := pa_control_items_utils.getPartyId(p_user_id);
95: G_proj_auth_tab.DELETE;
96: G_view_proj_i_tab.DELETE;
97: G_view_proj_cr_tab.DELETE;
98: G_view_proj_co_tab.DELETE;

Line 155: G_party_id := pa_control_items_utils.getPartyId(p_user_id);

151: --mthai_debug_msg('a('||p_project_id||', '||p_user_id||', '||p_resp_id||')');
152: IF G_user_id <> p_user_id THEN
153: G_user_id := p_user_id;
154: G_resp_id := p_resp_id;
155: G_party_id := pa_control_items_utils.getPartyId(p_user_id);
156: G_proj_auth_tab.DELETE;
157: G_view_proj_i_tab.DELETE;
158: G_view_proj_cr_tab.DELETE;
159: G_view_proj_co_tab.DELETE;

Line 197: G_party_id := pa_control_items_utils.getPartyId(p_user_id);

193: --Clearing cache if user_id is changed
194: IF G_user_id <> p_user_id THEN
195: G_user_id := p_user_id;
196: G_resp_id := -999;
197: G_party_id := pa_control_items_utils.getPartyId(p_user_id);
198: G_proj_auth_tab.DELETE;
199: G_view_proj_i_tab.DELETE;
200: G_view_proj_cr_tab.DELETE;
201: G_view_proj_co_tab.DELETE;

Line 349: -- AND a.assigned_to = pa_control_items_utils.getPartyId(p_user_id)

345: AND s.project_status_code = a.status_code
346: AND s.status_type = 'CI_ACTION'
347: AND s.project_system_status_code = 'CI_ACTION_OPEN'
348: AND a.type_code = 'UPDATE'
349: -- AND a.assigned_to = pa_control_items_utils.getPartyId(p_user_id)
350: AND a.assigned_to = G_party_id
351: AND ROWNUM = 1;
352:
353: RETURN 'T';

Line 410: -- AND a.assigned_to = pa_control_items_utils.getPartyId(p_user_id)

406: AND s.project_status_code = a.status_code
407: AND s.status_type = 'CI_ACTION'
408: AND s.project_system_status_code = 'CI_ACTION_OPEN'
409: AND a.type_code = 'UPDATE'
410: -- AND a.assigned_to = pa_control_items_utils.getPartyId(p_user_id)
411: AND a.assigned_to = G_party_id
412: AND ROWNUM = 1;
413:
414: RETURN 'T';

Line 527: l_party_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(p_user_id);

523: and s.project_system_status_code = 'CI_ACTION_OPEN';
524:
525: BEGIN
526:
527: l_party_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(p_user_id);
528:
529: if(l_party_id IS NULL) then
530: return 'F';
531: end if;

Line 536: l_status_result := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed(null,null,'CONTROL_ITEM_ALLOW_ACTION', p_ci_id);

532:
533: --Bug 5676037. Added the if condition to identify the AMG context. From AMG context
534: -- CheckCIActionAllowed should not be called.
535: if(p_calling_context <> 'AMG') then
536: l_status_result := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed(null,null,'CONTROL_ITEM_ALLOW_ACTION', p_ci_id);
537: if (l_status_result = 'N') then
538: return 'F';
539: end if;
540: end if;-- if(p_calling_context <> 'AMG') then

Line 622: l_party_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(p_user_id);

618: AND s.status_type = 'CI_ACTION'
619: and s.project_system_status_code = 'CI_ACTION_OPEN';
620:
621: BEGIN
622: l_party_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(p_user_id);
623:
624: if(l_party_id IS NULL) then
625: return 'F';
626: end if;

Line 695: G_party_id := pa_control_items_utils.getPartyId(p_user_id);

691: BEGIN
692: IF G_user_id<>p_user_id OR G_resp_id<>p_resp_id THEN
693: G_user_id := p_user_id;
694: G_resp_id := p_resp_id;
695: G_party_id := pa_control_items_utils.getPartyId(p_user_id);
696: G_project_id := p_project_id;
697: G_proj_auth_tab.DELETE;
698: G_view_proj_i_tab.DELETE;
699: G_view_proj_cr_tab.DELETE;