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_RBS_ELEMENTS

Line 507: FUNCTION Is_RBS_Element_In_Rules ( P_RBS_ELEMENT_ID IN pa_rbs_elements.RBS_ELEMENT_ID%type ) RETURN

503: API Desc : Return 'Y' if RBS Element is used in Allocations.
504: API Created Date : 19-Mar-04
505: API Created By : Vthakkar
506: */
507: FUNCTION Is_RBS_Element_In_Rules ( P_RBS_ELEMENT_ID IN pa_rbs_elements.RBS_ELEMENT_ID%type ) RETURN
508: VARCHAR2
509:
510: IS
511: l_exists Varchar2(1) := 'N';

Line 568: p_resource_id IN pa_rbs_elements.RBS_ELEMENT_ID%type ,

564: API Created By : Vthakkar
565: */
566: Function Resource_Name (
567: p_alloc_type IN Varchar2 ,
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;

Line 595: From pa_rbs_elements

591: where prlm.resource_list_member_id = p_resource_id;
592: Elsif l_source_res_struct_type = 'RBS' Then
593: Select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)
594: Into X_name
595: From pa_rbs_elements
596: Where rbs_element_id = p_resource_id
597: And rownum = 1;
598:
599: End If;

Line 609: from pa_rbs_elements

605: where prlm.resource_list_member_id = p_resource_id;
606: Elsif l_basis_res_struct_type = 'RBS' Then
607: select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)
608: Into X_name
609: from pa_rbs_elements
610: where rbs_element_id = p_resource_id
611: and rownum = 1;
612: End If;
613: End If;

Line 658: from pa_rbs_elements new

654:
655: Update pa_alloc_resources ARS
656: Set resource_list_member_id = (
657: select new.rbs_element_id
658: from pa_rbs_elements new
659: ,pa_rbs_elements old
660: where new.element_identifier = old.element_identifier
661: and old.rbs_version_Id = ALLOC_CUR.alloc_rbs_version
662: and new.rbs_version_Id = p_rbs_version_id

Line 659: ,pa_rbs_elements old

655: Update pa_alloc_resources ARS
656: Set resource_list_member_id = (
657: select new.rbs_element_id
658: from pa_rbs_elements new
659: ,pa_rbs_elements old
660: where new.element_identifier = old.element_identifier
661: and old.rbs_version_Id = ALLOC_CUR.alloc_rbs_version
662: and new.rbs_version_Id = p_rbs_version_id
663: and old.rbs_element_id = ars.resource_list_member_id

Line 684: from pa_rbs_elements new

680:
681: Update pa_alloc_resources ARS
682: Set resource_list_member_id = (
683: select new.rbs_element_id
684: from pa_rbs_elements new
685: ,pa_rbs_elements old
686: where new.element_identifier = old.element_identifier
687: and old.rbs_version_Id = ALLOC_CUR.basis_rbs_version
688: and new.rbs_version_Id = p_rbs_version_id

Line 685: ,pa_rbs_elements old

681: Update pa_alloc_resources ARS
682: Set resource_list_member_id = (
683: select new.rbs_element_id
684: from pa_rbs_elements new
685: ,pa_rbs_elements old
686: where new.element_identifier = old.element_identifier
687: and old.rbs_version_Id = ALLOC_CUR.basis_rbs_version
688: and new.rbs_version_Id = p_rbs_version_id
689: and old.rbs_element_id = ars.resource_list_member_id

Line 703: from pa_rbs_elements new

699: /* Commenting out the code for bug 4107924
700: Update pa_alloc_resources ARS
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 ,

Line 704: ,pa_rbs_elements old

700: Update pa_alloc_resources ARS
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') ,

Line 800: FROM pa_rbs_elements ele

796: Where prt.resource_list_member_id (+) = slf.parent_member_id
797: and slf.resource_list_member_id = p_resource_id;
798: Cursor c_element_name
799: IS SELECT pa_alloc_utils.Get_Resource_Name_TL(ele.rbs_element_name_id) Resource_Name
800: FROM pa_rbs_elements ele
801: CONNECT BY PRIOR ele.parent_element_id = ele.rbs_element_id
802: START WITH ele.rbs_element_id = p_resource_id
803: ORDER BY ele.rbs_level DESC;
804: Begin