eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CI_IMPACTS_UTIL dependencies on PA_CONTROL_ITEMS

Line 210: pa_control_items targetCi,

206: CURSOR get_include_impact_info
207: IS
208: SELECT sourceImpacts.*
209: FROM pa_ci_impacts sourceImpacts,
210: pa_control_items targetCi,
211: pa_ci_impact_type_usage targetUsage
212: WHERE sourceImpacts.ci_id = p_source_ci_id
213: AND sourceImpacts.impact_type_code NOT IN ('FINPLAN_COST','FINPLAN_REVENUE','FINPLAN')
214: AND targetCi.ci_id = p_dest_ci_id

Line 238: pa_control_items pci2,

234: and pci.impact_type_code <> 'FINPLAN' /* Bug 3724520 */
235: and not exists
236: (
237: select * from
238: pa_control_items pci2,
239: pa_ci_impact_type_usage pcit
240: where pci2.ci_type_id = pcit.ci_type_id
241: AND pci2.ci_id = p_dest_ci_id
242: and pcit.impact_type_code = pci.impact_type_code

Line 247: select project_id from pa_control_items pci

243: )
244: );
245:
246: CURSOR get_project_id is
247: select project_id from pa_control_items pci
248: where
249: pci.ci_id = p_dest_ci_id;
250:
251: CURSOR get_src_project_id is

Line 252: select project_id from pa_control_items pci

248: where
249: pci.ci_id = p_dest_ci_id;
250:
251: CURSOR get_src_project_id is
252: select project_id from pa_control_items pci
253: where
254: pci.ci_id = p_source_ci_id;
255:
256: l_rowid VARCHAR(100);

Line 482: pctb.ci_type_class_code from pa_control_items pci,

478:
479: CURSOR get_ci_info
480: IS
481: select pci.status_code,
482: pctb.ci_type_class_code from pa_control_items pci,
483: pa_ci_types_b pctb
484: where pci.ci_type_id = pctb.ci_type_id
485: AND pci.ci_id = p_ci_id;
486:

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 569: l_status_code pa_control_items.status_code%TYPE;

565: l_temp VARCHAR2(10) := 'NONE';
566: l_context VARCHAR2(30);
567:
568:
569: l_status_code pa_control_items.status_code%TYPE;
570: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
571: l_ret VARCHAR2(1);
572: l_ret2 VARCHAR2(1);
573:

Line 578: pctb.ci_type_class_code from pa_control_items pci,

574:
575: CURSOR get_ci_info
576: IS
577: select pci.status_code,
578: pctb.ci_type_class_code from pa_control_items pci,
579: pa_ci_types_b pctb
580: where pci.ci_type_id = pctb.ci_type_id
581: AND pci.ci_id = p_ci_id;
582:

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 617: l_status_code pa_control_items.status_code%TYPE;

613: l_temp VARCHAR2(10) := 'NONE';
614: l_context VARCHAR2(30);
615:
616:
617: l_status_code pa_control_items.status_code%TYPE;
618: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
619: l_ret VARCHAR2(1);
620: l_ret2 VARCHAR2(1);
621:

Line 626: pctb.ci_type_class_code from pa_control_items pci,

622:
623: CURSOR get_ci_info
624: IS
625: select pci.status_code,
626: pctb.ci_type_class_code from pa_control_items pci,
627: pa_ci_types_b pctb
628: where pci.ci_type_id = pctb.ci_type_id
629: AND pci.ci_id = p_ci_id;
630:

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 674: l_status_code pa_control_items.status_code%TYPE;

670: IS
671: l_temp VARCHAR2(10) := 'NONE';
672: l_context VARCHAR2(30);
673:
674: l_status_code pa_control_items.status_code%TYPE;
675: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
676: l_ret VARCHAR2(1);
677: l_ret2 VARCHAR2(1);
678:

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 713: l_status_code pa_control_items.status_code%TYPE;

709: l_temp VARCHAR2(10) := 'NONE';
710: l_context VARCHAR2(30);
711:
712:
713: l_status_code pa_control_items.status_code%TYPE;
714: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
715: l_ret VARCHAR2(1);
716: l_ret2 VARCHAR2(1);
717:

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;