APPS.QPR_DISCOUNT_GRPS_PKG dependencies on QPR_DISCOUNT_GRPS_TL

Line 40: insert into QPR_DISCOUNT_GRPS_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into QPR_DISCOUNT_GRPS_TL (
41: DISCOUNT_GRP_ID,
42: NAME,
43: DESCRIPTION,
44: CREATION_DATE,

Line 74: from QPR_DISCOUNT_GRPS_TL T

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

Line 107: from QPR_DISCOUNT_GRPS_TL

103: cursor c1 is select
104: NAME,
105: DESCRIPTION,
106: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
107: from QPR_DISCOUNT_GRPS_TL
108: where DISCOUNT_GRP_ID = X_DISCOUNT_GRP_ID
109: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
110: for update of DISCOUNT_GRP_ID nowait;
111: begin

Line 170: update QPR_DISCOUNT_GRPS_TL set

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: update QPR_DISCOUNT_GRPS_TL set
171: NAME = X_NAME,
172: DESCRIPTION = X_DESCRIPTION,
173: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
174: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 189: delete from QPR_DISCOUNT_GRPS_TL

185: procedure DELETE_ROW (
186: X_DISCOUNT_GRP_ID in NUMBER
187: ) is
188: begin
189: delete from QPR_DISCOUNT_GRPS_TL
190: where DISCOUNT_GRP_ID = X_DISCOUNT_GRP_ID;
191:
192: if (sql%notfound) then
193: raise no_data_found;

Line 207: delete from QPR_DISCOUNT_GRPS_TL T

203:
204: procedure ADD_LANGUAGE
205: is
206: begin
207: delete from QPR_DISCOUNT_GRPS_TL T
208: where not exists
209: (select NULL
210: from QPR_DISCOUNT_GRPS_B B
211: where B.DISCOUNT_GRP_ID = T.DISCOUNT_GRP_ID

Line 214: update QPR_DISCOUNT_GRPS_TL T set (

210: from QPR_DISCOUNT_GRPS_B B
211: where B.DISCOUNT_GRP_ID = T.DISCOUNT_GRP_ID
212: );
213:
214: update QPR_DISCOUNT_GRPS_TL T set (
215: NAME,
216: DESCRIPTION
217: ) = (select
218: B.NAME,

Line 220: from QPR_DISCOUNT_GRPS_TL B

216: DESCRIPTION
217: ) = (select
218: B.NAME,
219: B.DESCRIPTION
220: from QPR_DISCOUNT_GRPS_TL B
221: where B.DISCOUNT_GRP_ID = T.DISCOUNT_GRP_ID
222: and B.LANGUAGE = T.SOURCE_LANG)
223: where (
224: T.DISCOUNT_GRP_ID,

Line 229: from QPR_DISCOUNT_GRPS_TL SUBB, QPR_DISCOUNT_GRPS_TL SUBT

225: T.LANGUAGE
226: ) in (select
227: SUBT.DISCOUNT_GRP_ID,
228: SUBT.LANGUAGE
229: from QPR_DISCOUNT_GRPS_TL SUBB, QPR_DISCOUNT_GRPS_TL SUBT
230: where SUBB.DISCOUNT_GRP_ID = SUBT.DISCOUNT_GRP_ID
231: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
232: and (SUBB.NAME <> SUBT.NAME
233: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 238: insert into QPR_DISCOUNT_GRPS_TL (

234: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
235: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
236: ));
237:
238: insert into QPR_DISCOUNT_GRPS_TL (
239: DISCOUNT_GRP_ID,
240: NAME,
241: DESCRIPTION,
242: CREATION_DATE,

Line 268: from QPR_DISCOUNT_GRPS_TL B, FND_LANGUAGES L

264: B.PROGRAM_APPLICATION_ID,
265: B.REQUEST_ID,
266: L.LANGUAGE_CODE,
267: B.SOURCE_LANG
268: from QPR_DISCOUNT_GRPS_TL B, FND_LANGUAGES L
269: where L.INSTALLED_FLAG in ('I', 'B')
270: and B.LANGUAGE = userenv('LANG')
271: and not exists
272: (select NULL

Line 273: from QPR_DISCOUNT_GRPS_TL T

269: where L.INSTALLED_FLAG in ('I', 'B')
270: and B.LANGUAGE = userenv('LANG')
271: and not exists
272: (select NULL
273: from QPR_DISCOUNT_GRPS_TL T
274: where T.DISCOUNT_GRP_ID = B.DISCOUNT_GRP_ID
275: and T.LANGUAGE = L.LANGUAGE_CODE);
276: end ADD_LANGUAGE;
277: