APPS.JTF_RS_GROUPS_AUD_PKG dependencies on JTF_RS_GROUPS_AUD_B

Line 33: cursor C is select ROWID from JTF_RS_GROUPS_AUD_B

29: X_LAST_UPDATE_LOGIN in NUMBER,
30: X_NEW_TIME_ZONE in NUMBER,
31: X_OLD_TIME_ZONE in NUMBER
32: ) is
33: cursor C is select ROWID from JTF_RS_GROUPS_AUD_B
34: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
35: ;
36: begin
37: insert into JTF_RS_GROUPS_AUD_B (

Line 37: insert into JTF_RS_GROUPS_AUD_B (

33: cursor C is select ROWID from JTF_RS_GROUPS_AUD_B
34: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
35: ;
36: begin
37: insert into JTF_RS_GROUPS_AUD_B (
38: GROUP_AUDIT_ID,
39: GROUP_ID,
40: NEW_GROUP_NUMBER,
41: OLD_GROUP_NUMBER,

Line 173: from JTF_RS_GROUPS_AUD_B

169: NEW_OBJECT_VERSION_NUMBER,
170: OLD_OBJECT_VERSION_NUMBER,
171: NEW_TIME_ZONE,
172: OLD_TIME_ZONE
173: from JTF_RS_GROUPS_AUD_B
174: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
175: for update of GROUP_AUDIT_ID nowait;
176: recinfo c%rowtype;
177:

Line 286: update JTF_RS_GROUPS_AUD_B set

282: X_NEW_TIME_ZONE in NUMBER,
283: X_OLD_TIME_ZONE in NUMBER
284: ) is
285: begin
286: update JTF_RS_GROUPS_AUD_B set
287: GROUP_ID = X_GROUP_ID,
288: NEW_GROUP_NUMBER = X_NEW_GROUP_NUMBER,
289: OLD_GROUP_NUMBER = X_OLD_GROUP_NUMBER,
290: NEW_EMAIL_ADDRESS = X_NEW_EMAIL_ADDRESS,

Line 341: delete from JTF_RS_GROUPS_AUD_B

337: if (sql%notfound) then
338: raise no_data_found;
339: end if;
340:
341: delete from JTF_RS_GROUPS_AUD_B
342: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID;
343:
344: if (sql%notfound) then
345: raise no_data_found;

Line 355: from JTF_RS_GROUPS_AUD_B B

351: begin
352: delete from JTF_RS_GROUPS_AUD_TL T
353: where not exists
354: (select NULL
355: from JTF_RS_GROUPS_AUD_B B
356: where B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID
357: );
358:
359: update JTF_RS_GROUPS_AUD_TL T set (