[Home] [Help]
PACKAGE: APPS.PA_WORKFLOW_UTILS
Source
1 PACKAGE pa_workflow_utils AS
2 /* $Header: PAWFUTLS.pls 120.1 2005/08/19 17:08:03 mwasowic noship $ */
3
4
5
6 PROCEDURE Insert_WF_Processes
7 (p_wf_type_code IN VARCHAR2
8 , p_item_type IN VARCHAR2
9 , p_item_key IN VARCHAR2
10 , p_entity_key1 IN VARCHAR2
11 , p_entity_key2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12 , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13 , p_err_code IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
14 , p_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15 , p_err_stack IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
16 );
17
18 PROCEDURE Set_Global_Attr
19 (p_item_type IN VARCHAR2
20 , p_item_key IN VARCHAR2
21 , p_err_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22 );
23
24 PROCEDURE Set_Notification_Messages
25 (p_item_type IN VARCHAR2
26 , p_item_key IN VARCHAR2
27 );
28
29 --
30 -- FUNCTION
31 -- get_application_id
32 -- PURPOSE
33 -- This function retrieves the application id of a responsibility.
34 -- If no application id is found, null is returned.
35 -- If Oracle error occurs, Oracle error number is returned.
36 -- HISTORY
37 -- 02-SEP-99 sbalasub Created
38 --
39 function get_application_id (x_responsibility_id IN number) return number;
40 pragma RESTRICT_REFERENCES (get_application_id, WNDS, WNPS);
41
42 PROCEDURE get_workflow_info (
43 p_project_status_code IN VARCHAR2
44 ,p_project_status_type IN VARCHAR2
45 ,x_enable_wf_flag out NOCOPY varchar2 --File.Sql.39 bug 4440895
46 ,x_workflow_item_type out NOCOPY varchar2 --File.Sql.39 bug 4440895
47 ,x_workflow_process OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
48 ,x_wf_success_status_code OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
49 ,x_wf_failure_status_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50 , x_msg_count out NOCOPY NUMBER --File.Sql.39 bug 4440895
51 , x_msg_data out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53 );
54
55 Procedure Cancel_Workflow
56 ( p_Item_type IN VARCHAR2
57 , p_Item_key IN VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
59 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61 );
62
63 Procedure create_workflow_process (
64 p_item_type IN VARCHAR2
65 , p_process_name IN VARCHAR2
66 , x_item_key out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67 , x_msg_count out NOCOPY NUMBER --File.Sql.39 bug 4440895
68 , x_msg_data out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
69 , x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
70
71 procedure start_workflow_process (
72 p_item_type IN VARCHAR2
73 , p_process_name IN VARCHAR2
74 , p_item_key IN number
75 , p_wf_type_code IN VARCHAR2
76 , p_entity_key1 IN VARCHAR2
77 , p_entity_key2 IN VARCHAR2
78 , p_description IN VARCHAR2
79 , x_msg_count out NOCOPY NUMBER --File.Sql.39 bug 4440895
80 , x_msg_data out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
81 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82 );
83
84 /* Bug 3787169. This API takes of removing class attributes from the html
85 before using the same in workflow.
86 */
87 procedure modify_wf_clob_content(
88 p_document IN OUT NOCOPY pa_page_contents.page_content%TYPE
89 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
91 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
92 );
93
94 END pa_workflow_utils;