APPS.JTF_R_RULES_PKG dependencies on JTF_R_RULES_B

Line 21: cursor C is select ROWID from JTF_R_RULES_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from JTF_R_RULES_B
22: where RULE_ID = X_RULE_ID
23: ;
24: begin
25: insert into JTF_R_RULES_B (

Line 25: insert into JTF_R_RULES_B (

21: cursor C is select ROWID from JTF_R_RULES_B
22: where RULE_ID = X_RULE_ID
23: ;
24: begin
25: insert into JTF_R_RULES_B (
26: START_DATE,
27: END_DATE,
28: PRIORITY,
29: OBJECT_VERSION_NUMBER,

Line 116: from JTF_R_RULES_B

112: PRIORITY,
113: OBJECT_VERSION_NUMBER,
114: RULESET_ID,
115: STATUS
116: from JTF_R_RULES_B
117: where RULE_ID = X_RULE_ID
118: for update of RULE_ID nowait;
119: recinfo c%rowtype;
120:

Line 190: update JTF_R_RULES_B set

186: X_LAST_UPDATED_BY in NUMBER,
187: X_LAST_UPDATE_LOGIN in NUMBER
188: ) is
189: begin
190: update JTF_R_RULES_B set
191: START_DATE = X_START_DATE,
192: END_DATE = X_END_DATE,
193: PRIORITY = X_PRIORITY,
194: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 233: delete from JTF_R_RULES_B

229: if (sql%notfound) then
230: raise no_data_found;
231: end if;
232:
233: delete from JTF_R_RULES_B
234: where RULE_ID = X_RULE_ID;
235:
236: if (sql%notfound) then
237: raise no_data_found;

Line 247: from JTF_R_RULES_B B

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
249: );
250:
251: update JTF_R_RULES_TL T set (