PACKAGE: APPS.PA_BILL_RATES_PKG

Source

1 PACKAGE PA_BILL_RATES_PKG as
2 /* $Header: PASUDBRS.pls 120.1 2005/08/19 17:03:20 mwasowic noship $ */
3 
4   PROCEDURE Insert_Row(X_Rowid                   	IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5 		       X_Bill_Rate_Organization_Id	       NUMBER,
6 		       X_Std_Bill_Rate_Schedule		       VARCHAR2,
7 		       X_Last_Update_Date		       DATE,
8 		       X_Last_Updated_By		       NUMBER,
9 		       X_Creation_Date			       DATE,
10 		       X_Created_By			       NUMBER,
11 		       X_Last_Update_Login		       NUMBER,
12 		       X_Start_Date_Active		       DATE,
13 		       X_Person_Id			       NUMBER,
14 		       X_Job_Id				       NUMBER,
15 		       X_Expenditure_Type		       VARCHAR2,
16 		       X_Non_Labor_Resource		       VARCHAR2,
17 		       X_Rate				       NUMBER,
18 		       X_Bill_Rate_Unit			       VARCHAR2,
19 		       X_Markup_Percentage		       NUMBER,
20 		       X_End_Date_Active		       DATE,
21                        X_Bill_Rate_Sch_Id                      NUMBER,
22                        X_job_group_id                          NUMBER,
23 		       X_Rate_Currency_Code                    VARCHAR2,
24 		       X_Resource_Class_Code                   VARCHAR2,
25 		       X_Res_Class_Organization_Id	       NUMBER
26                       );
27 
28   PROCEDURE Lock_Row(  X_Rowid                    	       VARCHAR2,
29 		       X_Bill_Rate_Organization_Id	       NUMBER,
30 		       X_Std_Bill_Rate_Schedule		       VARCHAR2,
31 		       X_Start_Date_Active		       DATE,
32 		       X_Person_Id			       NUMBER,
33 		       X_Job_Id				       NUMBER,
34 		       X_Expenditure_Type		       VARCHAR2,
35 		       X_Non_Labor_Resource		       VARCHAR2,
36 		       X_Rate				       NUMBER,
37 		       X_Bill_Rate_Unit			       VARCHAR2,
38 		       X_Markup_Percentage		       NUMBER,
39 		       X_End_Date_Active		       DATE,
40 
41 /* Added parameter for Bug 2078409 */
42                        X_Bill_Rate_Sch_Id                      NUMBER,
43 		       X_Rate_Currency_Code                    VARCHAR2,
44        		       X_Resource_Class_Code                   VARCHAR2,
45 		       X_Res_Class_Organization_Id	       NUMBER
46                     );
47 
48   PROCEDURE Update_Row(X_Rowid                        	       VARCHAR2,
49 		       X_Bill_Rate_Organization_Id	       NUMBER,
50 		       X_Std_Bill_Rate_Schedule		       VARCHAR2,
51 		       X_Last_Update_Date		       DATE,
52 		       X_Last_Updated_By		       NUMBER,
53 		       X_Last_Update_Login		       NUMBER,
54 		       X_Start_Date_Active		       DATE,
55 		       X_Person_Id			       NUMBER,
56 		       X_Job_Id				       NUMBER,
57 		       X_Expenditure_Type		       VARCHAR2,
58 		       X_Non_Labor_Resource		       VARCHAR2,
59 		       X_Rate				       NUMBER,
60 		       X_Bill_Rate_Unit			       VARCHAR2,
61 		       X_Markup_Percentage		       NUMBER,
62 		       X_End_Date_Active		       DATE,
63                        X_job_group_id                          NUMBER,
64 		       X_Rate_Currency_Code                    VARCHAR2,
65        		       X_Resource_Class_Code                   VARCHAR2,
66 		       X_Res_Class_Organization_Id	       NUMBER
67                       );
68 
69   PROCEDURE Delete_Row(X_Rowid VARCHAR2);
70 
71 END PA_BILL_RATES_PKG;