[Home] [Help]
PACKAGE: APPS.PA_BILLING
Source
1 PACKAGE pa_billing AUTHID CURRENT_USER AS
2 /* $Header: PAXIBILS.pls 120.5.12020000.2 2012/07/19 10:04:37 admarath ship $ */
3 --
4 TYPE GlobalVars IS RECORD
5 ( ProjectId NUMBER(15)
6 , TaskId NUMBER(15)
7 , BillingAssignmentId NUMBER(15)
8 , ReqId NUMBER(15)
9 , CallingPlace VARCHAR2(10)
10 , CallingProcess VARCHAR2(10)
11 , AccrueThruDate VARCHAR2(10)
12 , MassGenFlag VARCHAR2(1)
13 , BillingExtensionId NUMBER(15)
14 , PaDate VARCHAR2(11) /* Added for EPP changes */
15 , InvoiceDate VARCHAR2(30) /* Added for MCB II changes */
16 , GlDate VARCHAR2(11) /* Added for EPP changes */
17 , GlPeriodName VARCHAR2(15) /* Added for EPP changes */
18 , PaPeriodName VARCHAR2(15) /* Added for EPP changes */
19 , BillThruDate VARCHAR2(10) /* Added for Retention Enhancements */
20 , InvoiceSetId NUMBER /* Added for Retention Enhancements */
21 , inv_by_btc_flag VARCHAR2(1) /* Added for Revenue in foreign currency */
22 , mcb_flag VARCHAR2(1) /* Added for Revenue in foreign currency */
23 , pf_curr_code VARCHAR2(15) /* Added for Revenue in foreign currency */
24 , rev_in_txn_curr_flag VARCHAR2(1) /* Added for Revenue in foreign currency */
25 );
26
27
28 GlobVars GlobalVars;
29
30 /* Start of Changes for BUG 8666892 */
31 G_ORG_ID NUMBER(15) := NULL;
32 G_INV_NZ_LINES VARCHAR2(1) := NULL;
33
34 FUNCTION GetInvoiceNZ RETURN VARCHAR2;
35 /* End of Changes for BUG 8666892 */
36
37 PROCEDURE SetMassGen (x_Massgenflag VARCHAR2);
38
39 /* MCB related changes */
40 FUNCTION GetPADate RETURN DATE;
41 pragma RESTRICT_REFERENCES ( GetPADate, WNDS,WNPS );
42
43 FUNCTION GetInvoiceDate RETURN DATE;
44 pragma RESTRICT_REFERENCES ( GetInvoiceDate, WNDS, WNPS );
45
46 FUNCTION GetBillingAssignmentId RETURN NUMBER;
47 pragma RESTRICT_REFERENCES ( GetBillingAssignmentId, WNDS, WNPS ); /* changed from GetInvoiceDate to GetBillingAssignmentId */
48 /* Till Here */
49
50 /* MCB related changes */
51
52 FUNCTION GetGLDate RETURN DATE;
53 pragma RESTRICT_REFERENCES ( GetPADate, WNDS,WNPS );
54
55 FUNCTION GetGLPeriodName RETURN VARCHAR2;
56 pragma RESTRICT_REFERENCES ( GetGlPeriodName, WNDS,WNPS );
57
58 FUNCTION GetPAPeriodName RETURN VARCHAR2;
59 pragma RESTRICT_REFERENCES ( GetPAPeriodName, WNDS,WNPS );
60
61 /* End of EPP changes */
62
63 /* Retention Enhancements Begin */
64
65 FUNCTION GetBillThruDate RETURN VARCHAR2;
66 pragma RESTRICT_REFERENCES ( GetBillThruDate, WNDS, WNPS );
67
68 /* Retention Enhancements End */
69
70 FUNCTION GetMassGen RETURN VARCHAR2;
71 pragma RESTRICT_REFERENCES ( GetMassGen, WNDS, WNPS );
72
73 FUNCTION GetReqId RETURN NUMBER;
74 pragma RESTRICT_REFERENCES ( GetReqId, WNDS, WNPS );
75
76 FUNCTION GetProjId RETURN NUMBER;
77 pragma RESTRICT_REFERENCES ( GetProjId, WNDS, WNPS );
78
79 PROCEDURE SetProjId (x_project_id IN NUMBER); /* Added procedure for bug 7606086*/
80
81 PROCEDURE UpdEvtFlg (x_project_id IN NUMBER); /* Added procedure for Bug 10353589 */
82
83 FUNCTION GetTaskId RETURN NUMBER;
84 pragma RESTRICT_REFERENCES ( GetTaskId, WNDS, WNPS );
85
86 FUNCTION GetCallPlace RETURN VARCHAR2;
87 pragma RESTRICT_REFERENCES ( GetCallPlace, WNDS, WNPS );
88
89 FUNCTION GetCallProcess RETURN VARCHAR2;
90 pragma RESTRICT_REFERENCES ( GetCallProcess, WNDS, WNPS );
91
92 FUNCTION GetBillingExtensionId RETURN NUMBER;
93 pragma RESTRICT_REFERENCES ( GetBillingExtensionId, WNDS, WNPS );
94
95 PROCEDURE bill_ext_driver (
96 x_project_id IN NUMBER,
97 x_calling_process IN VARCHAR2,
98 x_calling_place IN VARCHAR2,
99 x_rev_or_bill_date IN VARCHAR2,
100 x_request_id IN NUMBER,
101 x_error_message IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
102
103 PROCEDURE ccrev( X_project_id IN NUMBER,
104 X_top_task_id IN NUMBER DEFAULT NULL,
105 X_calling_process IN VARCHAR2 DEFAULT NULL,
106 X_calling_place IN VARCHAR2 DEFAULT NULL,
107 X_amount IN NUMBER DEFAULT NULL,
108 X_percentage IN NUMBER DEFAULT NULL,
109 X_rev_or_bill_date IN DATE DEFAULT NULL,
110 X_billing_assignment_id IN NUMBER DEFAULT NULL,
111 X_billing_extension_id IN NUMBER DEFAULT NULL,
112 X_request_id IN NUMBER DEFAULT NULL
113 );
114
115
116 PROCEDURE Delete_Automatic_Events ( X_Project_id NUMBER,
117 X_request_id NUMBER DEFAULT NULL,
118 X_rev_inv_num NUMBER DEFAULT NULL,
119 X_calling_process VARCHAR2);
120
121 PROCEDURE Call_Calc_Bill_Amount(
122 x_transaction_type in varchar2 default 'ACTUAL',
123 x_expenditure_item_id in number,
124 x_sys_linkage_function in varchar2,
125 x_amount in out NOCOPY number, /* This amount is treated as amount in Transaction currency */ --File.Sql.39 bug 4440895
126 x_bill_rate_flag in out NOCOPY varchar2, --File.Sql.39 bug 4440895
127 x_status in out NOCOPY number, --File.Sql.39 bug 4440895
128 x_bill_trans_currency_code out NOCOPY varchar2, --File.Sql.39 bug 4440895
129 x_bill_txn_bill_rate out NOCOPY number, --File.Sql.39 bug 4440895
130 x_markup_percentage out NOCOPY number, --File.Sql.39 bug 4440895
131 x_rate_source_id out NOCOPY number --File.Sql.39 bug 4440895
132 );
133
134 PROCEDURE DUMMY;
135
136
137 /* Billing Enhancement : Added the new parameters */
138
139 PROCEDURE CHECK_SPF_AMOUNTS( X_option in varchar2,
140 X_proj_id in number,
141 X_start_proj_num in varchar2,
142 X_end_proj_num in varchar2);
143
144
145 PROCEDURE Get_WriteOff_Revenue_Amount (p_project_id IN NUMBER DEFAULT NULL,
146 p_task_id IN NUMBER DEFAULT NULL,
147 p_agreement_id IN NUMBER DEFAULT NULL,
148 p_funding_flag IN VARCHAR2 DEFAULT NULL,
149 p_writeoff_amount IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
150 x_projfunc_writeoff_amount OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
151 x_project_writeoff_amount OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
152 x_revproc_writeoff_amount OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
153 );
154 /*Added for bug 2121103*/
155 PROCEDURE forecast_rev_billamount
156 (NC in out NOCOPY number, --File.Sql.39 bug 4440895
157 process_irs in out NOCOPY varchar2, --File.Sql.39 bug 4440895
158 process_bill_rate in out NOCOPY varchar2, --File.Sql.39 bug 4440895
159 message_code in out NOCOPY varchar2, --File.Sql.39 bug 4440895
160 rows_this_time number,
161 error_code in out NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
162 reason in out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
163 bill_amount in out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
164 d_rule_decode in out NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
165 sl_function in out NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
166 ei_id in PA_PLSQL_DATATYPES.IdTabTyp,
167 t_rev_irs_id in out NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
168 rev_comp_set_id in out NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
169 rev_amount in out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
170 mcb_flag in out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
171 x_bill_trans_currency_code in out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
172 ,
173 x_bill_trans_bill_rate in out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
174 x_rate_source_id in out NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
175 x_markup_percentage in out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp);
176
177
178 --
179
180 /* This Procedure is added by Manish Gupta on 08-May-2003 for MRC Schema Elimination Changes */
181 PROCEDURE Get_WriteOff_Rep_Revenue_Amt (p_project_id IN NUMBER DEFAULT NULL,
182 p_task_id IN NUMBER DEFAULT NULL,
183 p_agreement_id IN NUMBER DEFAULT NULL,
184 p_funding_flag IN VARCHAR2 DEFAULT NULL,
185 px_writeoff_amount IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
186 x_rep_projfunc_writeoff_amt OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
187
188 /*Added for non labor client extension*/
189 PROCEDURE Call_Calc_Non_Labor_Bill_Amt
190 (
191 x_transaction_type IN VARCHAR2 DEFAULT 'ACTUAL',
192 x_expenditure_item_id IN NUMBER DEFAULT NULL ,
193 x_sys_linkage_function IN VARCHAR2 DEFAULT NULL ,
194 x_amount IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
195 x_expenditure_type IN VARCHAR2 DEFAULT NULL ,
196 x_non_labor_resource IN VARCHAR2 DEFAULT NULL ,
197 x_non_labor_res_org IN NUMBER DEFAULT NULL ,
198 x_bill_rate_flag IN OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
199 x_status IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
200 x_bill_trans_currency_code OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
201 x_bill_txn_bill_rate OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
202 x_markup_percentage OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
203 x_rate_source_id OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
204
205
206 /*Added for Customer at Top Task changes in FP_M */
207 FUNCTION Validate_Task_Customer(
208 p_project_id IN NUMBER
209 , p_customer_id IN NUMBER
210 , p_task_id IN NUMBER
211 ) RETURN VARCHAR2;
212
213 /* Bug 13680810 Added new procedure */
214 procedure update_globalAttrs(p_Proj_id in number,
215 p_Start_Proj_num in varchar2,
216 p_End_Proj_num in varchar2);
217
218
219
220 END pa_billing;