APPS.JTF_LOC_AREAS_PVT dependencies on JTF_LOC_AREAS_B

Line 36: SELECT JTF_LOC_AREAS_B_S.NEXTVAL

32: l_loc_area_rec loc_area_rec_type := p_loc_area_rec;
33: l_loc_area_count NUMBER;
34:
35: CURSOR c_loc_area_seq IS
36: SELECT JTF_LOC_AREAS_B_S.NEXTVAL
37: FROM DUAL;
38:
39: CURSOR c_loc_area_count(loc_area_id IN NUMBER) IS
40: SELECT COUNT(*)

Line 107: INSERT INTO JTF_LOC_AREAS_B

103: EXIT WHEN l_loc_area_count = 0;
104: END LOOP;
105: END IF;
106:
107: INSERT INTO JTF_LOC_AREAS_B
108: (
109: location_area_id,
110: last_update_date,
111: last_updated_by,

Line 342: UPDATE JTF_LOC_AREAS_B SET

338: IF p_remove_flag = 'Y' THEN
339: l_loc_area_rec.end_date_active := SYSDATE;
340: END IF;
341:
342: UPDATE JTF_LOC_AREAS_B SET
343: last_update_date = SYSDATE,
344: last_updated_by = FND_GLOBAL.user_id,
345: object_version_number = l_loc_area_rec.object_version_number + 1,
346: last_update_login = FND_GLOBAL.conc_login_id,

Line 471: FROM jtf_loc_areas_b

467: CURSOR c_child_exist(l_id NUMBER) IS
468: SELECT 1
469: FROM DUAL
470: WHERE EXISTS(SELECT 1
471: FROM jtf_loc_areas_b
472: WHERE nvl(end_date_active,SYSDATE + 1) > SYSDATE
473: AND parent_location_area_id = l_id);
474:
475: BEGIN

Line 527: DELETE FROM JTF_LOC_AREAS_B

523: END IF;
524: RAISE FND_API.g_exc_error;
525: END IF;
526:
527: DELETE FROM JTF_LOC_AREAS_B
528: WHERE location_area_id = p_loc_area_id
529: AND object_version_number = p_object_version;
530: */
531:

Line 533: UPDATE jtf_loc_areas_b

529: AND object_version_number = p_object_version;
530: */
531:
532: -- added by julou 24-APR-2001 for bug 1717907/1703508
533: UPDATE jtf_loc_areas_b
534: SET last_update_date = SYSDATE
535: ,last_updated_by = FND_GLOBAL.user_id
536: ,last_update_login = FND_GLOBAL.conc_login_id
537: ,end_date_active = SYSDATE

Line 630: FROM JTF_LOC_AREAS_B

626: l_loc_area_id NUMBER;
627:
628: CURSOR c_loc_area_b IS
629: SELECT location_area_id
630: FROM JTF_LOC_AREAS_B
631: WHERE location_area_id = p_loc_area_id
632: AND object_version_number = p_object_version
633: FOR UPDATE OF location_area_id NOWAIT;
634:

Line 953: FROM jtf_loc_areas_b

949: CURSOR c_world_exist IS
950: SELECT 1
951: FROM DUAL
952: WHERE EXISTS(SELECT 1
953: FROM jtf_loc_areas_b
954: WHERE location_type_code = 'AREA1');
955:
956: l_world_exist NUMBER;
957:

Line 1103: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t

1099: CURSOR c_area_name_count1(l_id NUMBER, l_parent_id NUMBER, l_name VARCHAR2) IS
1100: SELECT 1
1101: FROM DUAL
1102: WHERE EXISTS(SELECT 1
1103: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t
1104: WHERE t.location_area_name = l_name
1105: AND t.language = USERENV('LANG')
1106: AND t.location_area_id <> l_id
1107: AND b.parent_location_area_id = l_parent_id

Line 1114: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t

1110: CURSOR c_area_name_count2(l_parent_id NUMBER, l_name VARCHAR2) IS
1111: SELECT 1
1112: FROM DUAL
1113: WHERE EXISTS(SELECT 1
1114: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t
1115: WHERE t.location_area_name = l_name
1116: AND t.language = USERENV('LANG')
1117: AND b.parent_location_area_id = l_parent_id
1118: AND b.location_area_id =t.location_area_id);