[Home] [Help]
PACKAGE: APPS.PA_PROGRESS_REPORT_WORKFLOW
Source
1 PACKAGE pa_progress_report_WORKFLOW AUTHID CURRENT_USER as
2 /* $Header: PAPRWFPS.pls 120.1 2005/08/19 16:45:47 mwasowic noship $ */
3 /*============================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8
9 FILE NAME : PAPRWFPS.pls
10 DESCRIPTION :
11 This file creates package procedures that are called to
12 execute each activity in the Progress Status Workflow.
13
14
15
16 HISTORY : 06/22/00 SYAO Initial Creation
17 =============================================================================*/
18
19 Procedure start_workflow(
20 p_item_type IN VARCHAR2
21 , p_process_name IN VARCHAR2
22
23 , p_version_id IN NUMBER
24
25 , x_item_key OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29 );
30
31 Procedure cancel_workflow (
32 p_Item_type IN VARCHAR2
33 , p_Item_key IN VARCHAR2
34 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
35 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37 );
38
39 Procedure get_workflow_url (
40 p_ItemType IN VARCHAR2
41 , p_ItemKey IN VARCHAR2
42 , x_URL OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
44 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46 );
47
48 PROCEDURE check_progress_status
49 (itemtype IN VARCHAR2
50 ,itemkey IN VARCHAR2
51 ,actid IN NUMBER
52 ,funcmode IN VARCHAR2
53 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
54
55 PROCEDURE change_status_rejected
56 (itemtype IN VARCHAR2
57 ,itemkey IN VARCHAR2
58 ,actid IN NUMBER
59 ,funcmode IN VARCHAR2
60 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
61
62 PROCEDURE change_status_working
63 (itemtype IN VARCHAR2
64 ,itemkey IN VARCHAR2
65 ,actid IN NUMBER
66 ,funcmode IN VARCHAR2
67 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
68
69 PROCEDURE change_status_approved
70 (itemtype IN VARCHAR2
71 ,itemkey IN VARCHAR2
72 ,actid IN NUMBER
73 ,funcmode IN VARCHAR2
74 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
75
76
77 PROCEDURE is_submitter_same_as_reporter
78 (itemtype IN VARCHAR2
79 ,itemkey IN VARCHAR2
80 ,actid IN NUMBER
81 ,funcmode IN VARCHAR2
82 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
83
84 Procedure start_action_set_workflow
85 (
86 p_item_type IN VARCHAR2
87 , p_process_name IN VARCHAR2
88
89 , p_object_type IN VARCHAR2
90 , p_object_id IN NUMBER
91
92 ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
93 ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
94
95 ,x_action_line_audit_tbl out NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type --File.Sql.39 bug 4440895
96 , x_msg_count out NOCOPY NUMBER --File.Sql.39 bug 4440895
97 , x_msg_data out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
99 );
100
101 PROCEDURE set_reminder_report_notify(
102 p_item_type IN VARCHAR2
103 , p_item_key IN NUMBER
104 , p_object_type IN VARCHAR2
105 , p_object_id IN NUMBER
106
107 , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
108 , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
109
110 , x_action_line_audit_tbl out NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type --File.Sql.39 bug 4440895
111 );
112
113 PROCEDURE set_missing_report_notify
114 ( p_item_type IN VARCHAR2
115 , p_item_key IN NUMBER
116 , p_object_type IN VARCHAR2
117 , p_object_id IN NUMBER
118
119 , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
120 , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
121
122 , x_action_line_audit_tbl out NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type --File.Sql.39 bug 4440895
123 );
124
125 PROCEDURE forward_notification(
126 itemtype IN VARCHAR2
127 ,itemkey IN VARCHAR2
128 ,actid IN NUMBER
129 ,funcmode IN VARCHAR2
130 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
131
132 PROCEDURE post_notification(
133 itemtype IN VARCHAR2
134 ,itemkey IN VARCHAR2
135 ,actid IN NUMBER
136 ,funcmode IN VARCHAR2
137 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
138
139 PROCEDURE show_status_report
140 (document_id IN VARCHAR2,
141 display_type IN VARCHAR2,
142 document IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
143 document_type IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
144
145 PROCEDURE show_status_report_cancel
146 (document_id IN VARCHAR2,
147 display_type IN VARCHAR2,
148 document IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
149 document_type IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
150
151 PROCEDURE show_status_report_submit
152 (document_id IN VARCHAR2,
153 display_type IN VARCHAR2,
154 document IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
155 document_type IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
156
157 PROCEDURE show_project_info
158 (document_id IN VARCHAR2,
159 display_type IN VARCHAR2,
160 document IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
161 document_type IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
162
163 PROCEDURE show_report_content
164 (document_id IN VARCHAR2,
165 display_type IN VARCHAR2,
166 document IN OUT NOCOPY clob, --File.Sql.39 bug 4440895
167 document_type IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
168
169
170
171 END pa_progress_report_WORKFLOW;
172