APPS.JTF_LOC_AREAS_PKG dependencies on JTF_LOC_AREAS_B

Line 26: cursor C is select ROWID from JTF_LOC_AREAS_B

22: X_LAST_UPDATE_DATE in DATE,
23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER
25: ) is
26: cursor C is select ROWID from JTF_LOC_AREAS_B
27: where LOCATION_AREA_ID = X_LOCATION_AREA_ID
28: ;
29: begin
30: insert into JTF_LOC_AREAS_B (

Line 30: insert into JTF_LOC_AREAS_B (

26: cursor C is select ROWID from JTF_LOC_AREAS_B
27: where LOCATION_AREA_ID = X_LOCATION_AREA_ID
28: ;
29: begin
30: insert into JTF_LOC_AREAS_B (
31: LOCATION_AREA_ID,
32: OBJECT_VERSION_NUMBER,
33: PARENT_LOCATION_AREA_ID,
34: REQUEST_ID,

Line 131: update JTF_LOC_AREAS_B set

127: X_LAST_UPDATED_BY in NUMBER,
128: X_LAST_UPDATE_LOGIN in NUMBER
129: ) is
130: begin
131: update JTF_LOC_AREAS_B set
132: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
133: PARENT_LOCATION_AREA_ID = X_PARENT_LOCATION_AREA_ID,
134: REQUEST_ID = X_REQUEST_ID,
135: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,

Line 194: FROM jtf_loc_areas_b

190: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ varchar2
191: ) is
192: CURSOR child_end_date IS
193: SELECT end_Date_active
194: FROM jtf_loc_areas_b
195: WHERE parent_location_area_id = x_location_area_id;
196:
197: Cursor locationName is
198: select location_Area_name

Line 270: delete from JTF_LOC_AREAS_B

266: if (sql%notfound) then
267: raise no_data_found;
268: end if;
269:
270: delete from JTF_LOC_AREAS_B
271: where LOCATION_AREA_ID = X_LOCATION_AREA_ID;
272:
273: if (sql%notfound) then
274: raise no_data_found;

Line 284: from JTF_LOC_AREAS_B B

280: begin
281: delete from JTF_LOC_AREAS_TL T
282: where not exists
283: (select NULL
284: from JTF_LOC_AREAS_B B
285: where B.LOCATION_AREA_ID = T.LOCATION_AREA_ID
286: );
287:
288: update JTF_LOC_AREAS_TL T set (

Line 388: from JTF_LOC_AREAS_B

384: l_area_id number;
385:
386: cursor c_obj_verno is
387: select object_version_number
388: from JTF_LOC_AREAS_B
389: where location_area_id = X_LOCATION_AREA_ID;
390:
391: cursor c_chk_area_exists is
392: select 'x'

Line 393: from JTF_LOC_AREAS_B

389: where location_area_id = X_LOCATION_AREA_ID;
390:
391: cursor c_chk_area_exists is
392: select 'x'
393: from JTF_LOC_AREAS_B
394: where location_area_id = X_LOCATION_AREA_ID;
395:
396: cursor c_get_areaid is
397: select JTF_LOC_AREAS_B_S.nextval

Line 397: select JTF_LOC_AREAS_B_S.nextval

393: from JTF_LOC_AREAS_B
394: where location_area_id = X_LOCATION_AREA_ID;
395:
396: cursor c_get_areaid is
397: select JTF_LOC_AREAS_B_S.nextval
398: from dual;
399:
400: BEGIN
401: