[Home] [Help]
PACKAGE: APPS.CS_AUTOGEN_TASK_PVT
Source
1 Package CS_AutoGen_Task_PVT AUTHID CURRENT_USER AS
2 /* $Header: csvatsks.pls 115.4 2004/02/26 18:44:57 spusegao noship $*/
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
27 PROCEDURE Auto_Generate_Tasks
28 (
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
31 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
32 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
33 p_incident_id IN NUMBER ,
34 p_service_request_rec IN Cs_ServiceRequest_PVT.Service_Request_rec_type,
35 p_task_template_group_owner IN NUMBER,
36 p_task_tmpl_group_owner_type IN VARCHAR2,
37 p_task_template_group_rec IN JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info,
38 p_task_template_table IN JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl,
39 x_auto_task_gen_rec OUT NOCOPY Cs_AutoGen_Task_PVT.auto_task_gen_rec_type,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2 );
43
44
45 PROCEDURE Get_Task_Template_Group
46 (
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
49 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
50 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
51 p_task_template_search_rec IN Cs_AutoGen_Task_PVT.TASK_TEMPLATE_SEARCH_REC_TYPE,
52 x_task_template_group_tbl OUT NOCOPY Cs_AutoGen_Task_PVT.TASK_TEMPLATE_GROUP_TBL_TYPE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2 );
56
57 FUNCTION Get_Task_Template_Status
58 (
59 p_start_date IN DATE ,
60 p_end_date IN DATE ) RETURN VARCHAR2 ;
61
62 END CS_AutoGen_Task_PVT;