APPS.JTF_EVT_HANDLERS_PKG dependencies on JTF_EVT_HANDLERS_B

Line 17: cursor C is select ROWID from JTF_EVT_HANDLERS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from JTF_EVT_HANDLERS_B
18: where JTF_EVT_HANDLERS_ID = X_JTF_EVT_HANDLERS_ID
19: ;
20: begin
21: insert into JTF_EVT_HANDLERS_B (

Line 21: insert into JTF_EVT_HANDLERS_B (

17: cursor C is select ROWID from JTF_EVT_HANDLERS_B
18: where JTF_EVT_HANDLERS_ID = X_JTF_EVT_HANDLERS_ID
19: ;
20: begin
21: insert into JTF_EVT_HANDLERS_B (
22: JTF_EVT_HANDLERS_ID,
23: JTF_EVT_TYPES_ID,
24: JTF_EVT_HANDLERS_NAME,
25: JTF_EVT_HANDLERS_MTD_NAME,

Line 102: from JTF_EVT_HANDLERS_B

98: JTF_EVT_HANDLERS_NAME,
99: JTF_EVT_HANDLERS_MTD_NAME,
100: JTF_EVT_HANDLERS_SYNC_FLAG,
101: SECURITY_GROUP_ID
102: from JTF_EVT_HANDLERS_B
103: where JTF_EVT_HANDLERS_ID = X_JTF_EVT_HANDLERS_ID
104: for update of JTF_EVT_HANDLERS_ID nowait;
105: recinfo c%rowtype;
106:

Line 166: update JTF_EVT_HANDLERS_B set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update JTF_EVT_HANDLERS_B set
167: JTF_EVT_TYPES_ID = X_JTF_EVT_TYPES_ID,
168: JTF_EVT_HANDLERS_NAME = X_JTF_EVT_HANDLERS_NAME,
169: JTF_EVT_HANDLERS_MTD_NAME = X_JTF_EVT_HANDLERS_MTD_NAME,
170: JTF_EVT_HANDLERS_SYNC_FLAG = X_JTF_EVT_HANDLERS_SYNC_FLAG,

Line 206: delete from JTF_EVT_HANDLERS_B

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: delete from JTF_EVT_HANDLERS_B
207: where JTF_EVT_HANDLERS_ID = X_JTF_EVT_HANDLERS_ID;
208:
209: if (sql%notfound) then
210: raise no_data_found;

Line 220: from JTF_EVT_HANDLERS_B B

216: begin
217: delete from JTF_EVT_HANDLERS_TL T
218: where not exists
219: (select NULL
220: from JTF_EVT_HANDLERS_B B
221: where B.JTF_EVT_HANDLERS_ID = T.JTF_EVT_HANDLERS_ID
222: );
223:
224: update JTF_EVT_HANDLERS_TL T set (