eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_R_RULESETS_PKG dependencies on JTF_R_RULESETS_B

Line 23: cursor C is select ROWID from JTF_R_RULESETS_B

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from JTF_R_RULESETS_B
24: where RULESET_ID = X_RULESET_ID
25: ;
26: begin
27: insert into JTF_R_RULESETS_B (

Line 27: insert into JTF_R_RULESETS_B (

23: cursor C is select ROWID from JTF_R_RULESETS_B
24: where RULESET_ID = X_RULESET_ID
25: ;
26: begin
27: insert into JTF_R_RULESETS_B (
28: RULESET_ID,
29: APPLICATION_ID,
30: STATUS,
31: IBA_SORT_BY_CODE,

Line 127: from JTF_R_RULESETS_B

123: RULESET_CLASS,
124: RULESET_SER,
125: OBJECT_VERSION_NUMBER,
126: IBA_SORT_ORDER
127: from JTF_R_RULESETS_B
128: where RULESET_ID = X_RULESET_ID
129: for update of RULESET_ID nowait;
130: recinfo c%rowtype;
131:

Line 208: update JTF_R_RULESETS_B set

204: X_LAST_UPDATED_BY in NUMBER,
205: X_LAST_UPDATE_LOGIN in NUMBER
206: ) is
207: begin
208: update JTF_R_RULESETS_B set
209: APPLICATION_ID = X_APPLICATION_ID,
210: STATUS = X_STATUS,
211: IBA_SORT_BY_CODE = X_IBA_SORT_BY_CODE,
212: START_DATE = X_START_DATE,

Line 253: delete from JTF_R_RULESETS_B

249: if (sql%notfound) then
250: raise no_data_found;
251: end if;
252:
253: delete from JTF_R_RULESETS_B
254: where RULESET_ID = X_RULESET_ID;
255:
256: if (sql%notfound) then
257: raise no_data_found;

Line 267: from JTF_R_RULESETS_B B

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
269: );
270:
271: update JTF_R_RULESETS_TL T set (