APPS.QPR_TRANSF_GROUPS_PKG dependencies on QPR_TRANSF_GROUPS_TL

Line 43: insert into QPR_TRANSF_GROUPS_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into QPR_TRANSF_GROUPS_TL (
44: TRANSF_GROUP_ID,
45: NAME,
46: DESCRIPTION,
47: CREATION_DATE,

Line 77: from QPR_TRANSF_GROUPS_TL T

73: from FND_LANGUAGES L
74: where L.INSTALLED_FLAG in ('I', 'B')
75: and not exists
76: (select NULL
77: from QPR_TRANSF_GROUPS_TL T
78: where T.TRANSF_GROUP_ID = X_TRANSF_GROUP_ID
79: and T.LANGUAGE = L.LANGUAGE_CODE);
80:
81: open c;

Line 112: from QPR_TRANSF_GROUPS_TL

108: cursor c1 is select
109: NAME,
110: DESCRIPTION,
111: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
112: from QPR_TRANSF_GROUPS_TL
113: where TRANSF_GROUP_ID = X_TRANSF_GROUP_ID
114: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
115: for update of TRANSF_GROUP_ID nowait;
116: begin

Line 179: update QPR_TRANSF_GROUPS_TL set

175: if (sql%notfound) then
176: raise no_data_found;
177: end if;
178:
179: update QPR_TRANSF_GROUPS_TL set
180: NAME = X_NAME,
181: DESCRIPTION = X_DESCRIPTION,
182: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
183: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 198: delete from QPR_TRANSF_GROUPS_TL

194: procedure DELETE_ROW (
195: X_TRANSF_GROUP_ID in NUMBER
196: ) is
197: begin
198: delete from QPR_TRANSF_GROUPS_TL
199: where TRANSF_GROUP_ID = X_TRANSF_GROUP_ID;
200:
201: if (sql%notfound) then
202: raise no_data_found;

Line 216: delete from QPR_TRANSF_GROUPS_TL T

212:
213: procedure ADD_LANGUAGE
214: is
215: begin
216: delete from QPR_TRANSF_GROUPS_TL T
217: where not exists
218: (select NULL
219: from QPR_TRANSF_GROUPS_B B
220: where B.TRANSF_GROUP_ID = T.TRANSF_GROUP_ID

Line 223: update QPR_TRANSF_GROUPS_TL T set (

219: from QPR_TRANSF_GROUPS_B B
220: where B.TRANSF_GROUP_ID = T.TRANSF_GROUP_ID
221: );
222:
223: update QPR_TRANSF_GROUPS_TL T set (
224: NAME,
225: DESCRIPTION
226: ) = (select
227: B.NAME,

Line 229: from QPR_TRANSF_GROUPS_TL B

225: DESCRIPTION
226: ) = (select
227: B.NAME,
228: B.DESCRIPTION
229: from QPR_TRANSF_GROUPS_TL B
230: where B.TRANSF_GROUP_ID = T.TRANSF_GROUP_ID
231: and B.LANGUAGE = T.SOURCE_LANG)
232: where (
233: T.TRANSF_GROUP_ID,

Line 238: from QPR_TRANSF_GROUPS_TL SUBB, QPR_TRANSF_GROUPS_TL SUBT

234: T.LANGUAGE
235: ) in (select
236: SUBT.TRANSF_GROUP_ID,
237: SUBT.LANGUAGE
238: from QPR_TRANSF_GROUPS_TL SUBB, QPR_TRANSF_GROUPS_TL SUBT
239: where SUBB.TRANSF_GROUP_ID = SUBT.TRANSF_GROUP_ID
240: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
241: and (SUBB.NAME <> SUBT.NAME
242: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 247: insert into QPR_TRANSF_GROUPS_TL (

243: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
244: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
245: ));
246:
247: insert into QPR_TRANSF_GROUPS_TL (
248: TRANSF_GROUP_ID,
249: NAME,
250: DESCRIPTION,
251: CREATION_DATE,

Line 277: from QPR_TRANSF_GROUPS_TL B, FND_LANGUAGES L

273: B.PROGRAM_APPLICATION_ID,
274: B.REQUEST_ID,
275: L.LANGUAGE_CODE,
276: B.SOURCE_LANG
277: from QPR_TRANSF_GROUPS_TL B, FND_LANGUAGES L
278: where L.INSTALLED_FLAG in ('I', 'B')
279: and B.LANGUAGE = userenv('LANG')
280: and not exists
281: (select NULL

Line 282: from QPR_TRANSF_GROUPS_TL T

278: where L.INSTALLED_FLAG in ('I', 'B')
279: and B.LANGUAGE = userenv('LANG')
280: and not exists
281: (select NULL
282: from QPR_TRANSF_GROUPS_TL T
283: where T.TRANSF_GROUP_ID = B.TRANSF_GROUP_ID
284: and T.LANGUAGE = L.LANGUAGE_CODE);
285: end ADD_LANGUAGE;
286: