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