APPS.JTF_RS_GRP_RELATIONS_PKG dependencies on JTF_RS_GRP_RELATIONS

Line 1: package body JTF_RS_GRP_RELATIONS_PKG as

1: package body JTF_RS_GRP_RELATIONS_PKG as
2: /* $Header: jtfrstob.pls 120.0 2005/05/11 08:22:27 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_GROUP_RELATE_ID in NUMBER,

Line 34: cursor C is select ROWID from JTF_RS_GRP_RELATIONS

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from JTF_RS_GRP_RELATIONS
35: where GROUP_RELATE_ID = X_GROUP_RELATE_ID
36: ;
37: begin
38: insert into JTF_RS_GRP_RELATIONS (

Line 38: insert into JTF_RS_GRP_RELATIONS (

34: cursor C is select ROWID from JTF_RS_GRP_RELATIONS
35: where GROUP_RELATE_ID = X_GROUP_RELATE_ID
36: ;
37: begin
38: insert into JTF_RS_GRP_RELATIONS (
39: GROUP_RELATE_ID,
40: GROUP_ID,
41: RELATED_GROUP_ID,
42: RELATION_TYPE,

Line 115: from JTF_RS_GRP_RELATIONS

111: X_OBJECT_VERSION_NUMBER in NUMBER
112: ) is
113: cursor c1 is select
114: OBJECT_VERSION_NUMBER
115: from JTF_RS_GRP_RELATIONS
116: where GROUP_RELATE_ID = X_GROUP_RELATE_ID
117: for update of GROUP_RELATE_ID nowait;
118: tlinfo c1%rowtype ;
119: begin

Line 169: update JTF_RS_GRP_RELATIONS set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update JTF_RS_GRP_RELATIONS set
170: GROUP_ID = X_GROUP_ID,
171: RELATED_GROUP_ID = X_RELATED_GROUP_ID,
172: RELATION_TYPE = X_RELATION_TYPE,
173: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 207: delete from JTF_RS_GRP_RELATIONS

203: procedure DELETE_ROW (
204: X_GROUP_RELATE_ID in NUMBER
205: ) is
206: begin
207: delete from JTF_RS_GRP_RELATIONS
208: where GROUP_RELATE_ID = X_GROUP_RELATE_ID;
209:
210: if (sql%notfound) then
211: raise no_data_found;

Line 220: update JTF_RS_GRP_RELATIONS set

216: procedure LOGICAL_DELETE_ROW (
217: X_GROUP_RELATE_ID in NUMBER
218: ) is
219: begin
220: update JTF_RS_GRP_RELATIONS set
221: DELETE_FLAG = 'Y'
222: where GROUP_RELATE_ID = X_GROUP_RELATE_ID;
223:
224: if (sql%notfound) then

Line 231: end JTF_RS_GRP_RELATIONS_PKG;

227:
228: end LOGICAL_DELETE_ROW;
229:
230:
231: end JTF_RS_GRP_RELATIONS_PKG;