[Home] [Help]
PACKAGE: APPS.PA_MC_BILLING_PVT
Source
1 PACKAGE pa_mc_billing_pvt AUTHID CURRENT_USER AS
2 /* $Header: PAMCPVTS.pls 120.3 2005/08/07 22:53:47 lveerubh noship $ */
3
4
5 PROCEDURE get_budget_amount(
6 p_project_id IN NUMBER,
7 p_task_id IN NUMBER,
8 p_psob_id IN NUMBER,
9 p_rsob_id IN NUMBER,
10 p_billing_extension_id IN NUMBER,
11 p_cost_budget_type_code IN VARCHAR2 DEFAULT NULL,
12 p_rev_budget_type_code IN VARCHAR2 DEFAULT NULL,
13 x_revenue_amount OUT NOCOPY NUMBER,
14 x_cost_amount OUT NOCOPY NUMBER,
15 x_cost_budget_type_code OUT NOCOPY VARCHAR2,
16 x_rev_budget_type_code OUT NOCOPY VARCHAR2,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2);
20
21
22 PROCEDURE get_project_task_budget_amount(
23 p_budget_version_id IN NUMBER,
24 p_project_id IN NUMBER,
25 p_task_id IN NUMBER,
26 p_psob_id IN NUMBER,
27 p_rsob_id IN NUMBER,
28 x_raw_cost_total IN OUT NOCOPY NUMBER,
29 x_burdened_cost_total IN OUT NOCOPY NUMBER,
30 x_revenue_total IN OUT NOCOPY NUMBER,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2);
34
35
36 PROCEDURE get_cost_amount(
37 p_project_id IN NUMBER,
38 p_task_id IN NUMBER,
39 p_psob_id IN NUMBER,
40 p_rsob_id IN NUMBER,
41 p_accrue_through_date IN DATE,
42 x_cost_amount OUT NOCOPY NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2);
46
47
48 PROCEDURE get_pot_event_amount(
49 p_project_id IN NUMBER,
50 p_task_id IN NUMBER,
51 p_psob_id IN NUMBER,
52 p_rsob_id IN NUMBER,
53 p_event_id IN NUMBER,
54 p_accrue_through_date IN DATE,
55 x_event_amount OUT NOCOPY NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2);
59
60
61
62 PROCEDURE get_Lowest_amount_left(
63 p_project_id IN NUMBER,
64 p_task_id IN NUMBER,
65 p_psob_id IN NUMBER,
66 p_rsob_id IN NUMBER,
67 p_event_id IN NUMBER,
68 x_funding_amount OUT NOCOPY NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2);
72
73
74 PROCEDURE get_revenue_amount(
75 p_project_id IN NUMBER,
76 p_task_id IN NUMBER,
77 p_psob_id IN NUMBER,
78 p_rsob_id IN NUMBER,
79 p_event_id IN NUMBER,
80 x_revenue_amount OUT NOCOPY NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2);
84
85
86
87 END pa_mc_billing_pvt;