APPS.JTF_RS_ACTIVE_GRP_MBRS_PKG dependencies on JTF_RS_ACTIVE_GRP_MBRS

Line 1: package body JTF_RS_ACTIVE_GRP_MBRS_PKG as

1: package body JTF_RS_ACTIVE_GRP_MBRS_PKG as
2: /* $Header: jtfrshab.pls 120.0 2005/05/11 08:20:05 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_GROUP_MEMBER_ID in NUMBER,

Line 15: cursor C is select ROWID from JTF_RS_ACTIVE_GRP_MBRS

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from JTF_RS_ACTIVE_GRP_MBRS
16: where GROUP_MEMBER_ID = X_GROUP_MEMBER_ID
17: ;
18: begin
19: insert into JTF_RS_ACTIVE_GRP_MBRS (

Line 19: insert into JTF_RS_ACTIVE_GRP_MBRS (

15: cursor C is select ROWID from JTF_RS_ACTIVE_GRP_MBRS
16: where GROUP_MEMBER_ID = X_GROUP_MEMBER_ID
17: ;
18: begin
19: insert into JTF_RS_ACTIVE_GRP_MBRS (
20: OBJECT_VERSION_NUMBER,
21: GROUP_MEMBER_ID,
22: GROUP_ID,
23: RESOURCE_ID,

Line 60: from JTF_RS_ACTIVE_GRP_MBRS

56: ) is
57: cursor c is select
58: OBJECT_VERSION_NUMBER,
59: GROUP_MEMBER_ID
60: from JTF_RS_ACTIVE_GRP_MBRS
61: where GROUP_MEMBER_ID = X_GROUP_MEMBER_ID
62: for update of GROUP_MEMBER_ID nowait;
63: recinfo c%rowtype;
64:

Line 97: update JTF_RS_ACTIVE_GRP_MBRS set

93: X_LAST_UPDATED_BY in NUMBER,
94: X_LAST_UPDATE_LOGIN in NUMBER
95: ) is
96: begin
97: update JTF_RS_ACTIVE_GRP_MBRS set
98: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
99: GROUP_MEMBER_ID = X_GROUP_MEMBER_ID,
100: RESOURCE_ID = X_RESOURCE_ID,
101: PERSON_ID = X_PERSON_ID,

Line 117: delete from JTF_RS_ACTIVE_GRP_MBRS

113: procedure DELETE_ROW (
114: X_GROUP_MEMBER_ID in NUMBER
115: ) is
116: begin
117: delete from JTF_RS_ACTIVE_GRP_MBRS
118: where GROUP_MEMBER_ID = X_GROUP_MEMBER_ID;
119:
120: if (sql%notfound) then
121: raise no_data_found;

Line 125: end JTF_RS_ACTIVE_GRP_MBRS_PKG;

121: raise no_data_found;
122: end if;
123: end DELETE_ROW;
124:
125: end JTF_RS_ACTIVE_GRP_MBRS_PKG;