APPS.JTF_R_RULESETS_PKG dependencies on JTF_R_RULESETS_TL

Line 61: insert into JTF_R_RULESETS_TL (

57: X_LAST_UPDATED_BY,
58: X_LAST_UPDATE_LOGIN
59: );
60:
61: insert into JTF_R_RULESETS_TL (
62: DESCRIPTION,
63: OBJECT_VERSION_NUMBER,
64: LAST_UPDATED_BY,
65: LAST_UPDATE_DATE,

Line 89: from JTF_R_RULESETS_TL T

85: from FND_LANGUAGES L
86: where L.INSTALLED_FLAG in ('I', 'B')
87: and not exists
88: (select NULL
89: from JTF_R_RULESETS_TL T
90: where T.RULESET_ID = X_RULESET_ID
91: and T.LANGUAGE = L.LANGUAGE_CODE);
92:
93: open c;

Line 136: from JTF_R_RULESETS_TL

132: cursor c1 is select
133: NAME,
134: DESCRIPTION,
135: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
136: from JTF_R_RULESETS_TL
137: where RULESET_ID = X_RULESET_ID
138: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
139: for update of RULESET_ID nowait;
140: begin

Line 227: update JTF_R_RULESETS_TL set

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: update JTF_R_RULESETS_TL set
228: NAME = X_NAME,
229: DESCRIPTION = X_DESCRIPTION,
230: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
231: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 246: delete from JTF_R_RULESETS_TL

242: procedure DELETE_ROW (
243: X_RULESET_ID in NUMBER
244: ) is
245: begin
246: delete from JTF_R_RULESETS_TL
247: where RULESET_ID = X_RULESET_ID;
248:
249: if (sql%notfound) then
250: raise no_data_found;

Line 264: delete from JTF_R_RULESETS_TL T

260:
261: procedure ADD_LANGUAGE
262: is
263: begin
264: delete from JTF_R_RULESETS_TL T
265: where not exists
266: (select NULL
267: from JTF_R_RULESETS_B B
268: where B.RULESET_ID = T.RULESET_ID

Line 271: update JTF_R_RULESETS_TL T set (

267: from JTF_R_RULESETS_B B
268: where B.RULESET_ID = T.RULESET_ID
269: );
270:
271: update JTF_R_RULESETS_TL T set (
272: NAME,
273: DESCRIPTION
274: ) = (select
275: B.NAME,

Line 277: from JTF_R_RULESETS_TL B

273: DESCRIPTION
274: ) = (select
275: B.NAME,
276: B.DESCRIPTION
277: from JTF_R_RULESETS_TL B
278: where B.RULESET_ID = T.RULESET_ID
279: and B.LANGUAGE = T.SOURCE_LANG)
280: where (
281: T.RULESET_ID,

Line 286: from JTF_R_RULESETS_TL SUBB, JTF_R_RULESETS_TL SUBT

282: T.LANGUAGE
283: ) in (select
284: SUBT.RULESET_ID,
285: SUBT.LANGUAGE
286: from JTF_R_RULESETS_TL SUBB, JTF_R_RULESETS_TL SUBT
287: where SUBB.RULESET_ID = SUBT.RULESET_ID
288: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
289: and (SUBB.NAME <> SUBT.NAME
290: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 295: insert into JTF_R_RULESETS_TL (

291: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
292: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
293: ));
294:
295: insert into JTF_R_RULESETS_TL (
296: DESCRIPTION,
297: OBJECT_VERSION_NUMBER,
298: LAST_UPDATED_BY,
299: LAST_UPDATE_DATE,

Line 319: from JTF_R_RULESETS_TL B, FND_LANGUAGES L

315: B.CREATED_BY,
316: B.CREATION_DATE,
317: L.LANGUAGE_CODE,
318: B.SOURCE_LANG
319: from JTF_R_RULESETS_TL B, FND_LANGUAGES L
320: where L.INSTALLED_FLAG in ('I', 'B')
321: and B.LANGUAGE = userenv('LANG')
322: and not exists
323: (select NULL

Line 324: from JTF_R_RULESETS_TL T

320: where L.INSTALLED_FLAG in ('I', 'B')
321: and B.LANGUAGE = userenv('LANG')
322: and not exists
323: (select NULL
324: from JTF_R_RULESETS_TL T
325: where T.RULESET_ID = B.RULESET_ID
326: and T.LANGUAGE = L.LANGUAGE_CODE);
327: end ADD_LANGUAGE;
328:

Line 336: update JTF_R_RULESETS_TL set

332: X_NAME in VARCHAR2,
333: X_DESCRIPTION in VARCHAR2
334: ) is
335: begin
336: update JTF_R_RULESETS_TL set
337: name = nvl(X_NAME, name),
338: description = nvl(X_DESCRIPTION, description),
339: last_update_date = sysdate,
340: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),