PACKAGE: APPS.PO_AGENTS_PKG

Source

1 PACKAGE PO_AGENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: POXTIDBS.pls 115.2 2002/11/23 01:22:02 sbull ship $ */
3 
4 
5   PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
6                        X_Agent_Id                	NUMBER,
7                        X_Last_Update_Date               DATE,
8                        X_Last_Updated_By                NUMBER,
9 		       X_Last_Update_Login              NUMBER,
10                        X_Creation_Date                  DATE,
11                        X_Created_By                     NUMBER,
12                        X_Location_ID		        NUMBER,
13                        X_Category_ID			NUMBER,
14 		       X_Authorization_Limit		NUMBER,
15 		       X_Start_Date_Active		DATE,
16 		       X_End_Date_Active		DATE,
17 		       X_Attribute_Category		VARCHAR2,
18 		       X_Attribute1			VARCHAR2,
19 		       X_Attribute2			VARCHAR2,
20 		       X_Attribute3			VARCHAR2,
21 		       X_Attribute4			VARCHAR2,
22 		       X_Attribute5			VARCHAR2,
23 		       X_Attribute6			VARCHAR2,
24 		       X_Attribute7			VARCHAR2,
25 		       X_Attribute8			VARCHAR2,
26 		       X_Attribute9			VARCHAR2,
27                        X_Attribute10			VARCHAR2,
28 		       X_Attribute11			VARCHAR2,
29 		       X_Attribute12			VARCHAR2,
30 		       X_Attribute13			VARCHAR2,
31 		       X_Attribute14			VARCHAR2,
32 		       X_Attribute15			VARCHAR2);
33 
34 
35   PROCEDURE Lock_Row(X_Rowid                        	VARCHAR2,
36                      X_Agent_ID                		NUMBER,
37 		     X_Last_Update_Login		NUMBER,
38                      X_Location_ID		        NUMBER,
39                      X_Category_ID			NUMBER,
40 		     X_Authorization_Limit		NUMBER,
41 		     X_Start_Date_Active		DATE,
42 		     X_End_Date_Active			DATE,
43 		     X_Attribute_Category		VARCHAR2,
44 		     X_Attribute1			VARCHAR2,
45 		     X_Attribute2			VARCHAR2,
46 		     X_Attribute3			VARCHAR2,
47 		     X_Attribute4			VARCHAR2,
48 		     X_Attribute5			VARCHAR2,
49 		     X_Attribute6			VARCHAR2,
50 		     X_Attribute7			VARCHAR2,
51 		     X_Attribute8			VARCHAR2,
52 		     X_Attribute9			VARCHAR2,
53                      X_Attribute10			VARCHAR2,
54 		     X_Attribute11			VARCHAR2,
55 		     X_Attribute12			VARCHAR2,
56 		     X_Attribute13			VARCHAR2,
57 		     X_Attribute14			VARCHAR2,
58 		     X_Attribute15			VARCHAR2);
59 
60   PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
61                        X_Agent_Id                	NUMBER,
62                        X_Last_Update_Date               DATE,
63                        X_Last_Updated_By                NUMBER,
64 		       X_Last_Update_Login              NUMBER,
65                        X_Location_ID		        NUMBER,
66                        X_Category_ID			NUMBER,
67 		       X_Authorization_Limit		NUMBER,
68 		       X_Start_Date_Active		DATE,
69 		       X_End_Date_Active		DATE,
70 		       X_Attribute_Category		VARCHAR2,
71 		       X_Attribute1			VARCHAR2,
72 		       X_Attribute2			VARCHAR2,
73 		       X_Attribute3			VARCHAR2,
74 		       X_Attribute4			VARCHAR2,
75 		       X_Attribute5			VARCHAR2,
76 		       X_Attribute6			VARCHAR2,
77 		       X_Attribute7			VARCHAR2,
78 		       X_Attribute8			VARCHAR2,
79 		       X_Attribute9			VARCHAR2,
80                        X_Attribute10			VARCHAR2,
81 		       X_Attribute11			VARCHAR2,
82 		       X_Attribute12			VARCHAR2,
83 		       X_Attribute13			VARCHAR2,
84 		       X_Attribute14			VARCHAR2,
85 		       X_Attribute15			VARCHAR2);
86 
87 
88   PROCEDURE Delete_Row(X_Rowid VARCHAR2);
89 
90 END PO_AGENTS_PKG;