APPS.JTF_TASK_RSC_REQS_PKG dependencies on JTF_TASK_RSC_REQS

Line 1: PACKAGE body JTF_TASK_RSC_REQS_PKG as

1: PACKAGE body JTF_TASK_RSC_REQS_PKG as
2: /* $Header: jtftkrqb.pls 115.15 2002/12/04 22:04:41 cjang ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_RESOURCE_REQ_ID in NUMBER,

Line 34: cursor C is select ROWID from JTF_TASK_RSC_REQS

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_TASK_RSC_REQS
35: where RESOURCE_REQ_ID = X_RESOURCE_REQ_ID
36: ;
37: begin
38: insert into JTF_TASK_RSC_REQS (

Line 38: insert into JTF_TASK_RSC_REQS (

34: cursor C is select ROWID from JTF_TASK_RSC_REQS
35: where RESOURCE_REQ_ID = X_RESOURCE_REQ_ID
36: ;
37: begin
38: insert into JTF_TASK_RSC_REQS (
39: RESOURCE_REQ_ID,
40: CREATED_BY,
41: CREATION_DATE,
42: LAST_UPDATED_BY,

Line 115: from JTF_TASK_RSC_REQS

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

Line 169: update JTF_TASK_RSC_REQS set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update JTF_TASK_RSC_REQS set
170: TASK_TYPE_ID = X_TASK_TYPE_ID,
171: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
172: TASK_ID = X_TASK_ID,
173: TASK_TEMPLATE_ID = X_TASK_TEMPLATE_ID,

Line 207: delete from JTF_TASK_RSC_REQS

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

Line 217: end JTF_TASK_RSC_REQS_PKG;

213:
214: end DELETE_ROW;
215:
216:
217: end JTF_TASK_RSC_REQS_PKG;