APPS.JTF_LOC_HIERARCHIES_PKG dependencies on JTF_LOC_HIERARCHIES_B

Line 35: cursor c is select ROWID from JTF_LOC_HIERARCHIES_B

31: X_CREATED_BY in NUMBER,
32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER) is
35: cursor c is select ROWID from JTF_LOC_HIERARCHIES_B
36: where LOCATION_HIERARCHY_ID = X_LOCATION_HIERARCHY_ID
37: ;
38: begin
39: insert into JTF_LOC_HIERARCHIES_B (

Line 39: insert into JTF_LOC_HIERARCHIES_B (

35: cursor c is select ROWID from JTF_LOC_HIERARCHIES_B
36: where LOCATION_HIERARCHY_ID = X_LOCATION_HIERARCHY_ID
37: ;
38: begin
39: insert into JTF_LOC_HIERARCHIES_B (
40: LOCATION_HIERARCHY_ID,
41: OBJECT_VERSION_NUMBER,
42: REQUEST_ID,
43: PROGRAM_APPLICATION_ID,

Line 143: update JTF_LOC_HIERARCHIES_B set

139: X_LAST_UPDATED_BY in NUMBER,
140: X_LAST_UPDATE_LOGIN in NUMBER
141: ) is
142: begin
143: update JTF_LOC_HIERARCHIES_B set
144: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
145: REQUEST_ID = X_REQUEST_ID,
146: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
147: PROGRAM_ID = X_PROGRAM_ID,

Line 182: delete from JTF_LOC_HIERARCHIES_B

178: procedure DELETE_ROW (
179: X_LOCATION_HIERARCHY_ID in NUMBER
180: ) is
181: begin
182: delete from JTF_LOC_HIERARCHIES_B
183: where LOCATION_HIERARCHY_ID = X_LOCATION_HIERARCHY_ID;
184:
185: if (sql%notfound) then
186: raise no_data_found;

Line 226: from JTF_LOC_HIERARCHIES_B

222: l_hier_id number;
223:
224: cursor c_obj_verno is
225: select object_version_number
226: from JTF_LOC_HIERARCHIES_B
227: where LOCATION_HIERARCHY_ID = X_LOCATION_HIERARCHY_ID;
228:
229: cursor c_chk_hier_exists is
230: select 'x'

Line 231: from JTF_LOC_HIERARCHIES_B

227: where LOCATION_HIERARCHY_ID = X_LOCATION_HIERARCHY_ID;
228:
229: cursor c_chk_hier_exists is
230: select 'x'
231: from JTF_LOC_HIERARCHIES_B
232: where LOCATION_HIERARCHY_ID = X_LOCATION_HIERARCHY_ID;
233:
234: cursor c_get_hierid is
235: select JTF_LOC_HIERARCHIES_B_S.nextval

Line 235: select JTF_LOC_HIERARCHIES_B_S.nextval

231: from JTF_LOC_HIERARCHIES_B
232: where LOCATION_HIERARCHY_ID = X_LOCATION_HIERARCHY_ID;
233:
234: cursor c_get_hierid is
235: select JTF_LOC_HIERARCHIES_B_S.nextval
236: from dual;
237:
238: BEGIN
239: