APPS.JTF_EC_WORKFLOW_PKG dependencies on JTF_OBJECTS_VL

Line 22: FROM jtf_objects_vl

18:
19: cursor c_get_res_name is
20: SELECT where_clause,
21: 'SELECT '||select_name||' FROM '||from_table||' WHERE '||select_id|| ' = :RES'
22: FROM jtf_objects_vl
23: WHERE object_code = p_resource_type;
24:
25: BEGIN
26:

Line 164: l_resource_type jtf_objects_vl.object_code%TYPE := NULL;

160: l_api_name VARCHAR2(30) := 'Get_Doc_Owner_Name';
161:
162: l_owner_name per_all_people_f.full_name%TYPE := NULL;
163: l_owner_id NUMBER := NULL;
164: l_resource_type jtf_objects_vl.object_code%TYPE := NULL;
165: l_resource_type_dev jtf_objects_vl.object_code%TYPE := NULL;
166: l_phase_owner_name VARCHAR2(240);
167: l_dev_owner_name VARCHAR2(240);
168: l_phase_owner_id NUMBER;

Line 165: l_resource_type_dev jtf_objects_vl.object_code%TYPE := NULL;

161:
162: l_owner_name per_all_people_f.full_name%TYPE := NULL;
163: l_owner_id NUMBER := NULL;
164: l_resource_type jtf_objects_vl.object_code%TYPE := NULL;
165: l_resource_type_dev jtf_objects_vl.object_code%TYPE := NULL;
166: l_phase_owner_name VARCHAR2(240);
167: l_dev_owner_name VARCHAR2(240);
168: l_phase_owner_id NUMBER;
169: l_dev_owner_id NUMBER;

Line 674: FROM jtf_objects_vl jo,

670: cursor get_doc_details is
671: SELECT jo.name object_type,
672: jo.object_code,
673: tr.object_name object_number
674: FROM jtf_objects_vl jo,
675: jtf_task_references_vl tr
676: WHERE tr.task_id = p_task_id
677: AND tr.object_type_code = jo.object_code
678: AND tr.reference_code = 'ESC';

Line 1040: l_doc_type jtf_objects_vl.name%TYPE;

1036: l_customer_name hz_parties.party_name%TYPE := NULL;
1037: l_event VARCHAR2(50) DEFAULT NULL;
1038: l_doc_number jtf_task_references_vl.object_name%TYPE;
1039: l_owner_name VARCHAR2(200);
1040: l_doc_type jtf_objects_vl.name%TYPE;
1041: l_doc_details_t VARCHAR2(4000);
1042: l_doc_details_h VARCHAR2(4000);
1043: l_notif_type VARCHAR2(1) := 'N';
1044: l_owner_changed VARCHAR2(1):= 'N';