DBA Data[Home] [Help]

APPS.PA_CI_IMPACTS_UTIL dependencies on PA_CONTROL_ITEMS_UTILS

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

487: /*
488: CURSOR is_implement_ok
489: IS
490: SELECT
491: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT') from dual;
492:
493: CURSOR is_update_ok
494: IS
495: SELECT

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

492:
493: CURSOR is_update_ok
494: IS
495: SELECT
496: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE') from dual;
497: */
498:
499: BEGIN
500:

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

506: OPEN is_update_ok;
507: FETCH is_update_ok INTO l_ret;
508: CLOSE is_update_ok;
509: */
510: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');
511:
512: IF l_ret <>'Y' THEN
513: -- need to check whether we can implement it
514: IF l_type_class = 'CHANGE_ORDER' OR l_type_class = 'CHANGE_REQUEST' then

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

516: FETCH is_implement_ok INTO l_ret;
517: CLOSE is_implement_ok;
518: */
519:
520: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');
521:
522: IF l_ret2 <> 'Y' THEN
523: RETURN 'NONE';
524: END IF;

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

584: OPEN get_ci_info;
585: FETCH get_ci_info INTO l_status_code, l_type_class;
586: CLOSE get_ci_info;
587:
588: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');
589:
590: IF l_ret = 'Y' THEN
591: l_ret2 := pa_ci_security_pkg.check_update_access(p_ci_id);
592: IF l_ret2 = 'T' THEN /* Bug#3815040: Modified the variable l_ret to l_ret2 */

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

633: FETCH get_ci_info INTO l_status_code, l_type_class;
634: CLOSE get_ci_info;
635:
636: IF l_type_class = 'CHANGE_ORDER' OR l_type_class = 'CHANGE_REQUEST' THEN
637: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');
638:
639: IF l_ret2 <> 'Y' THEN
640: RETURN 'NONE';
641: END IF;

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

678:
679: BEGIN
680:
681: l_status_code := p_status_code;
682: l_ret := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE');
683:
684: IF l_ret = 'Y' THEN
685: l_ret2 := pa_ci_security_pkg.check_update_access(p_ci_id);
686: IF l_ret2 = 'T' THEN /* Bug#3815040: Modified the variable l_ret to l_ret2 */

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

720: l_status_code := p_status_code;
721: l_type_class := p_type_class;
722:
723: IF l_type_class = 'CHANGE_ORDER' OR l_type_class = 'CHANGE_REQUEST' THEN
724: l_ret2 := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT');
725:
726: IF l_ret2 <> 'Y' THEN
727: RETURN 'NONE';
728: END IF;