eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PA_BILLING

Source


1 PACKAGE pa_billing AS
2 /* $Header: PAXIBILS.pls 120.2 2005/08/19 17:14:01 mwasowic noship $ */
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 
31    PROCEDURE SetMassGen (x_Massgenflag VARCHAR2);
32 
33    /* MCB related changes */
34    FUNCTION  GetPADate  RETURN DATE;
35    pragma RESTRICT_REFERENCES ( GetPADate, WNDS,WNPS );
36 
37    FUNCTION  GetInvoiceDate  RETURN DATE;
38    pragma RESTRICT_REFERENCES ( GetInvoiceDate, WNDS, WNPS );
39 
40    FUNCTION GetBillingAssignmentId RETURN NUMBER;
41    pragma RESTRICT_REFERENCES ( GetBillingAssignmentId, WNDS, WNPS ); /* changed from GetInvoiceDate to GetBillingAssignmentId */
42    /* Till Here */
43 
44    /* MCB related changes */
45 
46    FUNCTION  GetGLDate  RETURN DATE;
47    pragma RESTRICT_REFERENCES ( GetPADate, WNDS,WNPS );
48 
49    FUNCTION  GetGLPeriodName  RETURN VARCHAR2;
50    pragma RESTRICT_REFERENCES ( GetGlPeriodName, WNDS,WNPS );
51 
52    FUNCTION  GetPAPeriodName  RETURN VARCHAR2;
53    pragma RESTRICT_REFERENCES ( GetPAPeriodName, WNDS,WNPS );
54 
55   /* End of EPP changes */
56 
57    /* Retention Enhancements Begin */
58 
59     FUNCTION  GetBillThruDate RETURN VARCHAR2;
60     pragma RESTRICT_REFERENCES ( GetBillThruDate, WNDS, WNPS );
61 
62     /* Retention Enhancements End */
63 
64    FUNCTION  GetMassGen  RETURN VARCHAR2;
65    pragma RESTRICT_REFERENCES ( GetMassGen, WNDS, WNPS );
66 
67    FUNCTION  GetReqId  RETURN NUMBER;
68    pragma RESTRICT_REFERENCES ( GetReqId, WNDS, WNPS );
69 
70    FUNCTION  GetProjId  RETURN NUMBER;
71    pragma RESTRICT_REFERENCES ( GetProjId, WNDS, WNPS );
72 
73    FUNCTION  GetTaskId  RETURN NUMBER;
74    pragma RESTRICT_REFERENCES ( GetTaskId, WNDS, WNPS );
75 
76    FUNCTION  GetCallPlace  RETURN VARCHAR2;
77    pragma RESTRICT_REFERENCES ( GetCallPlace, WNDS, WNPS );
78 
79    FUNCTION  GetCallProcess RETURN VARCHAR2;
80    pragma RESTRICT_REFERENCES ( GetCallProcess, WNDS, WNPS );
81 
82    FUNCTION  GetBillingExtensionId RETURN NUMBER;
83    pragma RESTRICT_REFERENCES ( GetBillingExtensionId, WNDS, WNPS );
84 
85    PROCEDURE bill_ext_driver (
86 		   x_project_id        IN     NUMBER,
87                    x_calling_process   IN     VARCHAR2,
88                    x_calling_place     IN     VARCHAR2,
89                    x_rev_or_bill_date  IN     VARCHAR2,
90                    x_request_id        IN     NUMBER,
91                    x_error_message     IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
92 
93    PROCEDURE  ccrev(	X_project_id               IN     NUMBER,
94 	             	X_top_task_id              IN     NUMBER DEFAULT NULL,
95                      	X_calling_process          IN     VARCHAR2 DEFAULT NULL,
96                      	X_calling_place            IN     VARCHAR2 DEFAULT NULL,
97                      	X_amount                   IN     NUMBER DEFAULT NULL,
98                      	X_percentage               IN     NUMBER DEFAULT NULL,
99                      	X_rev_or_bill_date         IN     DATE DEFAULT NULL,
100                      	X_billing_assignment_id    IN     NUMBER DEFAULT NULL,
101                      	X_billing_extension_id     IN     NUMBER DEFAULT NULL,
102                      	X_request_id               IN     NUMBER DEFAULT NULL
103                      );
104 
105 
106 PROCEDURE Delete_Automatic_Events ( 	X_Project_id	NUMBER,
107 					X_request_id	NUMBER DEFAULT NULL,
108 					X_rev_inv_num	NUMBER DEFAULT NULL,
109 					X_calling_process	VARCHAR2);
110 
111 PROCEDURE Call_Calc_Bill_Amount(
112                                 x_transaction_type         in varchar2 default 'ACTUAL',
113 				x_expenditure_item_id      in number,
114                               	x_sys_linkage_function     in varchar2,
115                               	x_amount                   in out NOCOPY number, /* This amount is treated as amount in Transaction currency */ --File.Sql.39 bug 4440895
116                               	x_bill_rate_flag           in out NOCOPY varchar2, --File.Sql.39 bug 4440895
117                               	x_status                   in out NOCOPY number,     --File.Sql.39 bug 4440895
118                               	x_bill_trans_currency_code out NOCOPY varchar2,     --File.Sql.39 bug 4440895
119                               	x_bill_txn_bill_rate       out NOCOPY number,     --File.Sql.39 bug 4440895
120                               	x_markup_percentage        out NOCOPY number,     --File.Sql.39 bug 4440895
121                               	x_rate_source_id           out NOCOPY number     --File.Sql.39 bug 4440895
122                                 );
123 
124 PROCEDURE DUMMY;
125 
126 
127 /* Billing Enhancement : Added the new parameters */
128 
129 PROCEDURE CHECK_SPF_AMOUNTS( X_option            in varchar2,
130                              X_proj_id           in number,
131                              X_start_proj_num    in varchar2,
132                              X_end_proj_num      in varchar2);
133 
134 
135 PROCEDURE  Get_WriteOff_Revenue_Amount (p_project_id               IN  NUMBER DEFAULT NULL,
136                                         p_task_id                  IN  NUMBER DEFAULT NULL,
137                                         p_agreement_id             IN  NUMBER DEFAULT NULL,
138                                         p_funding_flag             IN  VARCHAR2 DEFAULT NULL,
139                                         p_writeoff_amount          IN  OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
140                                         x_projfunc_writeoff_amount OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141                                         x_project_writeoff_amount  OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
142                                         x_revproc_writeoff_amount  OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
143                                          );
144 /*Added for bug 2121103*/
145 PROCEDURE forecast_rev_billamount
146 	      (NC in out NOCOPY number, --File.Sql.39 bug 4440895
147 	       process_irs in out NOCOPY varchar2, --File.Sql.39 bug 4440895
148 	       process_bill_rate  in out NOCOPY varchar2, --File.Sql.39 bug 4440895
149 	       message_code in out  NOCOPY varchar2, --File.Sql.39 bug 4440895
150 	       rows_this_time  number,
151 	       error_code in out  NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
152 	       reason     in out  NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153 	       bill_amount in out   NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
154 	       d_rule_decode in out  NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155 	       sl_function in out  NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156 	       ei_id in  PA_PLSQL_DATATYPES.IdTabTyp,
157 	       t_rev_irs_id in out   NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
158 	       rev_comp_set_id in out   NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
159 	       rev_amount     in out  NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
160 	       mcb_flag     in out  NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
161                x_bill_trans_currency_code in out  NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
162 ,
163                x_bill_trans_bill_rate in out   NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
164                x_rate_source_id in out   NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
165                x_markup_percentage in out   NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp);
166 
167 
168 --
169 
170 /* This Procedure is added by Manish Gupta on 08-May-2003 for MRC Schema Elimination Changes */
171 PROCEDURE  Get_WriteOff_Rep_Revenue_Amt (p_project_id               IN     NUMBER DEFAULT NULL,
172                                          p_task_id                  IN     NUMBER DEFAULT NULL,
173                                          p_agreement_id             IN     NUMBER DEFAULT NULL,
174                                          p_funding_flag             IN     VARCHAR2 DEFAULT NULL,
175                                          px_writeoff_amount         IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
176                                          x_rep_projfunc_writeoff_amt OUT   NOCOPY NUMBER ); --File.Sql.39 bug 4440895
177 
178 /*Added for non labor client extension*/
179 PROCEDURE Call_Calc_Non_Labor_Bill_Amt
180 (
181 x_transaction_type      IN      VARCHAR2 DEFAULT 'ACTUAL',
182 x_expenditure_item_id   IN      NUMBER DEFAULT NULL ,
183 x_sys_linkage_function  IN      VARCHAR2 DEFAULT NULL ,
184 x_amount                IN OUT  NOCOPY NUMBER , --File.Sql.39 bug 4440895
185 x_expenditure_type      IN      VARCHAR2 DEFAULT NULL ,
186 x_non_labor_resource    IN      VARCHAR2 DEFAULT NULL ,
187 x_non_labor_res_org     IN      NUMBER DEFAULT NULL ,
188 x_bill_rate_flag        IN OUT  NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
189 x_status                IN OUT  NOCOPY NUMBER , --File.Sql.39 bug 4440895
190 x_bill_trans_currency_code      OUT     NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
191 x_bill_txn_bill_rate    OUT     NOCOPY NUMBER , --File.Sql.39 bug 4440895
192 x_markup_percentage     OUT     NOCOPY NUMBER , --File.Sql.39 bug 4440895
193 x_rate_source_id        OUT     NOCOPY NUMBER ); --File.Sql.39 bug 4440895
194 
195 
196 /*Added for Customer at Top Task changes in FP_M */
197  FUNCTION  Validate_Task_Customer(
198            p_project_id           IN       NUMBER
199            , p_customer_id        IN       NUMBER
200            , p_task_id            IN       NUMBER
201 ) RETURN VARCHAR2;
202 
203 
204 END pa_billing;