APPS.PA_CI_SECURITY_PKG dependencies on PA_CONTROL_ITEMS_UTILS

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

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

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

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

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

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

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

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

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

360: AND s.project_status_code = a.status_code
361: AND s.status_type = 'CI_ACTION'
362: AND s.project_system_status_code = 'CI_ACTION_OPEN'
363: AND a.type_code = 'UPDATE'
364: -- AND a.assigned_to = pa_control_items_utils.getPartyId(p_user_id)
365: AND a.assigned_to = G_party_id
366: AND ROWNUM = 1;
367:
368: RETURN 'T';

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

421: AND s.project_status_code = a.status_code
422: AND s.status_type = 'CI_ACTION'
423: AND s.project_system_status_code = 'CI_ACTION_OPEN'
424: AND a.type_code = 'UPDATE'
425: -- AND a.assigned_to = pa_control_items_utils.getPartyId(p_user_id)
426: AND a.assigned_to = G_party_id
427: AND ROWNUM = 1;
428:
429: RETURN 'T';

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

540: and s.project_system_status_code = 'CI_ACTION_OPEN';
541:
542: BEGIN
543:
544: l_party_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(p_user_id);
545:
546: if(l_party_id IS NULL) then
547: return 'F';
548: end if;

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

549:
550: --Bug 5676037. Added the if condition to identify the AMG context. From AMG context
551: -- CheckCIActionAllowed should not be called.
552: if(p_calling_context <> 'AMG') then
553: l_status_result := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed(null,null,'CONTROL_ITEM_ALLOW_ACTION', p_ci_id);
554: if (l_status_result = 'N') then
555: return 'F';
556: end if;
557: end if;-- if(p_calling_context <> 'AMG') then

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

635: AND s.status_type = 'CI_ACTION'
636: and s.project_system_status_code = 'CI_ACTION_OPEN';
637:
638: BEGIN
639: l_party_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(p_user_id);
640:
641: if(l_party_id IS NULL) then
642: return 'F';
643: end if;

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

720:
721: IF G_user_id<>p_user_id OR G_resp_id<>p_resp_id THEN
722: G_user_id := p_user_id;
723: G_resp_id := p_resp_id;
724: G_party_id := pa_control_items_utils.getPartyId(p_user_id);
725: G_project_id := p_project_id;
726: G_proj_auth_tab.DELETE;
727: G_view_proj_i_tab.DELETE;
728: G_view_proj_cr_tab.DELETE;