APPS.QPR_PR_SEGMENTS_PKG dependencies on QPR_PR_SEGMENTS_TL

Line 52: insert into QPR_PR_SEGMENTS_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into QPR_PR_SEGMENTS_TL (
53: PR_SEGMENT_ID,
54: NAME,
55: DESCRIPTION,
56: CREATION_DATE,

Line 86: from QPR_PR_SEGMENTS_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from QPR_PR_SEGMENTS_TL T
87: where T.PR_SEGMENT_ID = X_PR_SEGMENT_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:
90: open c;

Line 127: from QPR_PR_SEGMENTS_TL

123: cursor c1 is select
124: NAME,
125: DESCRIPTION,
126: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
127: from QPR_PR_SEGMENTS_TL
128: where PR_SEGMENT_ID = X_PR_SEGMENT_ID
129: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
130: for update of PR_SEGMENT_ID nowait;
131: begin

Line 205: update QPR_PR_SEGMENTS_TL set

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: update QPR_PR_SEGMENTS_TL set
206: NAME = X_NAME,
207: DESCRIPTION = X_DESCRIPTION,
208: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
209: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 224: delete from QPR_PR_SEGMENTS_TL

220: procedure DELETE_ROW (
221: X_PR_SEGMENT_ID in NUMBER
222: ) is
223: begin
224: delete from QPR_PR_SEGMENTS_TL
225: where PR_SEGMENT_ID = X_PR_SEGMENT_ID;
226:
227: if (sql%notfound) then
228: raise no_data_found;

Line 242: delete from QPR_PR_SEGMENTS_TL T

238:
239: procedure ADD_LANGUAGE
240: is
241: begin
242: delete from QPR_PR_SEGMENTS_TL T
243: where not exists
244: (select NULL
245: from QPR_PR_SEGMENTS_B B
246: where B.PR_SEGMENT_ID = T.PR_SEGMENT_ID

Line 249: update QPR_PR_SEGMENTS_TL T set (

245: from QPR_PR_SEGMENTS_B B
246: where B.PR_SEGMENT_ID = T.PR_SEGMENT_ID
247: );
248:
249: update QPR_PR_SEGMENTS_TL T set (
250: NAME,
251: DESCRIPTION
252: ) = (select
253: B.NAME,

Line 255: from QPR_PR_SEGMENTS_TL B

251: DESCRIPTION
252: ) = (select
253: B.NAME,
254: B.DESCRIPTION
255: from QPR_PR_SEGMENTS_TL B
256: where B.PR_SEGMENT_ID = T.PR_SEGMENT_ID
257: and B.LANGUAGE = T.SOURCE_LANG)
258: where (
259: T.PR_SEGMENT_ID,

Line 264: from QPR_PR_SEGMENTS_TL SUBB, QPR_PR_SEGMENTS_TL SUBT

260: T.LANGUAGE
261: ) in (select
262: SUBT.PR_SEGMENT_ID,
263: SUBT.LANGUAGE
264: from QPR_PR_SEGMENTS_TL SUBB, QPR_PR_SEGMENTS_TL SUBT
265: where SUBB.PR_SEGMENT_ID = SUBT.PR_SEGMENT_ID
266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.NAME <> SUBT.NAME
268: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 273: insert into QPR_PR_SEGMENTS_TL (

269: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
270: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
271: ));
272:
273: insert into QPR_PR_SEGMENTS_TL (
274: PR_SEGMENT_ID,
275: NAME,
276: DESCRIPTION,
277: CREATION_DATE,

Line 303: from QPR_PR_SEGMENTS_TL B, FND_LANGUAGES L

299: B.PROGRAM_APPLICATION_ID,
300: B.REQUEST_ID,
301: L.LANGUAGE_CODE,
302: B.SOURCE_LANG
303: from QPR_PR_SEGMENTS_TL B, FND_LANGUAGES L
304: where L.INSTALLED_FLAG in ('I', 'B')
305: and B.LANGUAGE = userenv('LANG')
306: and not exists
307: (select NULL

Line 308: from QPR_PR_SEGMENTS_TL T

304: where L.INSTALLED_FLAG in ('I', 'B')
305: and B.LANGUAGE = userenv('LANG')
306: and not exists
307: (select NULL
308: from QPR_PR_SEGMENTS_TL T
309: where T.PR_SEGMENT_ID = B.PR_SEGMENT_ID
310: and T.LANGUAGE = L.LANGUAGE_CODE);
311: end ADD_LANGUAGE;
312: