DBA Data[Home] [Help]

APPS.PA_CI_IMPACTS_UTIL dependencies on PA_CONTROL_ITEMS_UTILS

Line 564: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT') from dual;

560: /*
561: CURSOR is_implement_ok
562: IS
563: SELECT
564: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT') from dual;
565:
566: CURSOR is_update_ok
567: IS
568: SELECT

Line 569: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE') from dual;

565:
566: CURSOR is_update_ok
567: IS
568: SELECT
569: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE') from dual;
570: */
571:
572: BEGIN
573:

Line 583: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');

579: OPEN is_update_ok;
580: FETCH is_update_ok INTO l_ret;
581: CLOSE is_update_ok;
582: */
583: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');
584:
585: IF l_ret <>'Y' THEN
586: -- need to check whether we can implement it
587: IF l_type_class = 'CHANGE_ORDER' OR l_type_class = 'CHANGE_REQUEST' then

Line 593: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');

589: FETCH is_implement_ok INTO l_ret;
590: CLOSE is_implement_ok;
591: */
592:
593: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');
594:
595: IF l_ret2 <> 'Y' THEN
596: RETURN 'NONE';
597: END IF;

Line 661: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');

657: OPEN get_ci_info;
658: FETCH get_ci_info INTO l_status_code, l_type_class;
659: CLOSE get_ci_info;
660:
661: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');
662:
663: IF l_ret = 'Y' THEN
664: l_ret2 := pa_ci_security_pkg.check_update_access(p_ci_id);
665: IF l_ret2 = 'T' THEN /* Bug#3815040: Modified the variable l_ret to l_ret2 */

Line 710: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');

706: FETCH get_ci_info INTO l_status_code, l_type_class;
707: CLOSE get_ci_info;
708:
709: IF l_type_class = 'CHANGE_ORDER' OR l_type_class = 'CHANGE_REQUEST' THEN
710: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');
711:
712: IF l_ret2 <> 'Y' THEN
713: RETURN 'NONE';
714: END IF;

Line 755: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');

751:
752: BEGIN
753:
754: l_status_code := p_status_code;
755: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');
756:
757: IF l_ret = 'Y' THEN
758: l_ret2 := pa_ci_security_pkg.check_update_access(p_ci_id);
759: IF l_ret2 = 'T' THEN /* Bug#3815040: Modified the variable l_ret to l_ret2 */

Line 797: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');

793: l_status_code := p_status_code;
794: l_type_class := p_type_class;
795:
796: IF l_type_class = 'CHANGE_ORDER' OR l_type_class = 'CHANGE_REQUEST' THEN
797: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');
798:
799: IF l_ret2 <> 'Y' THEN
800: RETURN 'NONE';
801: END IF;