APPS.JTF_OBJECT_PARAM_PKG dependencies on JTF_OBJECT_PG_PARAMS

Line 14: l_PARAMETER_ID jtf_object_pg_params.parameter_id%type;

10: X_LAST_UPDATE_DATE IN DATE,
11: X_LAST_UPDATE_LOGIN IN NUMBER)
12: is
13:
14: l_PARAMETER_ID jtf_object_pg_params.parameter_id%type;
15: cursor c is
16: select ROWID from jtf_object_pg_params
17: where parameter_id=l_PARAMETER_ID;
18:

Line 16: select ROWID from jtf_object_pg_params

12: is
13:
14: l_PARAMETER_ID jtf_object_pg_params.parameter_id%type;
15: cursor c is
16: select ROWID from jtf_object_pg_params
17: where parameter_id=l_PARAMETER_ID;
18:
19:
20: begin

Line 22: INSERT INTO JTF_OBJECT_PG_PARAMS

18:
19:
20: begin
21:
22: INSERT INTO JTF_OBJECT_PG_PARAMS
23: ( PARAMETER_ID ,
24: OBJECT_DTLS_ID ,
25: SOURCE_PARAM ,
26: DEST_PARAM ,

Line 35: JTF_OBJECT_PG_PARAMS_S.NEXTVAL,

31: LAST_UPDATE_LOGIN ,
32: OBJECT_VERSION_NUMBER )
33: VALUES
34: (
35: JTF_OBJECT_PG_PARAMS_S.NEXTVAL,
36: X_OBJECT_DTLS_ID ,
37: X_SOURCE_PARAM ,
38: X_DEST_PARAM ,
39: X_CREATION_DATE,

Line 64: from jtf_object_pg_params

60: X_OBJECT_VERSION_NUMBER in NUMBER
61: ) is
62: cursor c is select
63: OBJECT_VERSION_NUMBER
64: from jtf_object_pg_params
65: where parameter_id= X_PARAMETER_ID
66: for update of PARAMETER_ID nowait;
67: recinfo c%rowtype;
68:

Line 101: l_object_version_number jtf_object_pg_params.object_version_number%type;

97: X_LAST_UPDATE_LOGIN IN NUMBER,
98: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
99: ) is
100:
101: l_object_version_number jtf_object_pg_params.object_version_number%type;
102: begin
103:
104:
105:

Line 106: UPDATE JTF_OBJECT_PG_PARAMS A

102: begin
103:
104:
105:
106: UPDATE JTF_OBJECT_PG_PARAMS A
107: SET
108: A.SOURCE_PARAM = X_SOURCE_PARAM
109: , A.DEST_PARAM = X_DEST_PARAM
110: , A.LAST_UPDATED_BY = X_LAST_UPDATED_BY

Line 133: delete from JTF_OBJECT_PG_PARAMS

129:
130: begin
131:
132:
133: delete from JTF_OBJECT_PG_PARAMS
134: where PARAMETER_ID = X_PARAMETER_ID
135: and object_version_number=X_OBJECT_VERSION_NUMBER ;
136:
137: if (sql%notfound) then