APPS.JTF_RS_RESOURCE_PARAMS_PKG dependencies on JTF_RS_RESOURCE_PARAMS

Line 1: package body JTF_RS_RESOURCE_PARAMS_PKG as

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

Line 34: cursor C is select ROWID from JTF_RS_RESOURCE_PARAMS

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_RESOURCE_PARAMS
35: where RESOURCE_PARAM_ID = X_RESOURCE_PARAM_ID
36: ;
37: begin
38: insert into JTF_RS_RESOURCE_PARAMS (

Line 38: insert into JTF_RS_RESOURCE_PARAMS (

34: cursor C is select ROWID from JTF_RS_RESOURCE_PARAMS
35: where RESOURCE_PARAM_ID = X_RESOURCE_PARAM_ID
36: ;
37: begin
38: insert into JTF_RS_RESOURCE_PARAMS (
39: RESOURCE_PARAM_ID,
40: NAME,
41: TYPE,
42: LENGTH,

Line 115: from JTF_RS_RESOURCE_PARAMS

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

Line 169: update JTF_RS_RESOURCE_PARAMS set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update JTF_RS_RESOURCE_PARAMS set
170: NAME = X_NAME,
171: TYPE = X_TYPE,
172: LENGTH = X_LENGTH,
173: DOMAIN_LOOKUP_TYPE = X_DOMAIN_LOOKUP_TYPE,

Line 207: delete from JTF_RS_RESOURCE_PARAMS

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

Line 216: end JTF_RS_RESOURCE_PARAMS_PKG;

212: end if;
213:
214: end DELETE_ROW;
215:
216: end JTF_RS_RESOURCE_PARAMS_PKG;