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_ALLOC_UTILS dependencies on PA_ALLOC_RULES_ALL

Line 61: FROM PA_ALLOC_RULES_ALL PAL /* Bug 4185336 Changed PA_ALLOC_RULES to PA_ALLOC_RULES_ALL */

57: CURSOR C_resource_list IS
58: SELECT '1'
59: FROM dual
60: WHERE EXISTS (SELECT 'Y'
61: FROM PA_ALLOC_RULES_ALL PAL /* Bug 4185336 Changed PA_ALLOC_RULES to PA_ALLOC_RULES_ALL */
62: WHERE PAL.BASIS_RESOURCE_LIST_ID=P_resource_list_id
63: OR PAL.ALLOC_RESOURCE_LIST_ID=P_resource_list_id
64: )
65: OR EXISTS

Line 110: FROM PA_ALLOC_RULES_ALL RULES

106: FROM PA_ALLOC_TXN_DETAILS TXN
107: WHERE TXN.project_id=p_project_id)
108: OR EXISTS
109: (SELECT 'Y'
110: FROM PA_ALLOC_RULES_ALL RULES
111: WHERE RULES.offset_project_id=p_project_id)
112: OR EXISTS
113: (SELECT 'Y'
114: FROM PA_ALLOC_SOURCE_LINES SRCL

Line 171: FROM PA_ALLOC_RULES_ALL RULES

167: ***/
168:
169: CURSOR C_task_in_alloc_rule(x_task_id IN NUMBER) is
170: SELECT 'Y'
171: FROM PA_ALLOC_RULES_ALL RULES
172: WHERE RULES.offset_task_id=x_task_id;
173: /* Commented for bug 8929749
174: CURSOR C_task_in_alloc_src_line(x_task_id IN NUMBER) is
175: SELECT 'Y'

Line 294: FROM PA_ALLOC_RULES_ALL RULES

290: FROM PA_ALLOC_TXN_DETAILS TXN
291: WHERE TXN.task_id=p_task_id)
292: OR EXISTS
293: ( SELECT '1'
294: FROM PA_ALLOC_RULES_ALL RULES
295: WHERE RULES.offset_task_id=p_task_id)
296: OR EXISTS
297: (SELECT '1'
298: FROM PA_ALLOC_TARGET_LINES TGTL

Line 382: FROM PA_ALLOC_RULES_ALL

378: CURSOR C_budget_type_in_allocations is
379: SELECT '1'
380: FROM dual
381: WHERE EXISTS (SELECT 'Y'
382: FROM PA_ALLOC_RULES_ALL
383: WHERE basis_budget_type_code=p_budget_type_code)
384: OR EXISTS
385: (SELECT 'Y'
386: FROM PA_ALLOC_RUNS_ALL

Line 425: FROM PA_ALLOC_RULES_ALL

421: CURSOR C_Bem_in_allocations is
422: SELECT '1'
423: FROM dual
424: WHERE EXISTS (SELECT 'Y'
425: FROM PA_ALLOC_RULES_ALL
426: WHERE basis_budget_entry_method_code=p_bem_code)
427: OR EXISTS
428: (SELECT 'Y'
429: FROM PA_ALLOC_RUNS_ALL

Line 466: /* Checking PA_ALLOC_RULES_ALL */

462: FUNCTION Is_RBS_In_Rules ( P_RBS_ID IN pa_rbs_headers_v.RBS_HEADER_ID%Type ) RETURN VARCHAR2
463: IS
464: l_exists Varchar2(1) := 'N';
465: BEGIN
466: /* Checking PA_ALLOC_RULES_ALL */
467: Begin
468: Select 'Y' into l_exists
469: from pa_alloc_rules_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
470: where

Line 469: from pa_alloc_rules_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */

465: BEGIN
466: /* Checking PA_ALLOC_RULES_ALL */
467: Begin
468: Select 'Y' into l_exists
469: from pa_alloc_rules_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
470: where
471: (
472: ( ALLOC_RESOURCE_STRUCT_TYPE = 'RBS'
473: and

Line 492: from pa_alloc_runs_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */

488: End;
489: /* Checking PA_ALLOC_RUNS_ALL */
490: Begin
491: Select 'Y' into l_exists
492: from pa_alloc_runs_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
493: where (
494: ( ALLOC_RESOURCE_STRUCT_TYPE = 'RBS'
495: and
496: Alloc_resource_list_id = P_RBS_ID

Line 528: From PA_ALLOC_RULES_ALL par, PA_ALLOC_RESOURCES pr

524: l_exists Varchar2(1) := 'N';
525: BEGIN
526: Begin
527: Select 'Y' into l_exists
528: From PA_ALLOC_RULES_ALL par, PA_ALLOC_RESOURCES pr
529: Where par.rule_id = pr.rule_id
530: and pr.RESOURCE_LIST_MEMBER_ID = P_RBS_ELEMENT_ID
531: and decode (pr.member_type , 'S' , par.ALLOC_RESOURCE_STRUCT_TYPE ,
532: 'B' , par.BASIS_RESOURCE_STRUCT_TYPE

Line 585: l_source_res_struct_type pa_alloc_rules_all.ALLOC_RESOURCE_STRUCT_TYPE%type;

581: p_resource_id IN pa_rbs_elements.RBS_ELEMENT_ID%type ,
582: p_rule_id IN pa_alloc_rules.rule_id%type
583: ) Return Varchar2
584: IS
585: l_source_res_struct_type pa_alloc_rules_all.ALLOC_RESOURCE_STRUCT_TYPE%type;
586: l_basis_res_struct_type pa_alloc_rules_all.BASIS_RESOURCE_STRUCT_TYPE%type;
587:
588: x_name varchar2(4000);
589: BEGIN

Line 586: l_basis_res_struct_type pa_alloc_rules_all.BASIS_RESOURCE_STRUCT_TYPE%type;

582: p_rule_id IN pa_alloc_rules.rule_id%type
583: ) Return Varchar2
584: IS
585: l_source_res_struct_type pa_alloc_rules_all.ALLOC_RESOURCE_STRUCT_TYPE%type;
586: l_basis_res_struct_type pa_alloc_rules_all.BASIS_RESOURCE_STRUCT_TYPE%type;
587:
588: x_name varchar2(4000);
589: BEGIN
590: If p_resource_id Is Null Then

Line 597: From pa_alloc_rules_all

593: Select ALLOC_RESOURCE_STRUCT_TYPE ,
594: BASIS_RESOURCE_STRUCT_TYPE
595: Into l_source_res_struct_type ,
596: l_basis_res_struct_type
597: From pa_alloc_rules_all
598: Where Rule_ID = p_Rule_Id;
599: If p_alloc_type In ('SOURCE' , 'S') Then
600: If l_source_res_struct_type = 'RL' Then
601: select prlm.alias

Line 648: CURSOR LV_ALLOC_CUR IS SELECT * FROM PA_ALLOC_RULES_ALL

644: x_return_status OUT NOCOPY VARCHAR2 ,
645: x_error_code OUT NOCOPY VARCHAR2
646: )
647: IS
648: CURSOR LV_ALLOC_CUR IS SELECT * FROM PA_ALLOC_RULES_ALL
649: WHERE alloc_resource_list_id = p_rbs_header_id
650: OR basis_resource_list_id = p_rbs_header_id;
651: BEGIN
652:

Line 664: Update pa_alloc_rules_all

660:
661: IF NVL(ALLOC_CUR.alloc_resource_struct_type,'RL') = 'RBS' and ALLOC_CUR.alloc_resource_list_id = p_rbs_header_id
662: and NVL(ALLOC_CUR.ALLOC_RBS_VERSION,0) < p_rbs_version_id Then
663:
664: Update pa_alloc_rules_all
665: Set alloc_rbs_version = p_rbs_version_id
666: Where RULE_ID = ALLOC_CUR.RULE_ID;
667:
668: Update pa_alloc_resources ARS

Line 690: Update pa_alloc_rules_all

686:
687: IF NVL(ALLOC_CUR.basis_resource_struct_type,'RL') = 'RBS' and ALLOC_CUR.basis_resource_list_id = p_rbs_header_id
688: and NVL(ALLOC_CUR.BASIS_RBS_VERSION,0) < p_rbs_version_id Then
689:
690: Update pa_alloc_rules_all
691: Set basis_rbs_version = p_rbs_version_id
692: Where RULE_ID = ALLOC_CUR.RULE_ID;
693:
694: Update pa_alloc_resources ARS

Line 718: ,pa_alloc_rules_all ar

714: Set resource_list_member_id = (
715: select new.rbs_element_id
716: from pa_rbs_elements new
717: ,pa_rbs_elements old
718: ,pa_alloc_rules_all ar
719: where ar.alloc_resource_list_id = p_rbs_header_id
720: and decode ( ars.member_type ,
721: 'S' , nvl(ar.alloc_resource_struct_type,'RL') ,
722: 'B' , nvl(ar.basis_resource_struct_type,'RL')

Line 732: From pa_alloc_rules_all arl

728: and old.rbs_element_id = ars.resource_list_member_id
729: )
730: Where Exists (
731: select 1
732: From pa_alloc_rules_all arl
733: Where arl.Rule_Id = Ars.Rule_Id
734: ANd decode ( ars.member_type ,
735: 'S' , nvl(arl.alloc_resource_struct_type,'RL') ,
736: 'B' , nvl(arl.basis_resource_struct_type,'RL')

Line 739: Update pa_alloc_rules_all

735: 'S' , nvl(arl.alloc_resource_struct_type,'RL') ,
736: 'B' , nvl(arl.basis_resource_struct_type,'RL')
737: ) = 'RBS'
738: );
739: Update pa_alloc_rules_all
740: Set alloc_rbs_version = p_rbs_version_id
741: Where nvl(alloc_resource_struct_type,'RL') = 'RBS'
742: And alloc_resource_list_id = p_rbs_header_id;
743: Update pa_alloc_rules_all

Line 743: Update pa_alloc_rules_all

739: Update pa_alloc_rules_all
740: Set alloc_rbs_version = p_rbs_version_id
741: Where nvl(alloc_resource_struct_type,'RL') = 'RBS'
742: And alloc_resource_list_id = p_rbs_header_id;
743: Update pa_alloc_rules_all
744: Set basis_rbs_version = p_rbs_version_id
745: Where nvl(basis_resource_struct_type,'RL') = 'RBS'
746: And basis_resource_list_id = p_rbs_header_id;
747: