APPS.JTF_R_RULES_PKG dependencies on JTF_R_RULES_TL

Line 53: insert into JTF_R_RULES_TL (

49: X_LAST_UPDATED_BY,
50: X_LAST_UPDATE_LOGIN
51: );
52:
53: insert into JTF_R_RULES_TL (
54: RULE_ID,
55: CREATED_BY,
56: CREATION_DATE,
57: LAST_UPDATED_BY,

Line 83: from JTF_R_RULES_TL T

79: from FND_LANGUAGES L
80: where L.INSTALLED_FLAG in ('I', 'B')
81: and not exists
82: (select NULL
83: from JTF_R_RULES_TL T
84: where T.RULE_ID = X_RULE_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: open c;

Line 126: from JTF_R_RULES_TL

122: NAME,
123: COND_DESC,
124: ACTION_DESC,
125: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
126: from JTF_R_RULES_TL
127: where RULE_ID = X_RULE_ID
128: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
129: for update of RULE_ID nowait;
130: begin

Line 206: update JTF_R_RULES_TL set

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: update JTF_R_RULES_TL set
207: NAME = X_NAME,
208: COND_DESC = X_COND_DESC,
209: ACTION_DESC = X_ACTION_DESC,
210: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 226: delete from JTF_R_RULES_TL

222: procedure DELETE_ROW (
223: X_RULE_ID in NUMBER
224: ) is
225: begin
226: delete from JTF_R_RULES_TL
227: where RULE_ID = X_RULE_ID;
228:
229: if (sql%notfound) then
230: raise no_data_found;

Line 244: delete from JTF_R_RULES_TL T

240:
241: procedure ADD_LANGUAGE
242: is
243: begin
244: delete from JTF_R_RULES_TL T
245: where not exists
246: (select NULL
247: from JTF_R_RULES_B B
248: where B.RULE_ID = T.RULE_ID

Line 251: update JTF_R_RULES_TL T set (

247: from JTF_R_RULES_B B
248: where B.RULE_ID = T.RULE_ID
249: );
250:
251: update JTF_R_RULES_TL T set (
252: NAME,
253: COND_DESC,
254: ACTION_DESC
255: ) = (select

Line 259: from JTF_R_RULES_TL B

255: ) = (select
256: B.NAME,
257: B.COND_DESC,
258: B.ACTION_DESC
259: from JTF_R_RULES_TL B
260: where B.RULE_ID = T.RULE_ID
261: and B.LANGUAGE = T.SOURCE_LANG)
262: where (
263: T.RULE_ID,

Line 268: from JTF_R_RULES_TL SUBB, JTF_R_RULES_TL SUBT

264: T.LANGUAGE
265: ) in (select
266: SUBT.RULE_ID,
267: SUBT.LANGUAGE
268: from JTF_R_RULES_TL SUBB, JTF_R_RULES_TL SUBT
269: where SUBB.RULE_ID = SUBT.RULE_ID
270: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
271: and (SUBB.NAME <> SUBT.NAME
272: or SUBB.COND_DESC <> SUBT.COND_DESC

Line 280: insert into JTF_R_RULES_TL (

276: or (SUBB.ACTION_DESC is null and SUBT.ACTION_DESC is not null)
277: or (SUBB.ACTION_DESC is not null and SUBT.ACTION_DESC is null)
278: ));
279:
280: insert into JTF_R_RULES_TL (
281: RULE_ID,
282: CREATED_BY,
283: CREATION_DATE,
284: LAST_UPDATED_BY,

Line 306: from JTF_R_RULES_TL B, FND_LANGUAGES L

302: B.ACTION_DESC,
303: B.OBJECT_VERSION_NUMBER,
304: L.LANGUAGE_CODE,
305: B.SOURCE_LANG
306: from JTF_R_RULES_TL B, FND_LANGUAGES L
307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL

Line 311: from JTF_R_RULES_TL T

307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL
311: from JTF_R_RULES_TL T
312: where T.RULE_ID = B.RULE_ID
313: and T.LANGUAGE = L.LANGUAGE_CODE);
314: end ADD_LANGUAGE;
315:

Line 324: update JTF_R_RULES_TL set

320: X_COND_DESC in VARCHAR2,
321: X_ACTION_DESC in VARCHAR2
322: ) is
323: begin
324: update JTF_R_RULES_TL set
325: name = nvl(X_NAME, name),
326: cond_desc = nvl(X_COND_DESC, cond_desc),
327: action_desc = nvl(X_ACTION_DESC, action_desc),
328: last_update_date = sysdate,