1 package pa_billing_core AUTHID CURRENT_USER as
2 -- $Header: PAXINBCS.pls 120.1 2005/08/19 17:14:18 mwasowic noship $
3
4 procedure verify_baseline_funding(
5 x_project_id in number,
6 x_draft_version_id in number,
7 x_entry_level_code in varchar2,
8 x_proj_bu_revenue in number,
9 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
10 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
11 x_err_stack in out NOCOPY varchar2); --File.Sql.39 bug 4440895
12
13 procedure update_funding(
14 x_project_id in number,
15 x_funding_level in out NOCOPY varchar2, --File.Sql.39 bug 4440895
16 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
17 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
18 x_err_stack in out NOCOPY varchar2); --File.Sql.39 bug 4440895
19
20 procedure check_funding_level(
21 x_project_id in number,
22 x_funding_level in out NOCOPY varchar2, --File.Sql.39 bug 4440895
23 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
24 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
25 x_err_stack in out NOCOPY varchar2); --File.Sql.39 bug 4440895
26
27 procedure copy_agreement(
28 x_orig_project_id in number,
29 x_new_project_id in number,
30 x_customer_id in number,
31 x_owning_organization_id in number default null,
32 x_agreement_currency_code in varchar2 default null,
33 x_amount in number default null,
34 x_template_flag in varchar2,
35 x_delta in number,
36 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
37 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
38 x_err_stack in out NOCOPY varchar2); --File.Sql.39 bug 4440895
39
40 procedure copy_funding(
41 x_orig_project_id in number,
42 x_new_project_id in number,
43 x_agreement_id in number,
44 x_delta in number,
45 x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
46 x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
47 x_err_stack in out NOCOPY varchar2); --File.Sql.39 bug 4440895
48
49 Function Check_funding_Exists(x_project_id in number) return varchar2;
50
51 -- These changes are made for FP_M
52 -- Function to check whether Top Task Customer Flag at project level
53 -- can be updateable
54 Function Update_Top_Task_Cust_Flag (
55 P_Project_ID IN Number
56 ) Return Varchar2;
57
58 -- Function to check whether Top Task Invoice Method Flag at project level
59 -- can be updateable
60 Function Update_Top_Task_Inv_Mthd_Flag (
61 P_Project_ID IN Number
62 ) Return Varchar2;
63
64 -- Function to check whether the combination of Invoice and Revenue
65 -- methods are existing in Project Type distribution rules or not
66 Function Check_Revenue_Invoice_Methods (
67 P_Project_ID IN Number
68 ) Return Varchar2;
69
70 -- Check required at Top Task level
71 -- Function to check whether Top Task Customer can be updateable
72 -- at Task level window
73 Function Update_Top_Task_Customer (
74 P_Project_ID IN Number,
75 P_Task_ID IN Number
76 ) Return Varchar2;
77
78 -- Function to check whether Top Task Invoice Method can be updateable
79 -- at Task level window
80 Function Update_Top_Task_Invoice_Method (
81 P_Project_ID IN Number,
82 P_Task_ID IN Number
83 ) Return Varchar2;
84
85 end pa_billing_core ;