1 PACKAGE JTF_TASK_WORKFLOW_PKG AUTHID CURRENT_USER as
2 /* $Header: jtftkwfs.pls 115.22 2002/12/04 23:38:35 cjang ship $ */
3
4 jtf_task_item_type CONSTANT VARCHAR2(8) := 'JTFTASK';
5 jtf_task_default_process CONSTANT VARCHAR2(30) := 'TASK_WORKFLOW';
6
7 TYPE task_details_rec IS RECORD (
8 task_attribute VARCHAR2(80),
9 old_value VARCHAR2(80),
10 new_value VARCHAR2(80)
11 );
12
13 TYPE task_details_tbl IS TABLE OF task_details_rec
14 INDEX BY BINARY_INTEGER;
15
16 g_miss_task_details_tbl task_details_tbl;
17
18
19
20 -- -----------------------------------------------------------------------
21 -- Is_Task_Item_Active
22 -- Determine whether the workflow process identified by the given process
23 -- ID for the given task is still active.
24 -- IN
25 -- p_task_id - task ID
26 -- p_wf_process_id - workflow process ID for this task ID
27 -- RETURN
28 -- 'Y' if process is active, 'N' otherwise
29 -- -----------------------------------------------------------------------
30
31 FUNCTION Is_Task_Item_Active
32 ( p_task_id IN NUMBER,
33 p_wf_process_id IN NUMBER )
34 RETURN VARCHAR2;
35 PRAGMA RESTRICT_REFERENCES (Is_Task_Item_Active, WNDS);
36
37 -- -------------------------------------------------------------------
38 -- Get_Workflow_Disp_Name
39 -- Get the display name of the given Workflow process.
40 --
41 -- Notes: The p_raise_error flag determines what to do if the
42 -- Workflow process does not exist. If it's TRUE, then
43 -- NO_DATA_FOUND exception will be raised; otherwise, no
44 -- exception is raised and NULL is returned
45 --
46 -- This is a stored function that can be invoked from a
47 -- view script.
48 --
49 -- -------------------------------------------------------------------
50
51 FUNCTION Get_Workflow_Disp_Name (
52 p_item_type IN VARCHAR2,
53 p_process_name IN VARCHAR2,
54 p_raise_error IN BOOLEAN DEFAULT FALSE )
55 RETURN VARCHAR2;
56 pragma RESTRICT_REFERENCES (Get_Workflow_Disp_Name, WNDS, WNPS);
57
58
59 PROCEDURE check_event (
60 itemtype IN VARCHAR2,
61 itemkey IN VARCHAR2,
62 actid IN NUMBER,
63 funcmode IN VARCHAR2,
64 resultout OUT NOCOPY VARCHAR2
65 );
66
67 FUNCTION default_task_details_tbl return task_details_tbl;
68
69 PROCEDURE start_task_workflow (
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
72 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
73 p_task_id IN NUMBER,
74 p_old_assignee_code IN VARCHAR2 DEFAULT NULL,
75 p_old_assignee_id IN NUMBER DEFAULT NULL,
76 p_new_assignee_code IN VARCHAR2 DEFAULT NULL,
77 p_new_assignee_id IN NUMBER DEFAULT NULL,
78 p_old_owner_code IN VARCHAR2 DEFAULT NULL,
79 p_old_owner_id IN NUMBER DEFAULT NULL,
80 p_new_owner_code IN VARCHAR2 DEFAULT NULL,
81 p_new_owner_id IN NUMBER DEFAULT NULL,
82 p_task_details_tbl IN task_details_tbl
83 DEFAULT g_miss_task_details_tbl,
84 p_event IN VARCHAR2,
85 /*
86 'ADD_ASSIGNEE',
87 'CHANGE_ASSIGNEE',
88 'DELETE_ASSIGNEE',
89 'CHANGE_OWNER',
90 'CHANGE_TASK_DETAILS'
91 */
92 p_wf_display_name IN VARCHAR2 DEFAULT NULL,
93 p_wf_process IN VARCHAR2 DEFAULT 'TASK_WORKFLOW',
94 p_wf_item_type IN VARCHAR2 DEFAULT 'JTFTASK',
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE abort_task_workflow (
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
103 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
104 p_task_id IN NUMBER,
105 p_wf_process_id IN NUMBER,
106 p_user_code IN VARCHAR2,
107 p_user_id IN NUMBER,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113
114 END JTF_TASK_WORKFLOW_PKG;