DBA Data[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;