1 PACKAGE AHL_VWP_TASKS_PUB AS
2 /* $Header: AHLPTSKS.pls 120.1 2008/06/23 23:08:10 jaramana noship $ */
3 /*#
4 * Package containing public API to add planned tasks to a visit.
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname VWP Tasks
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_MAINT_VISIT
10 */
11
12 -------------------------------------------------------------------------------------------
13 -- Start of Comments
14 -- Procedure name : Create_Planned_Tasks
15 -- Type : Public
16 -- Function : Creates planned tasks and adds them to an existing visit.
17 -- Pre-reqs :
18 -- Parameters :
19 --
20 -- Create_Planned_Tasks Parameters:
21 -- p_visit_id IN NUMBER := null Not needed if p_visit_number is given
22 -- p_visit_number IN NUMBER := null Ignored if p_visit_id is given
23 -- p_department_id IN NUMBER := null Not needed if p_department_code is given
24 -- p_department_code IN VARCHAR2 := null Ignored if p_department_id is given
25 -- p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type
26 -- UNIT_EFFECTIVITY_ID is Mandatory
27 -- ATTRIBUTE_CATEGORY is Optional
28 -- ATTRIBUTE1..ATTRIBUTE15 are Optional
29 -- All others input attributes are ignored
30 -- VISIT_TASK_ID has the return value: Id of the task created for the UE.
31 --
32 -- End of Comments
33 -------------------------------------------------------------------------------------------
34 /*#
35 * Procedure for adding planned tasks to an existing visit.
36 * @param p_api_version API Version Number.
37 * @param p_init_msg_list Initialize the message stack. Standard API parameter, default value FND_API.G_FALSE
38 * @param p_commit Parameter to decide whether to commit the transaction or not. Standard API parameter, default value FND_API.G_FALSE
39 * @param p_validation_level Validation level. Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
40 * @param x_return_status API Return status. Standard API parameter.
41 * @param x_msg_count API Return message count, if any. Standard API parameter.
42 * @param x_msg_data API Return message data, if any. Standard API parameter.
43 * @param p_visit_id Id of the visit to which tasks are to be added. Not needed if p_visit_number is given.
44 * @param p_visit_number Number of the visit to which tasks are to be added. Ignored if p_visit_id is given.
45 * @param p_department_id Id of the department to which tasks are to be added. Not needed if p_department_code is given.
46 * @param p_department_code Code of the department to which tasks are to be added. Ignored if p_department_id is given.
47 * @param p_x_tasks_tbl Table of type AHL_VWP_RULES_PVT.Task_Tbl_Type. Input UNIT_EFFECTIVITY_ID, returns VISIT_TASK_ID.
48 * @rep:scope public
49 * @rep:lifecycle active
50 * @rep:displayname Create Planned Tasks
51 */
52 PROCEDURE Create_Planned_Tasks (
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55 p_commit IN VARCHAR2 := FND_API.G_FALSE,
56 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
57 p_visit_id IN NUMBER := null, -- Not needed if p_visit_number is given
58 p_visit_number IN NUMBER := null, -- Ignored if p_visit_id is given
59 p_department_id IN NUMBER := null, -- Not needed if p_department_code is given
60 p_department_code IN VARCHAR2 := null, -- Ignored if p_department_id is given
61 p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 End AHL_VWP_TASKS_PUB;