1 PACKAGE pa_budget_wf AUTHID CURRENT_USER AS
2 /* $Header: PAWFBUVS.pls 120.2 2007/02/06 10:13:20 dthakker ship $ */
3
4 PROCEDURE Select_Budget_Approver
5 (itemtype IN VARCHAR2
6 , itemkey IN VARCHAR2
7 , actid IN NUMBER
8 , funcmode IN VARCHAR2
9 , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10 );
11
12
13 PROCEDURE Verify_Budget_Rules
14 (itemtype IN VARCHAR2
15 , itemkey IN VARCHAR2
16 , actid IN NUMBER
17 , funcmode IN VARCHAR2
18 , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19 );
20
21 PROCEDURE Baseline_Budget
22 (itemtype IN VARCHAR2
23 , itemkey IN VARCHAR2
24 , actid IN NUMBER
25 , funcmode IN VARCHAR2
26 , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
27 );
28
29
30 PROCEDURE Reject_Budget
31 (itemtype IN VARCHAR2
32 , itemkey IN VARCHAR2
33 , actid IN NUMBER
34 , funcmode IN VARCHAR2
35 , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36 );
37
38 PROCEDURE Budget_WF_Is_Used
39 (p_draft_version_id IN NUMBER
40 , p_project_id IN NUMBER
41 , p_budget_type_code IN VARCHAR2
42 , p_pm_product_code IN VARCHAR2
43 , p_fin_plan_type_id IN NUMBER default NULL
44 , p_version_type IN VARCHAR2 default NULL
45 , p_result IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46 , p_err_code IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
47 , p_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48 , p_err_stack IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49 );
50
51 PROCEDURE Start_Budget_WF
52 (p_draft_version_id IN NUMBER
53 , p_project_id IN NUMBER
54 , p_budget_type_code IN VARCHAR2
55 , p_mark_as_original IN VARCHAR2
56 , p_fck_req_flag IN VARCHAR2 DEFAULT NULL
57 , p_bgt_intg_flag IN VARCHAR2 DEFAULT NULL
58 , p_fin_plan_type_id IN NUMBER default NULL
59 , p_version_type IN VARCHAR2 default NULL
60 , p_err_code IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
61 , p_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
62 , p_err_stack IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63 );
64
65 --Name: IS_FEDERAL_ENABLED
66 --Type: Procedure
67 --Description: This procedure is used to find if FV_ENABLED(Federal profile) option is enabled
68 --
69 --Called subprograms: None
70 --
71 --Notes:
72 -- This is called from PA Budget Baseline Workflow to find if Federal Option is enabled. If yes, and also
73 -- if the BEM/Third part interface is successful, then a notification is sent to the Budget Approver to
74 -- inform the Budget Analyst to import the Budget data from Interface tables.
75
76 PROCEDURE IS_FEDERAL_ENABLED
77 (itemtype IN VARCHAR2
78 , itemkey IN VARCHAR2
79 , actid IN NUMBER
80 , funcmode IN VARCHAR2
81 , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82 );
83
84 G_Baselined_By_User_ID pa_budget_versions.baselined_by_person_id%TYPE;
85
86 END pa_budget_wf;