[Home] [Help]
10: -- Attributes set by WF before calling this package
11: ----------------------------------------------------------------------------
12:
13: -- unique object identifier
14: g_object_id JTF_TASKS_VL.TASK_ID%TYPE;
15:
16: -- type of object.
17: -- possible values are: - 'CS_BRM_3D_SERVICE_REQUEST_V' - SR
18: -- - 'CSS_BRM_3D_DEFECT_V' - Defect
44: -- date and time the object was detected
45: g_detected_date DATE;
46:
47: -- object owner
48: g_owner_id JTF_TASKS_VL.OWNER_ID%TYPE;
49:
50: -- SR object owner in case owner is a group
51: g_owner_group_id NUMBER;
52:
53: -- SR group type either Group or Team
54: g_owner_group_type VARCHAR2(30);
55:
56: -- object owner's territory
57: g_territory JTF_TASKS_VL.OWNER_TERRITORY_ID%TYPE;
58:
59: -- object owner's resource type
60: g_res_type_code JTF_TASKS_VL.OWNER_TYPE_CODE%TYPE;
61:
56: -- object owner's territory
57: g_territory JTF_TASKS_VL.OWNER_TERRITORY_ID%TYPE;
58:
59: -- object owner's resource type
60: g_res_type_code JTF_TASKS_VL.OWNER_TYPE_CODE%TYPE;
61:
62: -- derive this from the object
63: g_object_type_code JTF_OBJECTS_VL.OBJECT_CODE%TYPE;
64:
699: AND nvl(end_date_active, b_now) >= b_now;
700:
701: l_now DATE := SYSDATE;
702: l_index BINARY_INTEGER;
703: l_esc_territory JTF_TASKS_VL.OWNER_TERRITORY_ID%TYPE;
704: l_person_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
705: l_resultout VARCHAR2(80);
706: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
707: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1022: l_start_pointer NUMBER;
1023: l_rec_wanted NUMBER;
1024: l_retrieved NUMBER;
1025: l_returned NUMBER;
1026: l_object_version_number JTF_TASKS_VL.OBJECT_VERSION_NUMBER%TYPE;
1027:
1028: TYPE cur_type IS REF CURSOR;
1029: c_object cur_type;
1030:
1366: l_rec_wanted NUMBER;
1367: l_retrieved NUMBER;
1368: l_returned NUMBER;
1369: l_template_name JTF_TASK_TEMPLATES_VL.TASK_NAME%TYPE;
1370: l_notif_task_id JTF_TASKS_VL.TASK_ID%TYPE;
1371: l_task_assign_id NUMBER;
1372: l_obj_version JTF_TASKS_VL.OBJECT_VERSION_NUMBER%TYPE;
1373: l_object_name JTF_OBJECTS_VL.NAME%TYPE;
1374: l_task_reference_id JTF_TASK_REFERENCES_VL.TASK_REFERENCE_ID%TYPE;
1368: l_returned NUMBER;
1369: l_template_name JTF_TASK_TEMPLATES_VL.TASK_NAME%TYPE;
1370: l_notif_task_id JTF_TASKS_VL.TASK_ID%TYPE;
1371: l_task_assign_id NUMBER;
1372: l_obj_version JTF_TASKS_VL.OBJECT_VERSION_NUMBER%TYPE;
1373: l_object_name JTF_OBJECTS_VL.NAME%TYPE;
1374: l_task_reference_id JTF_TASK_REFERENCES_VL.TASK_REFERENCE_ID%TYPE;
1375: l_assign_id NUMBER;
1376: l_assign_role VARCHAR2(80);
1819: l_esc_rec jtf_ec_pub.esc_rec_type;
1820: l_esc_ref_docs jtf_ec_pub.esc_ref_docs_tbl_type;
1821: l_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
1822: l_esc_cont_phones jtf_ec_pub.esc_cont_points_tbl_type;
1823: l_esc_task_id JTF_TASKS_VL.TASK_ID%TYPE;
1824: l_esc_task_number JTF_TASKS_VL.TASK_NUMBER%TYPE;
1825: l_wf_process_id NUMBER;
1826: l_owner_role VARCHAR2(80);
1827: l_owner_id JTF_TASKS_VL.OWNER_ID%TYPE;
1820: l_esc_ref_docs jtf_ec_pub.esc_ref_docs_tbl_type;
1821: l_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
1822: l_esc_cont_phones jtf_ec_pub.esc_cont_points_tbl_type;
1823: l_esc_task_id JTF_TASKS_VL.TASK_ID%TYPE;
1824: l_esc_task_number JTF_TASKS_VL.TASK_NUMBER%TYPE;
1825: l_wf_process_id NUMBER;
1826: l_owner_role VARCHAR2(80);
1827: l_owner_id JTF_TASKS_VL.OWNER_ID%TYPE;
1828: l_wf_role FND_USER.USER_NAME%TYPE;
1823: l_esc_task_id JTF_TASKS_VL.TASK_ID%TYPE;
1824: l_esc_task_number JTF_TASKS_VL.TASK_NUMBER%TYPE;
1825: l_wf_process_id NUMBER;
1826: l_owner_role VARCHAR2(80);
1827: l_owner_id JTF_TASKS_VL.OWNER_ID%TYPE;
1828: l_wf_role FND_USER.USER_NAME%TYPE;
1829: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;
1830: l_object_name JTF_OBJECTS_VL.NAME%TYPE;
1831: l_task_reference_id JTF_TASK_REFERENCES_VL.TASK_REFERENCE_ID%TYPE;