APPS.JTF_TASK_TYPES_PKG dependencies on JTF_TASK_TYPES_B

Line 45: FROM jtf_task_types_b

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

Line 48: INSERT INTO jtf_task_types_b (

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

Line 235: UPDATE jtf_task_types_b

231: x_workflow_type IN VARCHAR2 DEFAULT NULL
232: )
233: IS
234: BEGIN
235: UPDATE jtf_task_types_b
236: SET start_date_active = x_start_date_active,
237: object_version_number = x_object_version_number + 1,
238: end_date_active = x_end_date_active,
239: seeded_flag = x_seeded_flag,

Line 305: FROM jtf_task_types_b

301: RAISE NO_DATA_FOUND;
302: END IF;
303:
304: DELETE
305: FROM jtf_task_types_b
306: WHERE task_type_id = x_task_type_id;
307:
308: IF (SQL%NOTFOUND)
309: THEN

Line 325: FROM jtf_task_types_b b

321: /*
322: DELETE
323: FROM jtf_task_types_tl t
324: WHERE NOT EXISTS (SELECT NULL
325: FROM jtf_task_types_b b
326: WHERE b.task_type_id = t.task_type_id);
327: UPDATE jtf_task_types_tl t
328: SET (name, description) = ( SELECT b.name, b.description
329: FROM jtf_task_types_tl b

Line 459: FROM jtf_task_types_b

455: END IF;
456:
457: SELECT task_type_id, object_version_number
458: INTO l_task_type_id, l_object_version_number
459: FROM jtf_task_types_b
460: WHERE task_type_id = x_task_type_id;
461:
462:
463:

Line 465: UPDATE jtf_task_types_b

461:
462:
463:
464:
465: UPDATE jtf_task_types_b
466: SET start_date_active = x_start_date_active,
467: object_version_number = l_object_version_number + 1,
468: end_date_active = x_end_date_active,
469: seeded_flag = x_seeded_flag,