APPS.PA_RESOURCE_CLASSES_PVT dependencies on PA_RESOURCE_CLASSES_TL

Line 48: insert into pa_resource_classes_tl (

44: P_LAST_UPDATED_BY ,
45: P_LAST_UPDATE_LOGIN
46: );
47:
48: insert into pa_resource_classes_tl (
49: LAST_UPDATE_LOGIN,
50: CREATION_DATE,
51: CREATED_BY,
52: LAST_UPDATE_DATE,

Line 74: from PA_RESOURCE_CLASSES_TL T

70: from FND_LANGUAGES L
71: where L.INSTALLED_FLAG in ('I', 'B')
72: and not exists
73: (select NULL
74: from PA_RESOURCE_CLASSES_TL T
75: where T.RESOURCE_CLASS_ID = L_RESOURCE_CLASS_ID
76: and T.LANGUAGE = L.LANGUAGE_CODE);
77:
78: open c;

Line 102: from pa_resource_classes_tl

98: cursor c1 is select
99: NAME,
100: DESCRIPTION,
101: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
102: from pa_resource_classes_tl
103: where RESOURCE_CLASS_ID = P_RESOURCE_CLASS_ID
104: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
105: for update of RESOURCE_CLASS_ID nowait;
106: begin

Line 144: update pa_resource_classes_tl set

140: if (sql%notfound) then
141: raise no_data_found;
142: end if;
143:
144: update pa_resource_classes_tl set
145: NAME = P_NAME,
146: DESCRIPTION = P_DESCRIPTION,
147: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
148: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 163: delete from pa_resource_classes_tl

159: procedure DELETE_ROW (
160: P_RESOURCE_CLASS_ID in NUMBER
161: ) is
162: begin
163: delete from pa_resource_classes_tl
164: where RESOURCE_CLASS_ID = P_RESOURCE_CLASS_ID;
165:
166: if (sql%notfound) then
167: raise no_data_found;

Line 181: delete from pa_resource_classes_tl T

177:
178: procedure ADD_LANGUAGE
179: is
180: begin
181: delete from pa_resource_classes_tl T
182: where not exists
183: (select NULL
184: from pa_resource_classes_b B
185: where B.RESOURCE_CLASS_ID = T.RESOURCE_CLASS_ID

Line 188: update pa_resource_classes_tl T set (

184: from pa_resource_classes_b B
185: where B.RESOURCE_CLASS_ID = T.RESOURCE_CLASS_ID
186: );
187:
188: update pa_resource_classes_tl T set (
189: NAME,
190: DESCRIPTION
191: ) = (select
192: B.NAME,

Line 194: from pa_resource_classes_tl B

190: DESCRIPTION
191: ) = (select
192: B.NAME,
193: B.DESCRIPTION
194: from pa_resource_classes_tl B
195: where B.RESOURCE_CLASS_ID = T.RESOURCE_CLASS_ID
196: and B.LANGUAGE = T.SOURCE_LANG)
197: where (
198: T.RESOURCE_CLASS_ID,

Line 203: from pa_resource_classes_tl SUBB, pa_resource_classes_tl SUBT

199: T.LANGUAGE
200: ) in (select
201: SUBT.RESOURCE_CLASS_ID,
202: SUBT.LANGUAGE
203: from pa_resource_classes_tl SUBB, pa_resource_classes_tl SUBT
204: where SUBB.RESOURCE_CLASS_ID = SUBT.RESOURCE_CLASS_ID
205: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
206: and (SUBB.NAME <> SUBT.NAME
207: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 212: insert into pa_resource_classes_tl (

208: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
209: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
210: ));
211:
212: insert into pa_resource_classes_tl (
213: LAST_UPDATE_LOGIN,
214: CREATION_DATE,
215: CREATED_BY,
216: LAST_UPDATE_DATE,

Line 234: from pa_resource_classes_tl B, FND_LANGUAGES L

230: B.NAME,
231: B.DESCRIPTION,
232: L.LANGUAGE_CODE,
233: B.SOURCE_LANG
234: from pa_resource_classes_tl B, FND_LANGUAGES L
235: where L.INSTALLED_FLAG in ('I', 'B')
236: and B.LANGUAGE = userenv('LANG')
237: and not exists
238: (select NULL

Line 239: from pa_resource_classes_tl T

235: where L.INSTALLED_FLAG in ('I', 'B')
236: and B.LANGUAGE = userenv('LANG')
237: and not exists
238: (select NULL
239: from pa_resource_classes_tl T
240: where T.RESOURCE_CLASS_ID = B.RESOURCE_CLASS_ID
241: and T.LANGUAGE = L.LANGUAGE_CODE);
242: end ADD_LANGUAGE;
243:

Line 252: update pa_resource_classes_tl set

248: P_DESCRIPTION in VARCHAR2
249: ) is
250: begin
251:
252: update pa_resource_classes_tl set
253: NAME = P_NAME,
254: DESCRIPTION = P_DESCRIPTION,
255: LAST_UPDATE_DATE = sysdate,
256: LAST_UPDATED_BY = decode(P_OWNER, 'SEED', 1, 0),