APPS.HR_MULTI_TENANCY_PKG dependencies on PER_ENTERPRISES

Line 102: FROM per_enterprises_tl pet

98: ,pet.description
99: ,pet.source_lang
100: ,pet.created_by
101: ,pet.creation_date
102: FROM per_enterprises_tl pet
103: WHERE pet.language = userenv('LANG');
104:
105: CURSOR csr_ins_langs (c_enterprise_id NUMBER) IS
106: SELECT l.language_code

Line 110: FROM per_enterprises_tl pet

106: SELECT l.language_code
107: FROM fnd_languages l
108: WHERE l.installed_flag IN ('I','B')
109: AND NOT EXISTS (SELECT NULL
110: FROM per_enterprises_tl pet
111: WHERE pet.enterprise_id = c_enterprise_id
112: AND pet.language = l.language_code);
113: --
114: BEGIN

Line 116: DELETE FROM per_enterprises_tl t

112: AND pet.language = l.language_code);
113: --
114: BEGIN
115: --
116: DELETE FROM per_enterprises_tl t
117: WHERE NOT EXISTS
118: ( SELECT NULL
119: FROM per_enterprises b
120: WHERE b.enterprise_id = t.enterprise_id

Line 119: FROM per_enterprises b

115: --
116: DELETE FROM per_enterprises_tl t
117: WHERE NOT EXISTS
118: ( SELECT NULL
119: FROM per_enterprises b
120: WHERE b.enterprise_id = t.enterprise_id
121: );
122:
123: UPDATE per_enterprises_tl t

Line 123: UPDATE per_enterprises_tl t

119: FROM per_enterprises b
120: WHERE b.enterprise_id = t.enterprise_id
121: );
122:
123: UPDATE per_enterprises_tl t
124: SET ( enterprise_name,
125: description ) =
126: ( SELECT b.enterprise_name,
127: b.description

Line 128: FROM per_enterprises_tl b

124: SET ( enterprise_name,
125: description ) =
126: ( SELECT b.enterprise_name,
127: b.description
128: FROM per_enterprises_tl b
129: WHERE b.enterprise_id = t.enterprise_id
130: AND b.language = t.source_lang )
131: WHERE ( t.enterprise_id,
132: t.language

Line 136: FROM per_enterprises_tl subb, per_enterprises_tl subt

132: t.language
133: ) IN
134: ( SELECT subt.enterprise_id,
135: subt.language
136: FROM per_enterprises_tl subb, per_enterprises_tl subt
137: WHERE subb.enterprise_id = subt.enterprise_id
138: AND subb.language = subt.source_lang
139: AND ( subb.enterprise_name <> subt.enterprise_name
140: OR subb.description <> subt.description

Line 149: INSERT INTO per_enterprises_tl

145: --
146: --
147: FOR l_ent_data_group IN csr_ent_data_groups LOOP
148: FOR l_lang IN csr_ins_langs(l_ent_data_group.enterprise_id) LOOP
149: INSERT INTO per_enterprises_tl
150: (source_lang
151: ,enterprise_id
152: ,enterprise_name
153: ,description