[Home] [Help]
591: l_chrt_acct_id hr_all_organization_units.business_group_id%type;
592: l_table_name zx_party_types.party_source_table%type;
593: l_party_type zx_party_types.party_type_code%type;
594: l_party_number hz_parties.party_number%type;
595: l_name xle_entity_profiles.name%type;
596: l_flow VARCHAR2(2000);
597:
598: BEGIN
599: l_separator := ':';
784: ------------------------------------------------------
785: -- Gets user key for LEGAL_ENTITY_ID
786: -- the LOV used is LEGAL_ENTITY_LOV
787: -- and the segments in user key string are:
788: -- Segment 1 is PARTY_NAME (Comes from XLE_ENTITY_PROFILES.NAME)
789: -- Segment 2 is PARTY_NUMBER (Comes from HZ_PARTIES.PARTY_NUMBER)
790: ------------------------------------------------------
791:
792: IF p_user_key_type = 'LEGAL_ENTITY_ID' THEN
826: -- The Party Name is duplicated as there
827: -- is a row with the same name for Main Legal Establishment
828: -- and one row same name for the Legal entity itself. The
829: -- Party Number is unique and this will distinguish the rows.
830: -- However xle_entity_profiles does not contain party_number. This
831: -- is why is required to go and join with hz_parties.
832: -- Discussed with Desh on 11-Nov-2005
833: ----------------------------------------------
834:
833: ----------------------------------------------
834:
835: select xle_ep.legal_entity_id
836: into x_user_key_id
837: from xle_entity_profiles xle_ep,
838: hz_parties hz_pty
839: where xle_ep.party_id = hz_pty.party_id
840: and upper(xle_ep.name) = l_name
841: and hz_pty.party_number = l_party_number;
973: -- We have two cases. User Key with one Value and Two Values
974: -- If we have User Key with One Value:
975: -- Segment1 => Party Number (From HZ_PARTIES.PARTY_NUMBER)
976: -- If we have User Key with Two Values:
977: -- Segment1 => Name (From XLE_ENTITY_PROFILES.NAME)
978: -- Segment2 => Party Number (From HZ_PARTIES.PARTY_NUMBER)
979: ------------------------------------------------------------
980: If nvl(l_number_of_segments,1) = 1 then
981: l_varchar2_id := l_user_key_segments_tbl(1);