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: CURSOR C_task_in_alloc_src_line(x_task_id IN NUMBER) is
174: SELECT 'Y'
175: FROM PA_ALLOC_SOURCE_LINES SRCL

Line 290: FROM PA_ALLOC_RULES_ALL RULES

286: FROM PA_ALLOC_TXN_DETAILS TXN
287: WHERE TXN.task_id=p_task_id)
288: OR EXISTS
289: ( SELECT '1'
290: FROM PA_ALLOC_RULES_ALL RULES
291: WHERE RULES.offset_task_id=p_task_id)
292: OR EXISTS
293: (SELECT '1'
294: FROM PA_ALLOC_TARGET_LINES TGTL

Line 369: FROM PA_ALLOC_RULES_ALL

365: CURSOR C_budget_type_in_allocations is
366: SELECT '1'
367: FROM dual
368: WHERE EXISTS (SELECT 'Y'
369: FROM PA_ALLOC_RULES_ALL
370: WHERE basis_budget_type_code=p_budget_type_code)
371: OR EXISTS
372: (SELECT 'Y'
373: FROM PA_ALLOC_RUNS_ALL

Line 412: FROM PA_ALLOC_RULES_ALL

408: CURSOR C_Bem_in_allocations is
409: SELECT '1'
410: FROM dual
411: WHERE EXISTS (SELECT 'Y'
412: FROM PA_ALLOC_RULES_ALL
413: WHERE basis_budget_entry_method_code=p_bem_code)
414: OR EXISTS
415: (SELECT 'Y'
416: FROM PA_ALLOC_RUNS_ALL

Line 453: /* Checking PA_ALLOC_RULES_ALL */

449: FUNCTION Is_RBS_In_Rules ( P_RBS_ID IN pa_rbs_headers_v.RBS_HEADER_ID%Type ) RETURN VARCHAR2
450: IS
451: l_exists Varchar2(1) := 'N';
452: BEGIN
453: /* Checking PA_ALLOC_RULES_ALL */
454: Begin
455: Select 'Y' into l_exists
456: from pa_alloc_rules_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
457: where

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

452: BEGIN
453: /* Checking PA_ALLOC_RULES_ALL */
454: Begin
455: Select 'Y' into l_exists
456: from pa_alloc_rules_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
457: where
458: (
459: ( ALLOC_RESOURCE_STRUCT_TYPE = 'RBS'
460: and

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

475: End;
476: /* Checking PA_ALLOC_RUNS_ALL */
477: Begin
478: Select 'Y' into l_exists
479: from pa_alloc_runs_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
480: where (
481: ( ALLOC_RESOURCE_STRUCT_TYPE = 'RBS'
482: and
483: Alloc_resource_list_id = P_RBS_ID

Line 515: From PA_ALLOC_RULES_ALL par, PA_ALLOC_RESOURCES pr

511: l_exists Varchar2(1) := 'N';
512: BEGIN
513: Begin
514: Select 'Y' into l_exists
515: From PA_ALLOC_RULES_ALL par, PA_ALLOC_RESOURCES pr
516: Where par.rule_id = pr.rule_id
517: and pr.RESOURCE_LIST_MEMBER_ID = P_RBS_ELEMENT_ID
518: and decode (pr.member_type , 'S' , par.ALLOC_RESOURCE_STRUCT_TYPE ,
519: 'B' , par.BASIS_RESOURCE_STRUCT_TYPE

Line 572: l_source_res_struct_type pa_alloc_rules_all.ALLOC_RESOURCE_STRUCT_TYPE%type;

568: p_resource_id IN pa_rbs_elements.RBS_ELEMENT_ID%type ,
569: p_rule_id IN pa_alloc_rules.rule_id%type
570: ) Return Varchar2
571: IS
572: l_source_res_struct_type pa_alloc_rules_all.ALLOC_RESOURCE_STRUCT_TYPE%type;
573: l_basis_res_struct_type pa_alloc_rules_all.BASIS_RESOURCE_STRUCT_TYPE%type;
574:
575: x_name varchar2(4000);
576: BEGIN

Line 573: l_basis_res_struct_type pa_alloc_rules_all.BASIS_RESOURCE_STRUCT_TYPE%type;

569: p_rule_id IN pa_alloc_rules.rule_id%type
570: ) Return Varchar2
571: IS
572: l_source_res_struct_type pa_alloc_rules_all.ALLOC_RESOURCE_STRUCT_TYPE%type;
573: l_basis_res_struct_type pa_alloc_rules_all.BASIS_RESOURCE_STRUCT_TYPE%type;
574:
575: x_name varchar2(4000);
576: BEGIN
577: If p_resource_id Is Null Then

Line 584: From pa_alloc_rules_all

580: Select ALLOC_RESOURCE_STRUCT_TYPE ,
581: BASIS_RESOURCE_STRUCT_TYPE
582: Into l_source_res_struct_type ,
583: l_basis_res_struct_type
584: From pa_alloc_rules_all
585: Where Rule_ID = p_Rule_Id;
586: If p_alloc_type In ('SOURCE' , 'S') Then
587: If l_source_res_struct_type = 'RL' Then
588: select prlm.alias

Line 635: CURSOR LV_ALLOC_CUR IS SELECT * FROM PA_ALLOC_RULES_ALL

631: x_return_status OUT NOCOPY VARCHAR2 ,
632: x_error_code OUT NOCOPY VARCHAR2
633: )
634: IS
635: CURSOR LV_ALLOC_CUR IS SELECT * FROM PA_ALLOC_RULES_ALL
636: WHERE alloc_resource_list_id = p_rbs_header_id
637: OR basis_resource_list_id = p_rbs_header_id;
638: BEGIN
639:

Line 651: Update pa_alloc_rules_all

647:
648: IF NVL(ALLOC_CUR.alloc_resource_struct_type,'RL') = 'RBS' and ALLOC_CUR.alloc_resource_list_id = p_rbs_header_id
649: and NVL(ALLOC_CUR.ALLOC_RBS_VERSION,0) < p_rbs_version_id Then
650:
651: Update pa_alloc_rules_all
652: Set alloc_rbs_version = p_rbs_version_id
653: Where RULE_ID = ALLOC_CUR.RULE_ID;
654:
655: Update pa_alloc_resources ARS

Line 677: Update pa_alloc_rules_all

673:
674: IF NVL(ALLOC_CUR.basis_resource_struct_type,'RL') = 'RBS' and ALLOC_CUR.basis_resource_list_id = p_rbs_header_id
675: and NVL(ALLOC_CUR.BASIS_RBS_VERSION,0) < p_rbs_version_id Then
676:
677: Update pa_alloc_rules_all
678: Set basis_rbs_version = p_rbs_version_id
679: Where RULE_ID = ALLOC_CUR.RULE_ID;
680:
681: Update pa_alloc_resources ARS

Line 705: ,pa_alloc_rules_all ar

701: Set resource_list_member_id = (
702: select new.rbs_element_id
703: from pa_rbs_elements new
704: ,pa_rbs_elements old
705: ,pa_alloc_rules_all ar
706: where ar.alloc_resource_list_id = p_rbs_header_id
707: and decode ( ars.member_type ,
708: 'S' , nvl(ar.alloc_resource_struct_type,'RL') ,
709: 'B' , nvl(ar.basis_resource_struct_type,'RL')

Line 719: From pa_alloc_rules_all arl

715: and old.rbs_element_id = ars.resource_list_member_id
716: )
717: Where Exists (
718: select 1
719: From pa_alloc_rules_all arl
720: Where arl.Rule_Id = Ars.Rule_Id
721: ANd decode ( ars.member_type ,
722: 'S' , nvl(arl.alloc_resource_struct_type,'RL') ,
723: 'B' , nvl(arl.basis_resource_struct_type,'RL')

Line 726: Update pa_alloc_rules_all

722: 'S' , nvl(arl.alloc_resource_struct_type,'RL') ,
723: 'B' , nvl(arl.basis_resource_struct_type,'RL')
724: ) = 'RBS'
725: );
726: Update pa_alloc_rules_all
727: Set alloc_rbs_version = p_rbs_version_id
728: Where nvl(alloc_resource_struct_type,'RL') = 'RBS'
729: And alloc_resource_list_id = p_rbs_header_id;
730: Update pa_alloc_rules_all

Line 730: Update pa_alloc_rules_all

726: Update pa_alloc_rules_all
727: Set alloc_rbs_version = p_rbs_version_id
728: Where nvl(alloc_resource_struct_type,'RL') = 'RBS'
729: And alloc_resource_list_id = p_rbs_header_id;
730: Update pa_alloc_rules_all
731: Set basis_rbs_version = p_rbs_version_id
732: Where nvl(basis_resource_struct_type,'RL') = 'RBS'
733: And basis_resource_list_id = p_rbs_header_id;
734: