APPS.JTF_RS_RES_AVAILABILITY_PKG dependencies on JTF_RS_RES_AVAILABILITY

Line 1: package body JTF_RS_RES_AVAILABILITY_PKG as

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

Line 36: cursor C is select ROWID from JTF_RS_RES_AVAILABILITY

32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from JTF_RS_RES_AVAILABILITY
37: where AVAILABILITY_ID = X_AVAILABILITY_ID
38: ;
39: begin
40: insert into JTF_RS_RES_AVAILABILITY (

Line 40: insert into JTF_RS_RES_AVAILABILITY (

36: cursor C is select ROWID from JTF_RS_RES_AVAILABILITY
37: where AVAILABILITY_ID = X_AVAILABILITY_ID
38: ;
39: begin
40: insert into JTF_RS_RES_AVAILABILITY (
41: AVAILABILITY_ID,
42: RESOURCE_ID,
43: AVAILABLE_FLAG,
44: REASON_CODE,

Line 119: from JTF_RS_RES_AVAILABILITY

115: X_OBJECT_VERSION_NUMBER in NUMBER
116: ) is
117: cursor c is select
118: OBJECT_VERSION_NUMBER
119: from JTF_RS_RES_AVAILABILITY
120: where AVAILABILITY_ID = X_AVAILABILITY_ID
121: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
122: for update of AVAILABILITY_ID nowait;
123: recinfo c%rowtype;

Line 174: update JTF_RS_RES_AVAILABILITY set

170: X_LAST_UPDATE_DATE in DATE,
171: X_LAST_UPDATE_LOGIN in NUMBER
172: ) is
173: begin
174: update JTF_RS_RES_AVAILABILITY set
175: RESOURCE_ID = X_RESOURCE_ID,
176: AVAILABLE_FLAG = X_AVAILABLE_FLAG,
177: REASON_CODE = X_REASON_CODE,
178: START_DATE = X_START_DATE,

Line 213: delete from JTF_RS_RES_AVAILABILITY

209: procedure DELETE_ROW (
210: X_AVAILABILITY_ID in NUMBER
211: ) is
212: begin
213: delete from JTF_RS_RES_AVAILABILITY
214: where AVAILABILITY_ID = X_AVAILABILITY_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 223: end JTF_RS_RES_AVAILABILITY_PKG;

219:
220: end DELETE_ROW;
221:
222:
223: end JTF_RS_RES_AVAILABILITY_PKG;