APPS.PQH_GENERIC_HIERARCHY_PACKAGE dependencies on PER_SHARED_TYPES

Line 883: select 'x' from PER_SHARED_TYPES

879: -- Check if the lookup exists already
880: -- for the current language
881: --
882: CURSOR csr_shared_type_entry_unique IS
883: select 'x' from PER_SHARED_TYPES
884: where lookup_type = 'HIERARCHY_TYPE'
885: and system_type_cd = p_lookup_code
886: and shared_type_code = p_lookup_code;
887: --

Line 889: l_object_version_number per_shared_types.object_version_number%TYPE;

885: and system_type_cd = p_lookup_code
886: and shared_type_code = p_lookup_code;
887: --
888: l_proc varchar2(72) ;
889: l_object_version_number per_shared_types.object_version_number%TYPE;
890: l_shared_type_id per_shared_types.shared_type_id%TYPE;
891: l_dummy varchar2(1);
892:
893: --

Line 890: l_shared_type_id per_shared_types.shared_type_id%TYPE;

886: and shared_type_code = p_lookup_code;
887: --
888: l_proc varchar2(72) ;
889: l_object_version_number per_shared_types.object_version_number%TYPE;
890: l_shared_type_id per_shared_types.shared_type_id%TYPE;
891: l_dummy varchar2(1);
892:
893: --
894: Begin

Line 939: per_shared_types_api.create_shared_type

935: end if;
936: -- Now we attempt to create a shared types entry using the
937: -- supplied code for the lookup_type 'HIERARCHY_TYPE'
938:
939: per_shared_types_api.create_shared_type
940: ( p_shared_type_id => l_shared_type_id
941: ,p_shared_type_name => p_meaning
942: ,p_system_type_cd => p_lookup_code
943: ,p_shared_type_code => p_lookup_code

Line 999: from PER_SHARED_TYPES

995: -- Check if the lookup exists already
996: --
997: CURSOR csr_shared_type_entry IS
998: select shared_type_id, object_version_number
999: from PER_SHARED_TYPES
1000: where lookup_type = 'HIERARCHY_TYPE'
1001: and system_type_cd = p_lookup_code
1002: and shared_type_code = p_lookup_code;
1003: --

Line 1005: l_object_version_number per_shared_types.object_version_number%TYPE;

1001: and system_type_cd = p_lookup_code
1002: and shared_type_code = p_lookup_code;
1003: --
1004: l_proc varchar2(72) ;
1005: l_object_version_number per_shared_types.object_version_number%TYPE;
1006: l_shared_type_id per_shared_types.shared_type_id%TYPE;
1007:
1008: --
1009: Begin

Line 1006: l_shared_type_id per_shared_types.shared_type_id%TYPE;

1002: and shared_type_code = p_lookup_code;
1003: --
1004: l_proc varchar2(72) ;
1005: l_object_version_number per_shared_types.object_version_number%TYPE;
1006: l_shared_type_id per_shared_types.shared_type_id%TYPE;
1007:
1008: --
1009: Begin
1010: --

Line 1050: per_shared_types_api.update_shared_type

1046: fnd_message.raise_error;
1047: Else
1048: -- Now we attempt to update the shared types entry
1049:
1050: per_shared_types_api.update_shared_type
1051: ( p_shared_type_id => l_shared_type_id
1052: ,p_language_code => userenv('LANG')
1053: ,p_information2 => p_information2
1054: ,p_information3 => p_information3