1 PACKAGE gms_wf_pkg AUTHID CURRENT_USER AS
2 /* $Header: gmsfbuvs.pls 120.0 2005/05/29 12:10:45 appldev noship $ */
3
4 -- Bug 3465169 : This function returns the Burden amount calculated
5 -- for input parameters burdenable_raw_cost,expenditure_type
6 -- organization_id and ind_compiled_set_id.
7 -- This is introduced for performance fix inorder to avoid
8 -- a join with gms_commitment_encumbered_v .
9
10 FUNCTION Get_Burden_amount (p_expenditure_type VARCHAR2,
11 p_organization_id NUMBER,
12 p_ind_compiled_set_id NUMBER,
13 p_burdenable_raw_cost NUMBER) RETURN NUMBER;
14
15
16 PROCEDURE Select_Budget_Approver
17 (itemtype IN VARCHAR2
18 , itemkey IN VARCHAR2
19 , actid IN NUMBER
20 , funcmode IN VARCHAR2
21 , resultout OUT NOCOPY VARCHAR2
22 );
23
24
25 PROCEDURE Verify_Budget_Rules
26 (itemtype IN VARCHAR2
27 , itemkey IN VARCHAR2
28 , actid IN NUMBER
29 , funcmode IN VARCHAR2
30 , resultout OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE Baseline_Budget
34 (itemtype IN VARCHAR2
35 , itemkey IN VARCHAR2
36 , actid IN NUMBER
37 , funcmode IN VARCHAR2
38 , resultout OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE Reject_Budget
42 (itemtype IN VARCHAR2
43 , itemkey IN VARCHAR2
44 , actid IN NUMBER
45 , funcmode IN VARCHAR2
46 , resultout OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE Is_Budget_WF_Used
50 ( p_project_id IN NUMBER
51 , p_award_id IN NUMBER
52 , p_budget_type_code IN VARCHAR2
53 , p_pm_product_code IN VARCHAR2
54 , p_result IN OUT NOCOPY VARCHAR2
55 , p_err_code IN OUT NOCOPY NUMBER
56 , p_err_stage IN OUT NOCOPY VARCHAR2
57 , p_err_stack IN OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE Start_Budget_WF
61 (p_draft_version_id IN NUMBER
62 , p_project_id IN NUMBER
63 , p_award_id IN NUMBER
64 , p_budget_type_code IN VARCHAR2
65 , p_mark_as_original IN VARCHAR2
66 , p_err_code IN OUT NOCOPY NUMBER
67 , p_err_stage IN OUT NOCOPY VARCHAR2
68 , p_err_stack IN OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE Start_Budget_WF_Ntfy_Only
72 (p_draft_version_id IN NUMBER
73 , p_project_id IN NUMBER
74 , p_award_id IN NUMBER
75 , p_budget_type_code IN VARCHAR2
76 , p_mark_as_original IN VARCHAR2
77 , p_err_code IN OUT NOCOPY NUMBER
78 , p_err_stage IN OUT NOCOPY VARCHAR2
79 , p_err_stack IN OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE Select_WF_Process
83 (itemtype IN VARCHAR2
84 ,itemkey IN VARCHAR2
85 ,actid IN NUMBER
86 ,funcmode IN VARCHAR2
87 ,resultout OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE Funds_Check
91 (itemtype IN VARCHAR2
92 , itemkey IN VARCHAR2
93 , actid IN NUMBER
94 , funcmode IN VARCHAR2
95 , resultout OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE Chk_Baselined_Budget_Exists
99 (itemtype IN VARCHAR2
100 , itemkey IN VARCHAR2
101 , actid IN NUMBER
102 , funcmode IN VARCHAR2
103 , resultout OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE Start_Report_WF_Process( x_award_id IN NUMBER
107 ,x_award_number IN VARCHAR2
108 ,x_award_short_name IN VARCHAR2
109 ,x_installment_number IN VARCHAR2
110 ,x_report_name IN VARCHAR2
111 ,x_report_due_date IN VARCHAR2
112 ,x_funding_source_name IN VARCHAR2
113 ,x_role IN VARCHAR2
114 ,x_err_code OUT NOCOPY NUMBER
115 ,x_err_stage OUT NOCOPY VARCHAR2);
116
117 PROCEDURE Schedule_Notification( ERRBUF OUT NOCOPY Varchar2
118 ,RETCODE OUT NOCOPY Varchar2
119 ,p_offset_days IN NUMBER);
120
121
122 PROCEDURE Init_Installment_WF(x_award_id IN NUMBER
123 ,x_installment_id IN NUMBER);
124
125 PROCEDURE Start_Installment_WF( x_award_id IN NUMBER
126 ,x_install_id IN NUMBER
127 ,x_role IN VARCHAR2
128 ,x_err_code OUT NOCOPY NUMBER
129 ,x_err_stage OUT NOCOPY VARCHAR2);
130 /*Start: Build of the installment closeout Nofification Enhancement*/
131
132 /*==================================================================================================================
133 The procedure gets triggered off from the Installment Closeout Notification concurrent request.
134 This procedure selects the installments which are going to end by the offset days and kicks the workflow process.
135 ===================================================================================================================*/
136
137 PROCEDURE Notify_Installment_Closeout(
138 ERRBUF OUT NOCOPY Varchar2
139 ,RETCODE OUT NOCOPY Varchar2
140 ,p_offset_days IN NUMBER );
141
142
143
144 /*==================================================================================================================
145 This procedure is called during the process of displaying the message in the notification .The procedure formats
146 the message and also selects the list of open commitments.
147 ===================================================================================================================*/
148 PROCEDURE Get_Inst_Open_Commitments( document_id IN VARCHAR2
149 ,display_type IN VARCHAR2
150 ,document IN OUT NOCOPY VARCHAR2
151 ,document_type IN OUT NOCOPY VARCHAR2);
152
153
154 /*End: Build of the installment closeout Nofification Enhancement*/
155
156 -----start bug# 3224843 ----
157 /*==========================================================================================
158 This function returns either
159 Y : To exclude person from getting notifications
160 N : To receive notifications.
161 ==========================================================================================*/
162 FUNCTION Excl_Person_From_Notification
163 (p_award_id IN NUMBER,
164 p_user_id IN NUMBER)
165 RETURN VARCHAR2;
166 -----end bug# 3224843 ----
167 END gms_wf_pkg;