1 PACKAGE pa_mc_billing_pub AS
2 /* $Header: PAMCPUBS.pls 120.3 2005/08/07 21:31:06 lveerubh noship $ */
3
4
5 PROCEDURE get_budget_amount(
6 p_project_id IN NUMBER,
7 p_project_number IN VARCHAR2 DEFAULT NULL,
8 p_task_id IN NUMBER DEFAULT NULL,
9 P_task_number IN VARCHAR2 DEFAULT NULL,
10 p_psob_id IN NUMBER DEFAULT NULL,
11 p_rsob_id IN NUMBER,
12 p_billing_extension_id IN NUMBER,
13 p_billing_extension_name IN VARCHAR2 DEFAULT NULL,
14 p_cost_budget_type_code IN VARCHAR2 DEFAULT NULL,
15 p_rev_budget_type_code IN VARCHAR2 DEFAULT NULL,
16 x_revenue_amount OUT NOCOPY NUMBER,
17 x_cost_amount OUT NOCOPY NUMBER,
18 x_cost_budget_type_code OUT NOCOPY VARCHAR2,
19 x_rev_budget_type_code OUT NOCOPY VARCHAR2,
20 x_error_message OUT NOCOPY VARCHAR2,
21 x_status OUT NOCOPY NUMBER);
22
23
24 PROCEDURE get_cost_amount(
25 p_project_id IN NUMBER,
26 p_project_number IN VARCHAR2 DEFAULT NULL,
27 p_task_id IN NUMBER DEFAULT NULL,
28 P_task_number IN VARCHAR2 DEFAULT NULL,
29 p_psob_id IN NUMBER DEFAULT NULL,
30 p_rsob_id IN NUMBER,
31 p_accrue_through_date IN DATE DEFAULT NULL,
32 x_cost_amount OUT NOCOPY NUMBER,
33 x_error_message OUT NOCOPY VARCHAR2,
34 x_status OUT NOCOPY NUMBER);
35
36
37 PROCEDURE get_pot_event_amount(
38 p_project_id IN NUMBER,
39 p_project_number IN VARCHAR2 DEFAULT NULL,
40 p_task_id IN NUMBER DEFAULT NULL,
41 P_task_number IN VARCHAR2 DEFAULT NULL,
42 p_psob_id IN NUMBER DEFAULT NULL,
43 p_rsob_id IN NUMBER,
44 p_event_id IN NUMBER,
45 p_accrue_through_date IN DATE DEFAULT NULL,
46 x_event_amount OUT NOCOPY NUMBER,
47 x_error_message OUT NOCOPY VARCHAR2,
48 x_status OUT NOCOPY NUMBER);
49
50
51
52 PROCEDURE get_Lowest_amount_left(
53 p_project_id IN NUMBER,
54 p_project_number IN VARCHAR2 DEFAULT NULL,
55 p_task_id IN NUMBER DEFAULT NULL,
56 P_task_number IN VARCHAR2 DEFAULT NULL,
57 p_psob_id IN NUMBER DEFAULT NULL,
58 p_rsob_id IN NUMBER,
59 p_event_id IN NUMBER,
60 x_funding_amount OUT NOCOPY NUMBER,
61 x_error_message OUT NOCOPY VARCHAR2,
62 x_status OUT NOCOPY NUMBER);
63
64
65 PROCEDURE get_revenue_amount(
66 p_project_id IN NUMBER,
67 p_project_number IN VARCHAR2 DEFAULT NULL,
68 p_task_id IN NUMBER DEFAULT NULL,
69 P_task_number IN VARCHAR2 DEFAULT NULL,
70 p_psob_id IN NUMBER DEFAULT NULL,
71 p_rsob_id IN NUMBER,
72 p_event_id IN NUMBER,
73 x_revenue_amount OUT NOCOPY NUMBER,
74 x_error_message OUT NOCOPY VARCHAR2,
75 x_status OUT NOCOPY NUMBER);
76
77
78
79 END pa_mc_billing_pub;