APPS.JTF_TASK_TYPES_PKG dependencies on JTF_TASK_TYPES_B

Line 47: FROM jtf_task_types_b

43: IS
44: CURSOR c
45: IS
46: SELECT ROWID
47: FROM jtf_task_types_b
48: WHERE task_type_id = x_task_type_id;
49: BEGIN
50: INSERT INTO jtf_task_types_b (
51: task_type_id,

Line 50: INSERT INTO jtf_task_types_b (

46: SELECT ROWID
47: FROM jtf_task_types_b
48: WHERE task_type_id = x_task_type_id;
49: BEGIN
50: INSERT INTO jtf_task_types_b (
51: task_type_id,
52: object_version_number,
53: start_date_active,
54: end_date_active,

Line 243: UPDATE jtf_task_types_b

239: x_set_actual_dates_flag IN VARCHAR2 default null
240: )
241: IS
242: BEGIN
243: UPDATE jtf_task_types_b
244: SET start_date_active = x_start_date_active,
245: object_version_number = x_object_version_number + 1,
246: end_date_active = x_end_date_active,
247: seeded_flag = x_seeded_flag,

Line 315: FROM jtf_task_types_b

311: RAISE NO_DATA_FOUND;
312: END IF;
313:
314: DELETE
315: FROM jtf_task_types_b
316: WHERE task_type_id = x_task_type_id;
317:
318: IF (SQL%NOTFOUND)
319: THEN

Line 335: FROM jtf_task_types_b b

331: /*
332: DELETE
333: FROM jtf_task_types_tl t
334: WHERE NOT EXISTS (SELECT NULL
335: FROM jtf_task_types_b b
336: WHERE b.task_type_id = t.task_type_id);
337: UPDATE jtf_task_types_tl t
338: SET (name, description) = ( SELECT b.name, b.description
339: FROM jtf_task_types_tl b

Line 470: FROM jtf_task_types_b

466: END IF;
467:
468: SELECT task_type_id, object_version_number
469: INTO l_task_type_id, l_object_version_number
470: FROM jtf_task_types_b
471: WHERE task_type_id = x_task_type_id;
472:
473:
474:

Line 476: UPDATE jtf_task_types_b

472:
473:
474:
475:
476: UPDATE jtf_task_types_b
477: SET start_date_active = x_start_date_active,
478: object_version_number = l_object_version_number + 1,
479: end_date_active = x_end_date_active,
480: seeded_flag = x_seeded_flag,