1 Package CS_AutoGen_Task_PVT AUTHID CURRENT_USER AS
2 /* $Header: csvatsks.pls 120.1 2009/01/27 07:02:35 sshilpam ship $*/
3
4
5 TYPE TASK_TEMPLATE_SEARCH_REC_TYPE IS RECORD
6 (
7 incident_type_id NUMBER,
8 organization_id NUMBER,
9 inventory_item_id NUMBER,
10 category_id NUMBER,
11 problem_code VARCHAR2(50));
12
13 TYPE Auto_Task_Gen_Rec_Type IS RECORD
14 (
15 -- Commented out the first three attributes -- anmukher -- 08/21/03
16 -- task_template_group_id NUMBER,
17 -- location_id NUMBER,
18 -- party_site_id NUMBER,
19 auto_task_gen_attempted BOOLEAN,
20 field_service_task_created BOOLEAN );
21
22 TYPE task_template_group_tbl_type IS TABLE OF
23 JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info
24 INDEX BY BINARY_INTEGER;
25
26 -- 12.1.2 SR Task Enhancement project
27 -- Calculate the Planned End date based on the profile.
28 PROCEDURE Default_Planned_End_Date(p_respond_by IN DATE,
29 p_resolve_by IN DATE,
30 p_uom_code IN varchar2 DEFAULT fnd_api.g_miss_char,
31 p_planned_effort IN Number DEFAULT fnd_api.g_miss_num,
32 x_planned_end_date OUT NOCOPY DATE);
33
34
35 PROCEDURE Auto_Generate_Tasks
36 (
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
39 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
40 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
41 p_incident_id IN NUMBER ,
42 p_service_request_rec IN Cs_ServiceRequest_PVT.Service_Request_rec_type,
43 p_task_template_group_owner IN NUMBER,
44 p_task_tmpl_group_owner_type IN VARCHAR2,
45 p_task_template_group_rec IN JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info,
46 p_task_template_table IN JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl,
47 x_auto_task_gen_rec OUT NOCOPY Cs_AutoGen_Task_PVT.auto_task_gen_rec_type,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2 );
51
52
53 PROCEDURE Get_Task_Template_Group
54 (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
57 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
58 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
59 p_task_template_search_rec IN Cs_AutoGen_Task_PVT.TASK_TEMPLATE_SEARCH_REC_TYPE,
60 x_task_template_group_tbl OUT NOCOPY Cs_AutoGen_Task_PVT.TASK_TEMPLATE_GROUP_TBL_TYPE,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2 );
64
65 FUNCTION Get_Task_Template_Status
66 (
67 p_start_date IN DATE ,
68 p_end_date IN DATE ) RETURN VARCHAR2 ;
69
70 END CS_AutoGen_Task_PVT;