DBA Data[Home] [Help]

PACKAGE: APPS.PA_EXPENDITURE_CATEGORIES_PKG

Source


1 PACKAGE PA_EXPENDITURE_CATEGORIES_PKG AUTHID CURRENT_USER as
2 /* $Header: PAXTECSS.pls 120.1 2005/08/09 04:41:42 avajain noship $ */
3 
4 
5  PROCEDURE Insert_Row( X_Expenditure_Category 	    VARCHAR2,
6 		       X_Last_update_date 	    DATE,
7 		       X_Last_updated_by 	    NUMBER,
8 		       X_Creation_date	 	    DATE,
9 		       X_Created_by 		    NUMBER,
10 		       X_Last_update_login 	    NUMBER,
11 		       X_Start_date_active 	    DATE,
12           	       X_Description 		    VARCHAR2,
13 	               X_End_date_active 	    DATE,
14 		       X_Attribute_category 	    VARCHAR2,
15 		       X_Attribute1 		    VARCHAR2,
16 		       X_Attribute2 		    VARCHAR2,
17 	 	       X_Attribute3 		    VARCHAR2,
18                        X_Attribute4 		    VARCHAR2,
19                        X_Attribute5 		    VARCHAR2,
20                        X_Attribute6 		    VARCHAR2,
21                        X_Attribute7 		    VARCHAR2,
22                        X_Attribute8 		    VARCHAR2,
23                        X_Attribute9 		    VARCHAR2,
24                        X_Attribute10 		    VARCHAR2,
25                        X_Attribute11 		    VARCHAR2,
26                        X_Attribute12 		    VARCHAR2,
27                        X_Attribute13 		    VARCHAR2,
28                        X_Attribute14 		    VARCHAR2,
29                        X_Attribute15		    VARCHAR2,
30 		       X_Return_Status		OUT	 NOCOPY   VARCHAR2,
31 		       X_Msg_Count			OUT	 NOCOPY   NUMBER,
32 		       X_Msg_Data			OUT   NOCOPY   VARCHAR2
33                       );
34 
35   PROCEDURE Lock_Row(  X_Expenditure_Category 	    VARCHAR2,
36 		       X_Last_update_date 	    DATE,
37 		       X_Last_updated_by 	    NUMBER,
38 		       X_Creation_date	 	    DATE,
39 		       X_Created_by 		    NUMBER,
40 		       X_Last_update_login 	    NUMBER,
41 		       X_Start_date_active 	    DATE,
42           	       X_Description 		    VARCHAR2,
43 	               X_End_date_active 	    DATE,
44 		       X_Attribute_category 	    VARCHAR2,
45 		       X_Attribute1 		    VARCHAR2,
46 		       X_Attribute2 		    VARCHAR2,
47 	 	       X_Attribute3 		    VARCHAR2,
48                        X_Attribute4		    VARCHAR2,
49                        X_Attribute5 		    VARCHAR2,
50                        X_Attribute6 		    VARCHAR2,
51                        X_Attribute7		    VARCHAR2,
52                        X_Attribute8 		    VARCHAR2,
53                        X_Attribute9		    VARCHAR2,
54                        X_Attribute10 		    VARCHAR2,
55                        X_Attribute11 		    VARCHAR2,
56                        X_Attribute12 		    VARCHAR2,
57                        X_Attribute13 		    VARCHAR2,
58                        X_Attribute14 		    VARCHAR2,
59                        X_Attribute15		    VARCHAR2,
60 		       X_Return_Status	OUT	 NOCOPY   VARCHAR2,
61 		       X_Msg_Count	OUT	  NOCOPY  NUMBER,
62 		       X_Msg_Data       OUT    NOCOPY     VARCHAR2
63                       );
64 
65 
66  PROCEDURE Update_Row( X_Expenditure_Category 	    VARCHAR2,
67 		       X_Last_update_date 	    DATE,
68 		       X_Last_updated_by 	    NUMBER,
69 		       X_Creation_date	 	    DATE,
70 		       X_Created_by		    NUMBER,
71 		       X_Last_update_login 	    NUMBER,
72 		       X_Start_date_active 	    DATE,
73           	       X_Description		    VARCHAR2,
74 	               X_End_date_active 	    DATE,
75 		       X_Attribute_category 	    VARCHAR2,
76 		       X_Attribute1 		    VARCHAR2,
77 		       X_Attribute2 		    VARCHAR2,
78 	 	       X_Attribute3 		    VARCHAR2,
79                        X_Attribute4 		    VARCHAR2,
80                        X_Attribute5 		    VARCHAR2,
81                        X_Attribute6 		    VARCHAR2,
82                        X_Attribute7 		    VARCHAR2,
83                        X_Attribute8 		    VARCHAR2,
84                        X_Attribute9 		    VARCHAR2,
85                        X_Attribute10 		    VARCHAR2,
86                        X_Attribute11 		    VARCHAR2,
87                        X_Attribute12 		    VARCHAR2,
88                        X_Attribute13 		    VARCHAR2,
89                        X_Attribute14		    VARCHAR2,
90                        X_Attribute15		    VARCHAR2,
91 		       X_Return_Status	OUT	 NOCOPY   VARCHAR2,
92 		       X_Msg_Count	OUT	NOCOPY    NUMBER,
93 		       X_Msg_Data       OUT   NOCOPY      VARCHAR2
94                       );
95 
96 
97 END PA_EXPENDITURE_CATEGORIES_PKG;