1 PACKAGE PA_AGREEMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: PAINAGRS.pls 120.3 2007/02/07 10:43:40 rgandhi ship $ */
3
4
5 PROCEDURE Insert_Row(
6 X_Rowid IN OUT NOCOPY VARCHAR2,/*File.sql.39*/
7 X_Agreement_Id IN OUT NOCOPY NUMBER,/*File.sql.39*/
8 X_Customer_Id IN NUMBER,
9 X_Agreement_Num IN VARCHAR2,
10 X_Agreement_Type IN VARCHAR2,
11 X_Last_Update_Date IN DATE,
12 X_Last_Updated_By IN NUMBER,
13 X_Creation_Date IN DATE,
14 X_Created_By IN NUMBER,
15 X_Last_Update_Login IN NUMBER,
16 X_Owned_By_Person_Id IN NUMBER,
17 X_Term_Id IN NUMBER,
18 X_Revenue_Limit_Flag IN VARCHAR2,
19 X_Amount IN NUMBER,
20 X_Description IN VARCHAR2,
21 X_Expiration_Date IN DATE,
22 X_Attribute_Category IN VARCHAR2,
23 X_Attribute1 IN VARCHAR2,
24 X_Attribute2 IN VARCHAR2,
25 X_Attribute3 IN VARCHAR2,
26 X_Attribute4 IN VARCHAR2,
27 X_Attribute5 IN VARCHAR2,
28 X_Attribute6 IN VARCHAR2,
29 X_Attribute7 IN VARCHAR2,
30 X_Attribute8 IN VARCHAR2,
31 X_Attribute9 IN VARCHAR2,
32 X_Attribute10 IN VARCHAR2,
33 X_Template_Flag IN VARCHAR2,
34 X_Pm_agreement_reference IN VARCHAR2,
35 X_Pm_Product_Code IN VARCHAR2,
36 X_owning_organization_id IN NUMBER,
37 x_agreement_currency_code IN VARCHAR2,
38 x_invoice_limit_flag IN VARCHAR2,
39 X_org_id IN NUMBER,/* Added for shared Services*/
40 /*Federal*/
41 X_customer_order_number IN VARCHAR2 DEFAULT NULL,
42 X_ADVANCE_REQUIRED IN VARCHAR2 DEFAULT 'N',
43 X_start_date IN DATE DEFAULT NULL,
44 X_Billing_sequence IN NUMBER DEFAULT NULL,
45 X_line_of_account IN VARCHAR2 DEFAULT NULL,
46 X_payment_set_id IN NUMBER DEFAULT NULL,
47 X_advance_amount IN NUMBER DEFAULT NULL,
48 X_attribute11 IN VARCHAR2 DEFAULT NULL,
49 X_attribute12 IN VARCHAR2 DEFAULT NULL,
50 X_attribute13 IN VARCHAR2 DEFAULT NULL,
51 X_attribute14 IN VARCHAR2 DEFAULT NULL,
52 X_attribute15 IN VARCHAR2 DEFAULT NULL,
53 X_attribute16 IN VARCHAR2 DEFAULT NULL,
54 X_attribute17 IN VARCHAR2 DEFAULT NULL,
55 X_attribute18 IN VARCHAR2 DEFAULT NULL,
56 X_attribute19 IN VARCHAR2 DEFAULT NULL,
57 X_attribute20 IN VARCHAR2 DEFAULT NULL,
58 X_attribute21 IN VARCHAR2 DEFAULT NULL,
59 X_attribute22 IN VARCHAR2 DEFAULT NULL,
60 X_attribute23 IN VARCHAR2 DEFAULT NULL,
61 X_attribute24 IN VARCHAR2 DEFAULT NULL,
62 X_attribute25 IN VARCHAR2 DEFAULT NULL
63 );
64
65 PROCEDURE Lock_Row(
66 X_Rowid IN VARCHAR2,
67 X_Agreement_Id IN NUMBER,
68 X_Customer_Id IN NUMBER,
69 X_Agreement_Num IN VARCHAR2,
70 X_Agreement_Type IN VARCHAR2,
71 X_Owned_By_Person_Id IN NUMBER,
72 X_Term_Id IN NUMBER,
73 X_Revenue_Limit_Flag IN VARCHAR2,
74 X_Amount IN NUMBER,
75 X_Description IN VARCHAR2,
76 X_Expiration_Date IN DATE,
77 X_Attribute_Category IN VARCHAR2,
78 X_Attribute1 IN VARCHAR2,
79 X_Attribute2 IN VARCHAR2,
80 X_Attribute3 IN VARCHAR2,
81 X_Attribute4 IN VARCHAR2,
82 X_Attribute5 IN VARCHAR2,
83 X_Attribute6 IN VARCHAR2,
84 X_Attribute7 IN VARCHAR2,
85 X_Attribute8 IN VARCHAR2,
86 X_Attribute9 IN VARCHAR2,
87 X_Attribute10 IN VARCHAR2,
88 X_Template_Flag IN VARCHAR2,
89 X_Pm_agreement_reference IN VARCHAR2,
90 X_Pm_Product_Code IN VARCHAR2,
91 X_owning_organization_id IN NUMBER,
92 x_agreement_currency_code IN VARCHAR2,
93 x_invoice_limit_flag IN VARCHAR2,
94 /*Federal*/
95 X_customer_order_number IN VARCHAR2 DEFAULT NULL,
96 X_ADVANCE_REQUIRED IN VARCHAR2 DEFAULT NULL,
97 X_start_date IN DATE DEFAULT NULL,
98 X_Billing_sequence IN NUMBER DEFAULT NULL,
99 X_line_of_account IN VARCHAR2 DEFAULT NULL,
100 X_payment_set_id IN NUMBER DEFAULT NULL,
101 X_advance_amount IN NUMBER DEFAULT NULL,
102 X_attribute11 IN VARCHAR2 DEFAULT NULL,
103 X_attribute12 IN VARCHAR2 DEFAULT NULL,
104 X_attribute13 IN VARCHAR2 DEFAULT NULL,
105 X_attribute14 IN VARCHAR2 DEFAULT NULL,
106 X_attribute15 IN VARCHAR2 DEFAULT NULL,
107 X_attribute16 IN VARCHAR2 DEFAULT NULL,
108 X_attribute17 IN VARCHAR2 DEFAULT NULL,
109 X_attribute18 IN VARCHAR2 DEFAULT NULL,
110 X_attribute19 IN VARCHAR2 DEFAULT NULL,
111 X_attribute20 IN VARCHAR2 DEFAULT NULL,
112 X_attribute21 IN VARCHAR2 DEFAULT NULL,
113 X_attribute22 IN VARCHAR2 DEFAULT NULL,
114 X_attribute23 IN VARCHAR2 DEFAULT NULL,
115 X_attribute24 IN VARCHAR2 DEFAULT NULL,
116 X_attribute25 IN VARCHAR2 DEFAULT NULL
117 );
118
119
120 PROCEDURE Update_Row(
121 X_Rowid IN VARCHAR2,
122 X_Agreement_Id IN NUMBER,
123 X_Customer_Id IN NUMBER,
124 X_Agreement_Num IN VARCHAR2,
125 X_Agreement_Type IN VARCHAR2,
126 X_Last_Update_Date IN DATE,
127 X_Last_Updated_By IN NUMBER,
128 X_Last_Update_Login IN NUMBER,
129 X_Owned_By_Person_Id IN NUMBER,
130 X_Term_Id IN NUMBER,
131 X_Revenue_Limit_Flag IN VARCHAR2,
132 X_Amount IN NUMBER,
133 X_Description IN VARCHAR2,
134 X_Expiration_Date IN DATE,
135 X_Attribute_Category IN VARCHAR2,
136 X_Attribute1 IN VARCHAR2,
137 X_Attribute2 IN VARCHAR2,
138 X_Attribute3 IN VARCHAR2,
139 X_Attribute4 IN VARCHAR2,
140 X_Attribute5 IN VARCHAR2,
141 X_Attribute6 IN VARCHAR2,
142 X_Attribute7 IN VARCHAR2,
143 X_Attribute8 IN VARCHAR2,
144 X_Attribute9 IN VARCHAR2,
145 X_Attribute10 IN VARCHAR2,
146 X_Template_Flag IN VARCHAR2,
147 X_Pm_agreement_reference IN VARCHAR2,
148 X_Pm_Product_Code IN VARCHAR2,
149 X_owning_organization_id IN NUMBER,
150 x_agreement_currency_code IN VARCHAR2,
151 x_invoice_limit_flag IN VARCHAR2,
152 /*Federal*/
153 x_customer_order_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
154 x_advance_required IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
155 x_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
156 x_Billing_sequence IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
157 x_line_of_account IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
158 x_payment_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
159 x_advance_amount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
160 x_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
161 x_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
162 x_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
163 x_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
164 x_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
165 x_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
166 x_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
170 x_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
167 x_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
168 x_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
169 x_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
171 x_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
172 x_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
173 x_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
174 x_attribute25 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
175
176 );
177 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
178
179 END PA_AGREEMENTS_PKG;