APPS.JTF_LOC_HIERARCHIES_PVT dependencies on JTF_LOC_HIERARCHIES_B

Line 36: SELECT JTF_LOC_HIERARCHIES_B_S.NEXTVAL

32: l_loc_hier_rec loc_hier_rec_type := p_loc_hier_rec;
33: l_count NUMBER;
34:
35: CURSOR c_seq IS
36: SELECT JTF_LOC_HIERARCHIES_B_S.NEXTVAL
37: FROM DUAL;
38:
39: CURSOR c_count(hier_id IN NUMBER) IS
40: SELECT COUNT(*)

Line 41: FROM JTF_LOC_HIERARCHIES_B

37: FROM DUAL;
38:
39: CURSOR c_count(hier_id IN NUMBER) IS
40: SELECT COUNT(*)
41: FROM JTF_LOC_HIERARCHIES_B
42: WHERE location_hierarchy_id = hier_id;
43:
44: BEGIN
45: -- initialize

Line 107: INSERT INTO JTF_LOC_HIERARCHIES_B

103: END LOOP;
104: END IF;
105:
106: -- insert
107: INSERT INTO JTF_LOC_HIERARCHIES_B
108: (
109: location_hierarchy_id,
110: last_update_date,
111: last_updated_by,

Line 324: UPDATE JTF_LOC_HIERARCHIES_B SET

320:
321: -- update
322: JTF_Utility_PVT.debug_message(l_full_name||': update');
323:
324: UPDATE JTF_LOC_HIERARCHIES_B SET
325: last_update_date = sysdate,
326: last_updated_by = fnd_global.user_id,
327: object_version_number = l_loc_hier_rec.object_version_number + 1,
328: last_update_login = fnd_global.conc_login_id,

Line 466: DELETE FROM JTF_LOC_HIERARCHIES_B

462:
463: -- delete
464: JTF_Utility_PVT.debug_message(l_full_name || ': delete');
465:
466: DELETE FROM JTF_LOC_HIERARCHIES_B
467: WHERE location_hierarchy_id = p_hier_id
468: AND object_version_number = p_object_version;
469:
470: IF (SQL%NOTFOUND) THEN

Line 557: FROM JTF_LOC_HIERARCHIES_B

553: l_hier_id NUMBER;
554:
555: CURSOR c_hier IS
556: SELECT location_hierarchy_id
557: FROM JTF_LOC_HIERARCHIES_B
558: WHERE location_hierarchy_id = p_hier_id
559: AND object_version_number = p_object_version
560: FOR UPDATE OF location_hierarchy_id NOWAIT;
561:

Line 1263: SELECT * FROM JTF_LOC_HIERARCHIES_B

1259: )
1260: IS
1261:
1262: CURSOR c_hier IS
1263: SELECT * FROM JTF_LOC_HIERARCHIES_B
1264: WHERE location_hierarchy_id = p_loc_hier_rec.location_hierarchy_id;
1265:
1266: l_loc_hier_rec c_hier%ROWTYPE;
1267: