1 PACKAGE OKC_TASK_PVT AS
2 /* $Header: OKCRTSKS.pls 120.0 2005/05/25 18:45:03 appldev noship $ */
3 ------------------------------------------------------------------------------
4 --GLOBAL VARIABLES
5 ------------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TASK_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
11
12 --Procedure to create a task for a resolved time value
13 PROCEDURE create_task(p_api_version IN NUMBER
14 ,p_init_msg_list IN VARCHAR2
15 ,p_resolved_time_id IN NUMBER
16 ,p_timezone_id IN NUMBER
17 ,p_timezone_name IN VARCHAR2
18 ,p_tve_id IN NUMBER
19 ,p_planned_end_date IN DATE
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 ,x_task_id OUT NOCOPY NUMBER);
24
25 --Procedure to create a Task for a condition occurrence
26 PROCEDURE create_condition_task(p_api_version IN NUMBER
27 ,p_init_msg_list IN VARCHAR2
28 ,p_cond_occr_id IN NUMBER
29 ,p_condition_name IN VARCHAR2
30 ,p_task_owner_id IN NUMBER
31 ,p_actual_end_date IN DATE
32 ,x_return_status OUT NOCOPY VARCHAR2
33 ,x_msg_count OUT NOCOPY NUMBER
34 ,x_msg_data OUT NOCOPY VARCHAR2
35 ,x_task_id OUT NOCOPY NUMBER);
36
37 --Procedure to create a Task for a contingent event
38 PROCEDURE create_contingent_task(p_api_version IN NUMBER
39 ,p_init_msg_list IN VARCHAR2
40 ,p_contract_id IN NUMBER
41 ,p_contract_number IN VARCHAR2
42 ,p_contingent_name IN VARCHAR2
43 ,p_task_owner_id IN NUMBER
44 ,p_actual_end_date IN DATE
45 ,x_return_status OUT NOCOPY VARCHAR2
46 ,x_msg_count OUT NOCOPY NUMBER
47 ,x_msg_data OUT NOCOPY VARCHAR2
48 ,x_task_id OUT NOCOPY NUMBER);
49
50 --Procedure to update a task
51 PROCEDURE update_task(p_api_version IN NUMBER
52 ,p_init_msg_list IN VARCHAR2
53 ,p_object_version_number IN OUT NOCOPY NUMBER
54 ,p_task_id IN NUMBER default null
55 ,p_task_number IN NUMBER default null
56 ,p_workflow_process_id IN NUMBER default null
57 ,p_actual_end_date IN DATE default null
58 ,p_alarm_fired_count IN NUMBER default null
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2);
62
63 --Procedureto delete a single or multiple tasks
64 PROCEDURE delete_task(p_api_version IN NUMBER
65 ,p_init_msg_list IN VARCHAR2
66 ,p_tve_id IN NUMBER DEFAULT NULL
67 ,p_rtv_id IN NUMBER DEFAULT NULL
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2);
71 END OKC_TASK_PVT;