APPS.JTF_DPF_RULES_PKG dependencies on JTF_DPF_RULES_B

Line 16: cursor C is select ROWID from JTF_DPF_RULES_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from JTF_DPF_RULES_B
17: where RULE_ID = X_RULE_ID
18: ;
19: begin
20: insert into JTF_DPF_RULES_B (

Line 20: insert into JTF_DPF_RULES_B (

16: cursor C is select ROWID from JTF_DPF_RULES_B
17: where RULE_ID = X_RULE_ID
18: ;
19: begin
20: insert into JTF_DPF_RULES_B (
21: APPLICATION_ID,
22: OBJECT_VERSION_NUMBER,
23: RULE_ID,
24: RULE_NAME,

Line 89: from JTF_DPF_RULES_B

85: cursor c is select
86: APPLICATION_ID,
87: OBJECT_VERSION_NUMBER,
88: RULE_NAME
89: from JTF_DPF_RULES_B
90: where RULE_ID = X_RULE_ID
91: for update of RULE_ID nowait;
92: recinfo c%rowtype;
93:

Line 146: update JTF_DPF_RULES_B set

142: X_LAST_UPDATED_BY in NUMBER,
143: X_LAST_UPDATE_LOGIN in NUMBER
144: ) is
145: begin
146: update JTF_DPF_RULES_B set
147: APPLICATION_ID = X_APPLICATION_ID,
148: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
149: RULE_NAME = X_RULE_NAME,
150: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 184: delete from JTF_DPF_RULES_B

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: delete from JTF_DPF_RULES_B
185: where RULE_ID = X_RULE_ID;
186:
187: if (sql%notfound) then
188: raise no_data_found;

Line 198: from JTF_DPF_RULES_B B

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
200: );
201:
202: update JTF_DPF_RULES_TL T set (

Line 278: cursor c is select rule_id from jtf_dpf_rules_b

274: X_NUM_PARAMS IN VARCHAR2,
275: X_OWNER in VARCHAR2
276: ) is
277: -- select instances of this rule, identified by appid and name
278: cursor c is select rule_id from jtf_dpf_rules_b
279: where application_id = x_application_id and
280: rule_name=x_rule_name;
281:
282: t_old_rule_id number;

Line 301: -- select max(rule_id) into t_new_rule_id from jtf_dpf_rules_b

297:
298: -- get a new pseudo-sequence number
299: -- arsingh: prevent use of same id by different threads.
300: select JTF_DPF_RULES_S.nextval into t_new_rule_id from dual;
301: -- select max(rule_id) into t_new_rule_id from jtf_dpf_rules_b
302: -- where rule_id<10000;
303: -- if t_new_rule_id is null then
304: -- t_new_rule_id := 1;
305: -- else

Line 413: select rule_id from jtf_dpf_rules_b

409: x_rule_name varchar2,
410: x_application_id in varchar2
411: ) return number is
412: cursor c1(p_rule_name varchar2, p_application_id number) is
413: select rule_id from jtf_dpf_rules_b
414: where rule_name = p_rule_name and application_id = p_application_id;
415: retval number := null;
416: begin
417: open c1(x_rule_name, x_application_id);