APPS.PA_RES_TYPES_PVT dependencies on PA_RES_TYPES_TL

Line 48: insert into pa_res_types_tl (

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

Line 74: from pa_res_types_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_res_types_tl T
75: where T.RES_TYPE_ID = L_RES_TYPE_ID
76: and T.LANGUAGE = L.LANGUAGE_CODE);
77:
78: open c;

Line 102: from pa_res_types_tl

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

Line 144: update pa_res_types_tl set

140: if (sql%notfound) then
141: raise no_data_found;
142: end if;
143:
144: update pa_res_types_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_res_types_tl

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

Line 181: delete from pa_res_types_tl T

177:
178: procedure ADD_LANGUAGE
179: is
180: begin
181: delete from pa_res_types_tl T
182: where not exists
183: (select NULL
184: from PA_RES_TYPES_B B
185: where B.RES_TYPE_ID = T.res_type_id

Line 188: update pa_res_types_tl T set (

184: from PA_RES_TYPES_B B
185: where B.RES_TYPE_ID = T.res_type_id
186: );
187:
188: update pa_res_types_tl T set (
189: NAME,
190: DESCRIPTION
191: ) = (select
192: B.NAME,

Line 194: from pa_res_types_tl B

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

Line 203: from pa_res_types_tl SUBB, pa_res_types_tl SUBT

199: T.LANGUAGE
200: ) in (select
201: SUBT.RES_TYPE_ID,
202: SUBT.LANGUAGE
203: from pa_res_types_tl SUBB, pa_res_types_tl SUBT
204: where SUBB.RES_TYPE_ID = SUBT.RES_TYPE_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_res_types_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_res_types_tl (
213: LAST_UPDATE_LOGIN,
214: CREATION_DATE,
215: CREATED_BY,
216: LAST_UPDATE_DATE,

Line 234: from pa_res_types_tl B, FND_LANGUAGES L

230: B.NAME,
231: B.DESCRIPTION,
232: L.LANGUAGE_CODE,
233: B.SOURCE_LANG
234: from pa_res_types_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_res_types_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_res_types_tl T
240: where T.RES_TYPE_ID = B.RES_TYPE_ID
241: and T.LANGUAGE = L.LANGUAGE_CODE);
242: end ADD_LANGUAGE;
243:

Line 252: update pa_res_types_tl set

248: P_DESCRIPTION in VARCHAR2
249: ) is
250: begin
251:
252: update pa_res_types_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),