APPS.JTF_RS_GROUPS_AUD_PKG dependencies on JTF_RS_GROUPS_AUD_B

Line 31: cursor C is select ROWID from JTF_RS_GROUPS_AUD_B

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from JTF_RS_GROUPS_AUD_B
32: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
33: ;
34: begin
35: insert into JTF_RS_GROUPS_AUD_B (

Line 35: insert into JTF_RS_GROUPS_AUD_B (

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

Line 163: from JTF_RS_GROUPS_AUD_B

159: NEW_ACCOUNTING_CODE,
160: OLD_ACCOUNTING_CODE,
161: NEW_OBJECT_VERSION_NUMBER,
162: OLD_OBJECT_VERSION_NUMBER
163: from JTF_RS_GROUPS_AUD_B
164: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
165: for update of GROUP_AUDIT_ID nowait;
166: recinfo c%rowtype;
167:

Line 270: update JTF_RS_GROUPS_AUD_B set

266: X_LAST_UPDATED_BY in NUMBER,
267: X_LAST_UPDATE_LOGIN in NUMBER
268: ) is
269: begin
270: update JTF_RS_GROUPS_AUD_B set
271: GROUP_ID = X_GROUP_ID,
272: NEW_GROUP_NUMBER = X_NEW_GROUP_NUMBER,
273: OLD_GROUP_NUMBER = X_OLD_GROUP_NUMBER,
274: NEW_EMAIL_ADDRESS = X_NEW_EMAIL_ADDRESS,

Line 323: delete from JTF_RS_GROUPS_AUD_B

319: if (sql%notfound) then
320: raise no_data_found;
321: end if;
322:
323: delete from JTF_RS_GROUPS_AUD_B
324: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 337: from JTF_RS_GROUPS_AUD_B B

333: begin
334: delete from JTF_RS_GROUPS_AUD_TL T
335: where not exists
336: (select NULL
337: from JTF_RS_GROUPS_AUD_B B
338: where B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID
339: );
340:
341: update JTF_RS_GROUPS_AUD_TL T set (