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 223: pa_control_items sourceCi,

219: CURSOR get_impact_info
220: IS
221: SELECT sourceImpacts.*
222: FROM pa_ci_impacts sourceImpacts,
223: pa_control_items sourceCi,
224: pa_control_items targetCi
225: WHERE sourceImpacts.ci_id = p_source_ci_id
226: and sourceImpacts.impact_type_code in ('FINPLAN', 'FINPLAN_REVENUE')
227: and sourceImpacts.ci_id = sourceCi.ci_id

Line 224: pa_control_items targetCi

220: IS
221: SELECT sourceImpacts.*
222: FROM pa_ci_impacts sourceImpacts,
223: pa_control_items sourceCi,
224: pa_control_items targetCi
225: WHERE sourceImpacts.ci_id = p_source_ci_id
226: and sourceImpacts.impact_type_code in ('FINPLAN', 'FINPLAN_REVENUE')
227: and sourceImpacts.ci_id = sourceCi.ci_id
228: and targetCi.ci_id = p_dest_ci_id

Line 252: pa_control_items pci2,

248: and pci.impact_type_code <> 'SUPPLIER'
249: and not exists
250: (
251: select * from
252: pa_control_items pci2,
253: pa_ci_impact_type_usage pcit
254: where pci2.ci_type_id = pcit.ci_type_id
255: AND pci2.ci_id = p_dest_ci_id
256: and pcit.impact_type_code = pci.impact_type_code

Line 261: select project_id from pa_control_items pci

257: )
258: );
259:
260: CURSOR get_project_id is
261: select project_id from pa_control_items pci
262: where
263: pci.ci_id = p_dest_ci_id;
264:
265: CURSOR get_src_project_id is

Line 266: select project_id from pa_control_items pci

262: where
263: pci.ci_id = p_dest_ci_id;
264:
265: CURSOR get_src_project_id is
266: select project_id from pa_control_items pci
267: where
268: pci.ci_id = p_source_ci_id;
269:
270: l_rowid VARCHAR(100);

Line 555: pctb.ci_type_class_code from pa_control_items pci,

551:
552: CURSOR get_ci_info
553: IS
554: select pci.status_code,
555: pctb.ci_type_class_code from pa_control_items pci,
556: pa_ci_types_b pctb
557: where pci.ci_type_id = pctb.ci_type_id
558: AND pci.ci_id = p_ci_id;
559:

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

638: l_temp VARCHAR2(10) := 'NONE';
639: l_context VARCHAR2(30);
640:
641:
642: l_status_code pa_control_items.status_code%TYPE;
643: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
644: l_ret VARCHAR2(1);
645: l_ret2 VARCHAR2(1);
646:

Line 651: pctb.ci_type_class_code from pa_control_items pci,

647:
648: CURSOR get_ci_info
649: IS
650: select pci.status_code,
651: pctb.ci_type_class_code from pa_control_items pci,
652: pa_ci_types_b pctb
653: where pci.ci_type_id = pctb.ci_type_id
654: AND pci.ci_id = p_ci_id;
655:

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

686: l_temp VARCHAR2(10) := 'NONE';
687: l_context VARCHAR2(30);
688:
689:
690: l_status_code pa_control_items.status_code%TYPE;
691: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
692: l_ret VARCHAR2(1);
693: l_ret2 VARCHAR2(1);
694:

Line 699: pctb.ci_type_class_code from pa_control_items pci,

695:
696: CURSOR get_ci_info
697: IS
698: select pci.status_code,
699: pctb.ci_type_class_code from pa_control_items pci,
700: pa_ci_types_b pctb
701: where pci.ci_type_id = pctb.ci_type_id
702: AND pci.ci_id = p_ci_id;
703:

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

743: IS
744: l_temp VARCHAR2(10) := 'NONE';
745: l_context VARCHAR2(30);
746:
747: l_status_code pa_control_items.status_code%TYPE;
748: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
749: l_ret VARCHAR2(1);
750: l_ret2 VARCHAR2(1);
751:

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

782: l_temp VARCHAR2(10) := 'NONE';
783: l_context VARCHAR2(30);
784:
785:
786: l_status_code pa_control_items.status_code%TYPE;
787: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
788: l_ret VARCHAR2(1);
789: l_ret2 VARCHAR2(1);
790:

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;