APPS.QPR_POLICIES_PKG dependencies on QPR_POLICIES_TL

Line 43: insert into QPR_POLICIES_TL (

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

Line 77: from QPR_POLICIES_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_POLICIES_TL T
78: where T.POLICY_ID = X_POLICY_ID
79: and T.LANGUAGE = L.LANGUAGE_CODE);
80:
81: open c;

Line 110: from QPR_POLICIES_TL

106:
107: cursor c1 is select
108: NAME,
109: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
110: from QPR_POLICIES_TL
111: where POLICY_ID = X_POLICY_ID
112: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
113: for update of POLICY_ID nowait;
114: begin

Line 175: update QPR_POLICIES_TL set

171: if (sql%notfound) then
172: raise no_data_found;
173: end if;
174:
175: update QPR_POLICIES_TL set
176: NAME = X_NAME,
177: DESCRIPTION = X_DESCRIPTION,
178: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
179: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 194: delete from QPR_POLICIES_TL

190: procedure DELETE_ROW (
191: X_POLICY_ID in NUMBER
192: ) is
193: begin
194: delete from QPR_POLICIES_TL
195: where POLICY_ID = X_POLICY_ID;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 212: delete from QPR_POLICIES_TL T

208:
209: procedure ADD_LANGUAGE
210: is
211: begin
212: delete from QPR_POLICIES_TL T
213: where not exists
214: (select NULL
215: from QPR_POLICIES_B B
216: where B.POLICY_ID = T.POLICY_ID

Line 219: update QPR_POLICIES_TL T set (

215: from QPR_POLICIES_B B
216: where B.POLICY_ID = T.POLICY_ID
217: );
218:
219: update QPR_POLICIES_TL T set (
220: NAME
221: ) = (select
222: B.NAME
223: from QPR_POLICIES_TL B

Line 223: from QPR_POLICIES_TL B

219: update QPR_POLICIES_TL T set (
220: NAME
221: ) = (select
222: B.NAME
223: from QPR_POLICIES_TL B
224: where B.POLICY_ID = T.POLICY_ID
225: and B.LANGUAGE = T.SOURCE_LANG)
226: where (
227: T.POLICY_ID,

Line 232: from QPR_POLICIES_TL SUBB, QPR_POLICIES_TL SUBT

228: T.LANGUAGE
229: ) in (select
230: SUBT.POLICY_ID,
231: SUBT.LANGUAGE
232: from QPR_POLICIES_TL SUBB, QPR_POLICIES_TL SUBT
233: where SUBB.POLICY_ID = SUBT.POLICY_ID
234: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
235: and (SUBB.NAME <> SUBT.NAME
236: ));

Line 238: insert into QPR_POLICIES_TL (

234: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
235: and (SUBB.NAME <> SUBT.NAME
236: ));
237:
238: insert into QPR_POLICIES_TL (
239: DESCRIPTION,
240: POLICY_ID,
241: NAME,
242: CREATION_DATE,

Line 268: from QPR_POLICIES_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_POLICIES_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_POLICIES_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_POLICIES_TL T
274: where T.POLICY_ID = B.POLICY_ID
275: and T.LANGUAGE = L.LANGUAGE_CODE);
276: end ADD_LANGUAGE;
277: