DBA Data[Home] [Help]

PACKAGE: APPS.PA_AGREEMENTS_PKG

Source


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;