APPS.JTF_EVT_TYPES_PKG dependencies on JTF_EVT_TYPES_B

Line 14: cursor C is select ROWID from JTF_EVT_TYPES_B

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from JTF_EVT_TYPES_B
15: where JTF_EVT_TYPES_ID = X_JTF_EVT_TYPES_ID
16: ;
17: begin
18: insert into JTF_EVT_TYPES_B (

Line 18: insert into JTF_EVT_TYPES_B (

14: cursor C is select ROWID from JTF_EVT_TYPES_B
15: where JTF_EVT_TYPES_ID = X_JTF_EVT_TYPES_ID
16: ;
17: begin
18: insert into JTF_EVT_TYPES_B (
19: SECURITY_GROUP_ID,
20: JTF_EVT_TYPES_ID,
21: JTF_EVT_TYPES_NAME,
22: CREATION_DATE,

Line 87: from JTF_EVT_TYPES_B

83: ) is
84: cursor c is select
85: SECURITY_GROUP_ID,
86: JTF_EVT_TYPES_NAME
87: from JTF_EVT_TYPES_B
88: where JTF_EVT_TYPES_ID = X_JTF_EVT_TYPES_ID
89: for update of JTF_EVT_TYPES_ID nowait;
90: recinfo c%rowtype;
91:

Line 143: update JTF_EVT_TYPES_B set

139: X_LAST_UPDATED_BY in NUMBER,
140: X_LAST_UPDATE_LOGIN in NUMBER
141: ) is
142: begin
143: update JTF_EVT_TYPES_B set
144: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
145: JTF_EVT_TYPES_NAME = X_JTF_EVT_TYPES_NAME,
146: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
147: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 180: delete from JTF_EVT_TYPES_B

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: delete from JTF_EVT_TYPES_B
181: where JTF_EVT_TYPES_ID = X_JTF_EVT_TYPES_ID;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 194: from JTF_EVT_TYPES_B B

190: begin
191: delete from JTF_EVT_TYPES_TL T
192: where not exists
193: (select NULL
194: from JTF_EVT_TYPES_B B
195: where B.JTF_EVT_TYPES_ID = T.JTF_EVT_TYPES_ID
196: );
197:
198: update JTF_EVT_TYPES_TL T set (