APPS.JTF_TASK_REFERENCES_PUB dependencies on JTF_TASKS_B

Line 49: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;

45: l_object_name jtf_task_references_b.object_name%TYPE;
46: l_object_id jtf_task_references_b.object_id%TYPE;
47: l_task_reference_id NUMBER;
48: l_rowid ROWID;
49: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
50: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
51: sql_stmt VARCHAR2(4000);
52: x CHAR;
53: l_object_type_code jtf_objects_b.object_code%TYPE := p_object_type_code;

Line 50: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;

46: l_object_id jtf_task_references_b.object_id%TYPE;
47: l_task_reference_id NUMBER;
48: l_rowid ROWID;
49: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
50: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
51: sql_stmt VARCHAR2(4000);
52: x CHAR;
53: l_object_type_code jtf_objects_b.object_code%TYPE := p_object_type_code;
54:

Line 425: l_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_object_type_code;

421: l_id_column jtf_objects_b.select_id%TYPE;
422: l_name_column jtf_objects_b.select_name%TYPE;
423: l_from_clause jtf_objects_b.from_table%TYPE;
424: l_where_clause jtf_objects_b.where_clause%TYPE;
425: l_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_object_type_code;
426: l_object_name jtf_tasks_b.source_object_name%TYPE := p_object_name;
427: l_object_id jtf_tasks_b.source_object_id%TYPE := p_object_id;
428: sql_stmt VARCHAR2(2000);
429: BEGIN

Line 426: l_object_name jtf_tasks_b.source_object_name%TYPE := p_object_name;

422: l_name_column jtf_objects_b.select_name%TYPE;
423: l_from_clause jtf_objects_b.from_table%TYPE;
424: l_where_clause jtf_objects_b.where_clause%TYPE;
425: l_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_object_type_code;
426: l_object_name jtf_tasks_b.source_object_name%TYPE := p_object_name;
427: l_object_id jtf_tasks_b.source_object_id%TYPE := p_object_id;
428: sql_stmt VARCHAR2(2000);
429: BEGIN
430:

Line 427: l_object_id jtf_tasks_b.source_object_id%TYPE := p_object_id;

423: l_from_clause jtf_objects_b.from_table%TYPE;
424: l_where_clause jtf_objects_b.where_clause%TYPE;
425: l_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_object_type_code;
426: l_object_name jtf_tasks_b.source_object_name%TYPE := p_object_name;
427: l_object_id jtf_tasks_b.source_object_id%TYPE := p_object_id;
428: sql_stmt VARCHAR2(2000);
429: BEGIN
430:
431:

Line 531: l_task_id jtf_tasks_b.task_id%TYPE;

527: IS
528: l_api_version CONSTANT NUMBER := 1.0;
529: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REFERENCES';
530:
531: l_task_id jtf_tasks_b.task_id%TYPE;
532: l_object_type_code jtf_objects_b.object_code%TYPE := p_object_type_code;
533: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE := p_task_reference_id;
534: l_reference_code jtf_task_references_b.reference_code%TYPE := p_reference_code;
535: l_usage jtf_task_references_tl.usage%TYPE := p_usage;