PACKAGE: APPS.QUOTATION_APPROVALS_PKG

Source

1 PACKAGE QUOTATION_APPROVALS_PKG as
2 /* $Header: POXAPQPS.pls 120.0 2005/06/02 00:41:43 appldev noship $ */
3 
4 
5   PROCEDURE Insert_Row(	X_Rowid                  IN OUT NOCOPY VARCHAR2,
6 			X_Quotation_Approval_ID  IN OUT	NOCOPY  NUMBER,
7                        	X_Approval_Type			 VARCHAR2,
8 			X_Approval_Reason		 VARCHAR2,
9 			X_Comments			 VARCHAR2,
10 			X_Approver_ID			 NUMBER,
11 			X_Start_Date_Active		 DATE,
12 			X_End_Date_Active		 DATE,
13 			X_Line_Location_ID		 NUMBER,
14                        	X_Last_Update_Date               DATE,
15 			X_Last_Updated_By                NUMBER,
16 			X_Last_Update_Login		 NUMBER,
17                         X_Creation_Date                  DATE,
18                        	X_Created_By                     NUMBER,
19                         X_Attribute_Category		 VARCHAR2,
20 			X_Attribute1			 VARCHAR2,
21 			X_Attribute2			 VARCHAR2,
22 			X_Attribute3			 VARCHAR2,
23 			X_Attribute4			 VARCHAR2,
24 			X_Attribute5			 VARCHAR2,
25 			X_Attribute6			 VARCHAR2,
26 			X_Attribute7			 VARCHAR2,
27 			X_Attribute8			 VARCHAR2,
28 			X_Attribute9			 VARCHAR2,
29 			X_Attribute10			 VARCHAR2,
30                         X_Attribute11			 VARCHAR2,
31 			X_Attribute12			 VARCHAR2,
32 			X_Attribute13			 VARCHAR2,
33 			X_Attribute14			 VARCHAR2,
34                       	X_Attribute15			 VARCHAR2,
35 			X_Request_ID			 NUMBER,
36 			X_Program_Application_ID	 NUMBER,
37 			X_Program_ID			 NUMBER,
38 			X_Program_Update_Date		 DATE,
39                      	X_Org_ID			 NUMBER     --<R12 MOAC> uncommented  /* bug2493519*/
40                         );
41 
42 
43   PROCEDURE Lock_Row(	X_Rowid                          VARCHAR2,
44 			X_Quotation_Approval_ID		 NUMBER,
45                      	X_Approval_Type			 VARCHAR2,
46 			X_Approval_Reason		 VARCHAR2,
47 			X_Comments			 VARCHAR2,
48 			X_Approver_ID			 NUMBER,
49 			X_Start_Date_Active		 DATE,
50 			X_End_Date_Active		 DATE,
51 			X_Line_Location_ID		 NUMBER,
52                        	X_Last_Update_Date               DATE,
53 			X_Last_Updated_By                NUMBER,
54 			X_Last_Update_Login		 NUMBER,
55                         X_Creation_Date                  DATE,
56                        	X_Created_By                     NUMBER,
57                         X_Attribute_Category		 VARCHAR2,
58 			X_Attribute1			 VARCHAR2,
59 			X_Attribute2			 VARCHAR2,
60 			X_Attribute3			 VARCHAR2,
61 			X_Attribute4			 VARCHAR2,
62 			X_Attribute5			 VARCHAR2,
63 			X_Attribute6			 VARCHAR2,
64 			X_Attribute7			 VARCHAR2,
65 			X_Attribute8			 VARCHAR2,
66 			X_Attribute9			 VARCHAR2,
67 			X_Attribute10			 VARCHAR2,
68                         X_Attribute11			 VARCHAR2,
69 			X_Attribute12			 VARCHAR2,
70 			X_Attribute13			 VARCHAR2,
71 			X_Attribute14			 VARCHAR2,
72                       	X_Attribute15			 VARCHAR2,
73 			X_Request_ID			 NUMBER,
74 			X_Program_Application_ID	 NUMBER,
75 			X_Program_ID			 NUMBER,
76 			X_Program_Update_Date		 DATE,
77 			X_Org_ID			 NUMBER     --<R12 MOAC> uncommented /* bug2493519*/
78                         );
79 
80   PROCEDURE Update_Row(	X_Rowid                          VARCHAR2,
81 			X_Quotation_Approval_ID		 NUMBER,
82                        	X_Approval_Type			 VARCHAR2,
83 			X_Approval_Reason		 VARCHAR2,
84 			X_Comments			 VARCHAR2,
85 			X_Approver_ID			 NUMBER,
86 			X_Start_Date_Active		 DATE,
87 			X_End_Date_Active		 DATE,
88 			X_Line_Location_ID		 NUMBER,
89                        	X_Last_Update_Date               DATE,
90 			X_Last_Updated_By                NUMBER,
91 			X_Last_Update_Login		 NUMBER,
92                         X_Attribute_Category		 VARCHAR2,
93 			X_Attribute1			 VARCHAR2,
94 			X_Attribute2			 VARCHAR2,
95 			X_Attribute3			 VARCHAR2,
96 			X_Attribute4			 VARCHAR2,
97 			X_Attribute5			 VARCHAR2,
98 			X_Attribute6			 VARCHAR2,
99 			X_Attribute7			 VARCHAR2,
100 			X_Attribute8			 VARCHAR2,
101 			X_Attribute9			 VARCHAR2,
102 			X_Attribute10			 VARCHAR2,
103                         X_Attribute11			 VARCHAR2,
104 			X_Attribute12			 VARCHAR2,
105 			X_Attribute13			 VARCHAR2,
106 			X_Attribute14			 VARCHAR2,
107                       	X_Attribute15			 VARCHAR2,
108 			X_Request_ID			 NUMBER,
109 			X_Program_Application_ID	 NUMBER,
110 			X_Program_ID			 NUMBER,
111 			X_Program_Update_Date		 DATE
112 		--	X_Org_ID			 NUMBER /* bug2493519*/
113                         );
114 
115 
116   PROCEDURE Delete_Row(X_Rowid VARCHAR2);
117 
118 END QUOTATION_APPROVALS_PKG;