1 PACKAGE pa_revenue_amt AUTHID CURRENT_USER AS
2 /*$Header: PAXIIRSS.pls 120.2 2008/07/25 07:49:14 hkansal ship $ */
3
4 -- Table type definitions to hold host array that will be passed from Pro *c
5 --
6 TYPE t_int IS TABLE OF INTEGER
7 INDEX BY BINARY_INTEGER;
8 TYPE t_varchar_30 IS TABLE OF VARCHAR2(30)
9 INDEX BY BINARY_INTEGER;
10 TYPE t_varchar_2 IS TABLE OF VARCHAR2(2)
11 INDEX BY BINARY_INTEGER;
12 TYPE t_varchar_13 IS TABLE OF VARCHAR2(13)
13 INDEX BY BINARY_INTEGER;
14 /* 658088 */
15 TYPE t_varchar_100 IS TABLE OF VARCHAR2(100)
16 INDEX BY BINARY_INTEGER;
17 /*Added for nonlabor client extension*/
18 TYPE t_varchar_20 IS TABLE OF VARCHAR2(20)
19 INDEX BY BINARY_INTEGER;
20 /*End of change for nonlabor client extension*/
21 /*** Start MCB Changes ***/
22
23 TYPE t_varchar_15 IS TABLE OF VARCHAR2(15)
24 INDEX BY BINARY_INTEGER;
25
26 /*** End MCB Changes ***/
27
28
29
30 PROCEDURE get_irs_amt (
31 process_irs OUT NOCOPY VARCHAR2,
32 process_bill_rate OUT NOCOPY VARCHAR2,
33 message_code OUT NOCOPY VARCHAR2,
34 rows_this_time IN INTEGER,
35 error_code IN OUT NOCOPY t_int,
36 reason OUT NOCOPY t_varchar_30,
37 bill_amount OUT NOCOPY t_varchar_100, /* for bug 7232008 */
38 rev_amount OUT NOCOPY t_varchar_30,
39 inv_amount OUT NOCOPY t_varchar_30,
40 d_rule_decode IN OUT NOCOPY t_int,
41 sl_function IN OUT NOCOPY t_int,
42 ei_id IN OUT NOCOPY t_int,
43 t_rev_irs_id IN OUT NOCOPY t_int,
44 t_inv_irs_id IN OUT NOCOPY t_int,
45 rev_comp_set_id IN OUT NOCOPY t_int,
46 inv_comp_set_id IN OUT NOCOPY t_int,
47 bill_rate_markup OUT NOCOPY t_varchar_2,
48 t_lab_sch IN t_varchar_2,
49 t_nlab_sch IN t_varchar_2,
50 p_mcb_flag IN VARCHAR2,
51 x_bill_trans_currency_code IN OUT NOCOPY t_varchar_15, /* MCB Changes start */
52 x_bill_txn_bill_rate IN OUT NOCOPY t_varchar_30,
53 x_rate_source_id IN OUT NOCOPY t_int,
54 x_markup_percentage IN OUT NOCOPY t_varchar_30, /* MCB Changes end */
55 x_exp_type IN t_varchar_30, /*change for nonlabor client extension */
56 x_nl_resource IN t_varchar_20,
57 x_nl_res_org_id IN t_int /*End of change for nonlabor client extension*/
58 );
59
60 /* The following Signature of PROCEDURE get_irs_amt is added for Bug 2517675.
61 !!!This is overloaded procedure for compilation of pro*c files of Patchset H.
62 !!!Note: This .pls with overload function should not be sent along with
63 the patch for Patchset H customers */
64
65 PROCEDURE get_irs_amt (
66 process_irs OUT NOCOPY VARCHAR2,
67 process_bill_rate OUT NOCOPY VARCHAR2,
68 message_code OUT NOCOPY VARCHAR2,
69 rows_this_time IN INTEGER,
70 error_code IN OUT NOCOPY t_int,
71 reason OUT NOCOPY t_varchar_30,
72 bill_amount OUT NOCOPY t_varchar_30,
73 rev_amount OUT NOCOPY t_varchar_30,
74 inv_amount OUT NOCOPY t_varchar_30,
75 d_rule_decode IN OUT NOCOPY t_int,
76 sl_function IN OUT NOCOPY t_int,
77 ei_id IN OUT NOCOPY t_int,
78 t_rev_irs_id IN OUT NOCOPY t_int,
79 t_inv_irs_id IN OUT NOCOPY t_int,
80 rev_comp_set_id IN OUT NOCOPY t_int,
81 inv_comp_set_id IN OUT NOCOPY t_int,
82 bill_rate_markup OUT NOCOPY t_varchar_2,
83 t_lab_sch IN t_varchar_2,
84 t_nlab_sch IN t_varchar_2
85 );
86
87 /* Bug 2517675 -End */
88 /*This procedure is overloaded for patchset L changes(nonlabor client extension)*/
89 PROCEDURE get_irs_amt
90 (
91 process_irs OUT NOCOPY VARCHAR2,
92 process_bill_rate OUT NOCOPY VARCHAR2,
93 message_code OUT NOCOPY VARCHAR2,
94 rows_this_time IN INTEGER,
95 error_code IN OUT NOCOPY t_int,
96 reason OUT NOCOPY t_varchar_30,
97 bill_amount OUT NOCOPY t_varchar_30,
98 rev_amount OUT NOCOPY t_varchar_30,
99 inv_amount OUT NOCOPY t_varchar_30,
100 d_rule_decode IN OUT NOCOPY t_int,
101 sl_function IN OUT NOCOPY t_int,
102 ei_id IN OUT NOCOPY t_int,
103 t_rev_irs_id IN OUT NOCOPY t_int,
104 t_inv_irs_id IN OUT NOCOPY t_int,
105 rev_comp_set_id IN OUT NOCOPY t_int,
106 inv_comp_set_id IN OUT NOCOPY t_int,
107 bill_rate_markup OUT NOCOPY t_varchar_2,
108 t_lab_sch IN t_varchar_2,
109 t_nlab_sch IN t_varchar_2,
110 p_mcb_flag IN VARCHAR2,
111 x_bill_trans_currency_code IN OUT NOCOPY t_varchar_15, /* MCB Chnages start */
112 x_bill_txn_bill_rate IN OUT NOCOPY t_varchar_30,
113 x_rate_source_id IN OUT NOCOPY t_int,
114 x_markup_percentage IN OUT NOCOPY t_varchar_30); /* MCB Changes end */
115
116 PROCEDURE adjust_rounding_error
117 (
118 p_project_id IN NUMBER,
119 p_request_id IN NUMBER,
120 p_task_level_funding IN NUMBER ,
121 x_max_items_allowed IN NUMBER ,
122 x_message_code OUT NOCOPY VARCHAR2 ,
123 x_total_exp_items OUT NOCOPY NUMBER,
124 x_exp_item_list OUT NOCOPY t_varchar_100
125 );
126
127 PROCEDURE rev_ccid_chk(P_rec_ccid IN NUMBER,
128 P_rev_ccid IN NUMBER,
129 P_rg_ccid IN NUMBER,
130 P_rl_ccid IN NUMBER,
131 P_ou_reval_flag IN VARCHAR2,
132 P_out_status OUT NOCOPY VARCHAR2
133 );
134
135
136
137 END pa_revenue_amt;