APPS.JTF_DPF_RULES_PKG dependencies on JTF_DPF_RULES_TL

Line 42: insert into JTF_DPF_RULES_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into JTF_DPF_RULES_TL (
43: LAST_UPDATED_BY,
44: LAST_UPDATE_LOGIN,
45: RULE_ID,
46: RULE_DESCRIPTION,

Line 64: from JTF_DPF_RULES_TL T

60: from FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and not exists
63: (select NULL
64: from JTF_DPF_RULES_TL T
65: where T.RULE_ID = X_RULE_ID
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:
68: open c;

Line 97: from JTF_DPF_RULES_TL

93:
94: cursor c1 is select
95: RULE_DESCRIPTION,
96: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
97: from JTF_DPF_RULES_TL
98: where RULE_ID = X_RULE_ID
99: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
100: for update of RULE_ID nowait;
101: begin

Line 159: update JTF_DPF_RULES_TL set

155: if (sql%notfound) then
156: raise no_data_found;
157: end if;
158:
159: update JTF_DPF_RULES_TL set
160: RULE_DESCRIPTION = X_RULE_DESCRIPTION,
161: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
162: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
163: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 177: delete from JTF_DPF_RULES_TL

173: procedure DELETE_ROW (
174: X_RULE_ID in NUMBER
175: ) is
176: begin
177: delete from JTF_DPF_RULES_TL
178: where RULE_ID = X_RULE_ID;
179:
180: if (sql%notfound) then
181: raise no_data_found;

Line 195: delete from JTF_DPF_RULES_TL T

191:
192: procedure ADD_LANGUAGE
193: is
194: begin
195: delete from JTF_DPF_RULES_TL T
196: where not exists
197: (select NULL
198: from JTF_DPF_RULES_B B
199: where B.RULE_ID = T.RULE_ID

Line 202: update JTF_DPF_RULES_TL T set (

198: from JTF_DPF_RULES_B B
199: where B.RULE_ID = T.RULE_ID
200: );
201:
202: update JTF_DPF_RULES_TL T set (
203: RULE_DESCRIPTION
204: ) = (select
205: B.RULE_DESCRIPTION
206: from JTF_DPF_RULES_TL B

Line 206: from JTF_DPF_RULES_TL B

202: update JTF_DPF_RULES_TL T set (
203: RULE_DESCRIPTION
204: ) = (select
205: B.RULE_DESCRIPTION
206: from JTF_DPF_RULES_TL B
207: where B.RULE_ID = T.RULE_ID
208: and B.LANGUAGE = T.SOURCE_LANG)
209: where (
210: T.RULE_ID,

Line 215: from JTF_DPF_RULES_TL SUBB, JTF_DPF_RULES_TL SUBT

211: T.LANGUAGE
212: ) in (select
213: SUBT.RULE_ID,
214: SUBT.LANGUAGE
215: from JTF_DPF_RULES_TL SUBB, JTF_DPF_RULES_TL SUBT
216: where SUBB.RULE_ID = SUBT.RULE_ID
217: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
218: and (SUBB.RULE_DESCRIPTION <> SUBT.RULE_DESCRIPTION
219: or (SUBB.RULE_DESCRIPTION is null and SUBT.RULE_DESCRIPTION is not null)

Line 223: insert into JTF_DPF_RULES_TL (

219: or (SUBB.RULE_DESCRIPTION is null and SUBT.RULE_DESCRIPTION is not null)
220: or (SUBB.RULE_DESCRIPTION is not null and SUBT.RULE_DESCRIPTION is null)
221: ));
222:
223: insert into JTF_DPF_RULES_TL (
224: LAST_UPDATED_BY,
225: LAST_UPDATE_LOGIN,
226: RULE_ID,
227: RULE_DESCRIPTION,

Line 241: from JTF_DPF_RULES_TL B, FND_LANGUAGES L

237: B.CREATED_BY,
238: B.LAST_UPDATE_DATE,
239: L.LANGUAGE_CODE,
240: B.SOURCE_LANG
241: from JTF_DPF_RULES_TL B, FND_LANGUAGES L
242: where L.INSTALLED_FLAG in ('I', 'B')
243: and B.LANGUAGE = userenv('LANG')
244: and not exists
245: (select NULL

Line 246: from JTF_DPF_RULES_TL T

242: where L.INSTALLED_FLAG in ('I', 'B')
243: and B.LANGUAGE = userenv('LANG')
244: and not exists
245: (select NULL
246: from JTF_DPF_RULES_TL T
247: where T.RULE_ID = B.RULE_ID
248: and T.LANGUAGE = L.LANGUAGE_CODE);
249: end ADD_LANGUAGE;
250:

Line 264: update jtf_dpf_rules_tl set

260: if x_owner = 'SEED' then l_user_id := 1; end if;
261:
262: l_rule_id := find(x_rule_name, x_application_id);
263:
264: update jtf_dpf_rules_tl set
265: rule_description = x_rule_description
266: where userenv('LANG') in (LANGUAGE, SOURCE_LANG) and
267: rule_id = l_rule_id;
268: end;