1 PACKAGE AHL_VWP_PLAN_TASKS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPLNS.pls 115.1 2003/08/21 18:37:01 shbhanda noship $ */
3 -----------------------------------------------------------
4 -- PACKAGE
5 -- AHL_VWP_PLAN_TASKS_PVT
6 --
7 -- PURPOSE
8 -- This package is a Private API for Creating VWP Visit Planned Tasks in
9 -- CMRO. It contains specification for pl/sql records and tables
10 --
11 -- Create_Planned_Task (see below for specification)
12 -- Update_Planned_Task (see below for specification)
13 -- Delete_Planned_Task (see below for specification)
14 --
15 --
16 -- NOTES
17 --
18 --
19 -- HISTORY
20 -- 12-MAY_2002 Shbhanda Created.
21 -- 21-FEB-2003 YAZHOU Separated from Task package
22 -- 06-AUG-2003 SHBHANDA 11.5.10 Changes.
23 -----------------------------------------------------------
24
25 ------------------------------------------------------------------
26 -- Procedure name : Create_Planned_Task
27 -- Type : Private
28 -- Function : To create planned task for selected MR/Routes
29 -- Parameters :
30 --
31 -- Standard IN Parameters :
32 -- p_api_version IN NUMBER Required
33 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
34 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
35 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
36 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
37 -- p_module_type IN VARCHAR2 Default NULL.
38 --
39 -- Standard OUT Parameters :
40 -- x_return_status OUT VARCHAR2 Required
41 -- x_msg_count OUT NUMBER Required
42 -- x_msg_data OUT VARCHAR2 Required
43 --
44 -- Create_Planned_Task Parameters:
45 -- p_x_task_Rec IN OUT AHL_VWP_RULES_PVT.Task_Rec_Type Required,
46 -- The record with AHL_VWP_RULES_PVT.Task_Rec_Type
47 --
48 -- Version :
49 -- Initial Version 1.0
50 -------------------------------------------------------------------
51 PROCEDURE Create_Planned_Task (
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
54 p_commit IN VARCHAR2 := Fnd_Api.g_false,
55 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
56 p_module_type IN VARCHAR2 := 'JSP',
57
58 p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
59
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 -------------------------------------------------------------------
66 -- Procedure name : Update_Planned_Task
67 -- Type : Private
68 -- Function : To update various different types of tasks in a visit.
69 -- Parameters :
70 --
71 -- Standard IN Parameters :
72 -- p_api_version IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
74 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
75 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
76 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
77 -- p_module_type IN VARCHAR2 Default NULL.
78 --
79 -- Standard OUT Parameters :
80 -- x_return_status OUT VARCHAR2 Required
81 -- x_msg_count OUT NUMBER Required
82 -- x_msg_data OUT VARCHAR2 Required
83 --
84 -- Update_Task Parameters:
85 -- p_x_Task_Rec IN OUT AHL_VWP_RULES_PVT.Task_Rec_Type Required
86 -- The record of visit's task attributes for which task is updated.
87 --
88 -- Version :
89 -- Initial Version 1.0
90 -------------------------------------------------------------------
91
92 PROCEDURE Update_Planned_Task (
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
95 p_commit IN VARCHAR2 := Fnd_Api.g_false,
96 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
97 p_module_type IN VARCHAR2 := 'JSP',
98 p_x_Task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
99
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 -------------------------------------------------------------------
106 -- Procedure name : Delete_Planned_Task
107 -- Type : Private
108 -- Function : To delete various different types of tasks in a visit.
109 -- Parameters :
110 --
111 -- Standard IN Parameters :
112 -- p_api_version IN NUMBER Required
113 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
114 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
115 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
116 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
117 -- p_module_type IN VARCHAR2 Default NULL.
118 --
119 -- Standard OUT Parameters :
120 -- x_return_status OUT VARCHAR2 Required
121 -- x_msg_count OUT NUMBER Required
122 -- x_msg_data OUT VARCHAR2 Required
123 --
124 -- Delete_Task Parameters:
125 -- p_Visit_Task_ID IN NUMBER Required
126 -- The Id of visit's task which has to be deleted.
127 --
128 -- Version :
129 -- Initial Version 1.0
130 -------------------------------------------------------------------
131
132 PROCEDURE Delete_Planned_Task (
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
135 p_commit IN VARCHAR2 := Fnd_Api.g_false,
136 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
137 p_module_type IN VARCHAR2 := 'JSP',
138 p_Visit_Task_Id IN NUMBER,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144
145 END AHL_VWP_PLAN_TASKS_PVT;