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