DBA Data[Home] [Help]

APPS.JTF_TASK_REFERENCES_PUB dependencies on JTF_TASK_REFERENCES_B

Line 45: l_object_name jtf_task_references_b.object_name%TYPE;

41: l_id_column jtf_objects_b.select_id%TYPE;
42: l_name_column jtf_objects_b.select_name%TYPE;
43: l_from_clause jtf_objects_b.from_table%TYPE;
44: l_where_clause jtf_objects_b.where_clause%TYPE;
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;

Line 46: l_object_id jtf_task_references_b.object_id%TYPE;

42: l_name_column jtf_objects_b.select_name%TYPE;
43: l_from_clause jtf_objects_b.from_table%TYPE;
44: l_where_clause jtf_objects_b.where_clause%TYPE;
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;

Line 533: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE := p_task_reference_id;

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;
536: l_object_name jtf_task_references_b.object_name%TYPE;
537: l_object_id jtf_task_references_b.object_id%TYPE;

Line 534: l_reference_code jtf_task_references_b.reference_code%TYPE := p_reference_code;

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;
536: l_object_name jtf_task_references_b.object_name%TYPE;
537: l_object_id jtf_task_references_b.object_id%TYPE;
538:

Line 536: l_object_name jtf_task_references_b.object_name%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;
536: l_object_name jtf_task_references_b.object_name%TYPE;
537: l_object_id jtf_task_references_b.object_id%TYPE;
538:
539: CURSOR c_task_reference
540: IS

Line 537: l_object_id jtf_task_references_b.object_id%TYPE;

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;
536: l_object_name jtf_task_references_b.object_name%TYPE;
537: l_object_id jtf_task_references_b.object_id%TYPE;
538:
539: CURSOR c_task_reference
540: IS
541: SELECT task_id,