DBA Data[Home] [Help]

PACKAGE: APPS.PA_PROJECT_CUSTOMERS_PKG

Source


1 PACKAGE PA_PROJECT_CUSTOMERS_PKG as
2 /* $Header: PAXPRCUS.pls 120.1 2005/08/19 17:17:23 mwasowic noship $ */
3 
4 
5   PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6                        X_Project_Id                     NUMBER,
7                        X_Customer_Id                    NUMBER,
8                        X_Last_Update_Date               DATE,
9                        X_Last_Updated_By                NUMBER,
10                        X_Creation_Date                  DATE,
11                        X_Created_By                     NUMBER,
12                        X_Last_Update_Login              NUMBER,
13                        X_Project_Relationship_Code      VARCHAR2,
14                        X_Customer_Bill_Split            NUMBER,
15 		       X_Bill_To_Customer_Id            NUMBER,
16 		       X_Ship_To_Customer_Id            NUMBER,
17                        X_Bill_To_Address_Id             NUMBER,
18                        X_Ship_To_Address_Id             NUMBER,
19                        X_Inv_Currency_Code              VARCHAR2,
20                        X_Inv_Rate_Type                  VARCHAR2,
21                        X_Inv_Rate_Date                  DATE,
22                        X_Inv_Exchange_Rate              NUMBER,
23                        X_Allow_Inv_User_Rate_Type_Fg    VARCHAR2,
24                        X_Bill_Another_Project_Flag      VARCHAR2,
25                        X_Receiver_Task_Id               NUMBER,
26                        X_Record_Version_Number          NUMBER,
27 		       X_Default_Top_Task_Cust_Flag     VARCHAR2
28                       );
29 
30   PROCEDURE Lock_Row(X_Rowid                            VARCHAR2,
31                      X_Project_Id                       NUMBER,
32                      X_Customer_Id                      NUMBER,
33                      X_Project_Relationship_Code        VARCHAR2,
34                      X_Customer_Bill_Split              NUMBER,
35                      X_Bill_To_Address_Id               NUMBER,
36                      X_Ship_To_Address_Id               NUMBER,
37                      X_Inv_Currency_Code              VARCHAR2,
38                      X_Inv_Rate_Type                  VARCHAR2,
39                      X_Inv_Rate_Date                  DATE,
40                      X_Inv_Exchange_Rate              NUMBER,
41                      X_Allow_Inv_User_Rate_Type_Fg    VARCHAR2,
42                      X_Bill_Another_Project_Flag      VARCHAR2,
43                      X_Receiver_Task_Id               NUMBER,
44                      X_Record_Version_Number          NUMBER,
45                      X_Default_Top_Task_Cust_Flag     VARCHAR2
46                     );
47 
48 
49 
50   PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
51                        X_Project_Id                     NUMBER,
52                        X_Customer_Id                    NUMBER,
53                        X_Last_Update_Date               DATE,
54                        X_Last_Updated_By                NUMBER,
55                        X_Last_Update_Login              NUMBER,
56                        X_Project_Relationship_Code      VARCHAR2,
57                        X_Customer_Bill_Split            NUMBER,
58 		       X_Bill_To_Customer_Id            NUMBER,
59 		       X_Ship_To_Customer_Id            NUMBER,
60                        X_Bill_To_Address_Id             NUMBER,
61                        X_Ship_To_Address_Id             NUMBER,
62                        X_Inv_Currency_Code              VARCHAR2,
63                        X_Inv_Rate_Type                  VARCHAR2,
64                        X_Inv_Rate_Date                  DATE,
65                        X_Inv_Exchange_Rate              NUMBER,
66                        X_Allow_Inv_User_Rate_Type_Fg    VARCHAR2,
67                        X_Bill_Another_Project_Flag      VARCHAR2,
68                        X_Receiver_Task_Id               NUMBER,
69                        X_Record_Version_Number          NUMBER,
70 		       X_Default_Top_Task_Cust_Flag     VARCHAR2
71                       );
72   PROCEDURE Delete_Row(X_Rowid VARCHAR2,
73                        x_record_version_number          NUMBER);
74 
75 END PA_PROJECT_CUSTOMERS_PKG;