eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OE_AGREEMENTS_PKG

Source


1 package OE_AGREEMENTS_PKG as
2 /* $Header: QPXAGGRS.pls 120.2 2005/12/14 16:22:41 shulin noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY /* file.sql.39 change */ VARCHAR2,
5   X_AGREEMENT_ID in NUMBER,
6   X_TP_ATTRIBUTE2 in VARCHAR2,
7   X_TP_ATTRIBUTE3 in VARCHAR2,
8   X_TP_ATTRIBUTE4 in VARCHAR2,
9   X_TP_ATTRIBUTE5 in VARCHAR2,
10   X_TP_ATTRIBUTE6 in VARCHAR2,
11   X_TP_ATTRIBUTE7 in VARCHAR2,
12   X_TP_ATTRIBUTE8 in VARCHAR2,
13   X_TP_ATTRIBUTE9 in VARCHAR2,
14   X_TP_ATTRIBUTE10 in VARCHAR2,
15   X_TP_ATTRIBUTE11 in VARCHAR2,
16   X_TP_ATTRIBUTE12 in VARCHAR2,
17   X_TP_ATTRIBUTE13 in VARCHAR2,
18   X_TP_ATTRIBUTE14 in VARCHAR2,
19   X_TP_ATTRIBUTE15 in VARCHAR2,
20   X_TP_ATTRIBUTE_CATEGORY in VARCHAR2,
21   X_AGREEMENT_TYPE_CODE in VARCHAR2,
22   X_PRICE_LIST_ID in NUMBER,
23   X_TERM_ID in NUMBER,
24   X_OVERRIDE_IRULE_FLAG in VARCHAR2,
25   X_OVERRIDE_ARULE_FLAG in VARCHAR2,
26   X_SIGNATURE_DATE in DATE,
27   X_AGREEMENT_NUM in VARCHAR2,
28   X_TP_ATTRIBUTE1 in VARCHAR2,
29   X_ATTRIBUTE12 in VARCHAR2,
30   X_ATTRIBUTE13 in VARCHAR2,
31   X_ATTRIBUTE14 in VARCHAR2,
32   X_ATTRIBUTE15 in VARCHAR2,
33   X_ATTRIBUTE11 in VARCHAR2,
34   X_ATTRIBUTE9 in VARCHAR2,
35   X_ATTRIBUTE10 in VARCHAR2,
36   X_REVISION in VARCHAR2,
37   X_REVISION_DATE in DATE,
38   X_REVISION_REASON_CODE in VARCHAR2,
39   X_FREIGHT_TERMS_CODE in VARCHAR2,
40   X_SHIP_METHOD_CODE in VARCHAR2,
41   X_INVOICING_RULE_ID in NUMBER,
42   X_ACCOUNTING_RULE_ID in NUMBER,
43   X_SOLD_TO_ORG_ID in NUMBER,
44   X_PURCHASE_ORDER_NUM in VARCHAR2,
45   X_INVOICE_CONTACT_ID in NUMBER,
46   X_AGREEMENT_CONTACT_ID in NUMBER,
47   X_INVOICE_TO_ORG_ID in NUMBER,
48   X_SALESREP_ID in NUMBER,
49   X_START_DATE_ACTIVE in DATE,
50   X_END_DATE_ACTIVE in DATE,
51   X_COMMENTS in VARCHAR2,
52   X_CONTEXT in VARCHAR2,
53   X_ATTRIBUTE1 in VARCHAR2,
54   X_ATTRIBUTE2 in VARCHAR2,
55   X_ATTRIBUTE3 in VARCHAR2,
56   X_ATTRIBUTE4 in VARCHAR2,
57   X_ATTRIBUTE5 in VARCHAR2,
58   X_ATTRIBUTE6 in VARCHAR2,
59   X_ATTRIBUTE7 in VARCHAR2,
60   X_ATTRIBUTE8 in VARCHAR2,
61   X_NAME in VARCHAR2,
62   X_CREATION_DATE in DATE,
63   X_CREATED_BY in NUMBER,
64   X_LAST_UPDATE_DATE in DATE,
65   X_LAST_UPDATED_BY in NUMBER,
66   X_LAST_UPDATE_LOGIN in NUMBER,
67   X_AGREEMENT_SOURCE_CODE in VARCHAR2, --added by rchellam for OKC
68   X_ORIG_SYSTEM_AGR_ID in NUMBER, --added by rchellam for OKC
69   X_INVOICE_TO_CUSTOMER_ID in NUMBER); -- Added for bug#4029589
70 
71 procedure LOCK_ROW (
72   X_AGREEMENT_ID in NUMBER,
73   X_TP_ATTRIBUTE2 in VARCHAR2,
74   X_TP_ATTRIBUTE3 in VARCHAR2,
75   X_TP_ATTRIBUTE4 in VARCHAR2,
76   X_TP_ATTRIBUTE5 in VARCHAR2,
77   X_TP_ATTRIBUTE6 in VARCHAR2,
78   X_TP_ATTRIBUTE7 in VARCHAR2,
79   X_TP_ATTRIBUTE8 in VARCHAR2,
80   X_TP_ATTRIBUTE9 in VARCHAR2,
81   X_TP_ATTRIBUTE10 in VARCHAR2,
82   X_TP_ATTRIBUTE11 in VARCHAR2,
83   X_TP_ATTRIBUTE12 in VARCHAR2,
84   X_TP_ATTRIBUTE13 in VARCHAR2,
85   X_TP_ATTRIBUTE14 in VARCHAR2,
86   X_TP_ATTRIBUTE15 in VARCHAR2,
87   X_TP_ATTRIBUTE_CATEGORY in VARCHAR2,
88   X_AGREEMENT_TYPE_CODE in VARCHAR2,
89   X_PRICE_LIST_ID in NUMBER,
90   X_TERM_ID in NUMBER,
91   X_OVERRIDE_IRULE_FLAG in VARCHAR2,
92   X_OVERRIDE_ARULE_FLAG in VARCHAR2,
93   X_SIGNATURE_DATE in DATE,
94   X_AGREEMENT_NUM in VARCHAR2,
95   X_TP_ATTRIBUTE1 in VARCHAR2,
96   X_ATTRIBUTE12 in VARCHAR2,
97   X_ATTRIBUTE13 in VARCHAR2,
98   X_ATTRIBUTE14 in VARCHAR2,
99   X_ATTRIBUTE15 in VARCHAR2,
100   X_ATTRIBUTE11 in VARCHAR2,
101   X_ATTRIBUTE9 in VARCHAR2,
102   X_ATTRIBUTE10 in VARCHAR2,
103   X_REVISION in VARCHAR2,
104   X_REVISION_DATE in DATE,
105   X_REVISION_REASON_CODE in VARCHAR2,
106   X_FREIGHT_TERMS_CODE in VARCHAR2,
107   X_SHIP_METHOD_CODE in VARCHAR2,
108   X_INVOICING_RULE_ID in NUMBER,
109   X_ACCOUNTING_RULE_ID in NUMBER,
110   X_SOLD_TO_ORG_ID in NUMBER,
111   X_PURCHASE_ORDER_NUM in VARCHAR2,
112   X_INVOICE_CONTACT_ID in NUMBER,
113   X_AGREEMENT_CONTACT_ID in NUMBER,
114   X_INVOICE_TO_ORG_ID in NUMBER,
115   X_SALESREP_ID in NUMBER,
116   X_START_DATE_ACTIVE in DATE,
117   X_END_DATE_ACTIVE in DATE,
118   X_COMMENTS in VARCHAR2,
119   X_CONTEXT in VARCHAR2,
120   X_ATTRIBUTE1 in VARCHAR2,
121   X_ATTRIBUTE2 in VARCHAR2,
122   X_ATTRIBUTE3 in VARCHAR2,
123   X_ATTRIBUTE4 in VARCHAR2,
124   X_ATTRIBUTE5 in VARCHAR2,
125   X_ATTRIBUTE6 in VARCHAR2,
126   X_ATTRIBUTE7 in VARCHAR2,
127   X_ATTRIBUTE8 in VARCHAR2,
128   X_NAME in VARCHAR2,
129   X_AGREEMENT_SOURCE_CODE in VARCHAR2, --added by rchellam for OKC
130   X_ORIG_SYSTEM_AGR_ID in NUMBER, --added by rchellam for OKC
131   X_INVOICE_TO_CUSTOMER_ID in NUMBER); -- Added for bug#4029589
132 
133 procedure UPDATE_ROW (
134   X_AGREEMENT_ID in NUMBER,
135   X_TP_ATTRIBUTE2 in VARCHAR2,
136   X_TP_ATTRIBUTE3 in VARCHAR2,
137   X_TP_ATTRIBUTE4 in VARCHAR2,
138   X_TP_ATTRIBUTE5 in VARCHAR2,
139   X_TP_ATTRIBUTE6 in VARCHAR2,
140   X_TP_ATTRIBUTE7 in VARCHAR2,
141   X_TP_ATTRIBUTE8 in VARCHAR2,
142   X_TP_ATTRIBUTE9 in VARCHAR2,
143   X_TP_ATTRIBUTE10 in VARCHAR2,
144   X_TP_ATTRIBUTE11 in VARCHAR2,
145   X_TP_ATTRIBUTE12 in VARCHAR2,
146   X_TP_ATTRIBUTE13 in VARCHAR2,
147   X_TP_ATTRIBUTE14 in VARCHAR2,
148   X_TP_ATTRIBUTE15 in VARCHAR2,
149   X_TP_ATTRIBUTE_CATEGORY in VARCHAR2,
150   X_AGREEMENT_TYPE_CODE in VARCHAR2,
151   X_PRICE_LIST_ID in NUMBER,
152   X_TERM_ID in NUMBER,
153   X_OVERRIDE_IRULE_FLAG in VARCHAR2,
154   X_OVERRIDE_ARULE_FLAG in VARCHAR2,
155   X_SIGNATURE_DATE in DATE,
156   X_AGREEMENT_NUM in VARCHAR2,
157   X_TP_ATTRIBUTE1 in VARCHAR2,
158   X_ATTRIBUTE12 in VARCHAR2,
159   X_ATTRIBUTE13 in VARCHAR2,
160   X_ATTRIBUTE14 in VARCHAR2,
161   X_ATTRIBUTE15 in VARCHAR2,
162   X_ATTRIBUTE11 in VARCHAR2,
163   X_ATTRIBUTE9 in VARCHAR2,
164   X_ATTRIBUTE10 in VARCHAR2,
165   X_REVISION in VARCHAR2,
166   X_REVISION_DATE in DATE,
167   X_REVISION_REASON_CODE in VARCHAR2,
168   X_FREIGHT_TERMS_CODE in VARCHAR2,
169   X_SHIP_METHOD_CODE in VARCHAR2,
170   X_INVOICING_RULE_ID in NUMBER,
171   X_ACCOUNTING_RULE_ID in NUMBER,
172   X_SOLD_TO_ORG_ID in NUMBER,
173   X_PURCHASE_ORDER_NUM in VARCHAR2,
174   X_INVOICE_CONTACT_ID in NUMBER,
175   X_AGREEMENT_CONTACT_ID in NUMBER,
176   X_INVOICE_TO_ORG_ID in NUMBER,
177   X_SALESREP_ID in NUMBER,
178   X_START_DATE_ACTIVE in DATE,
179   X_END_DATE_ACTIVE in DATE,
180   X_COMMENTS in VARCHAR2,
181   X_CONTEXT in VARCHAR2,
182   X_ATTRIBUTE1 in VARCHAR2,
183   X_ATTRIBUTE2 in VARCHAR2,
184   X_ATTRIBUTE3 in VARCHAR2,
185   X_ATTRIBUTE4 in VARCHAR2,
186   X_ATTRIBUTE5 in VARCHAR2,
187   X_ATTRIBUTE6 in VARCHAR2,
188   X_ATTRIBUTE7 in VARCHAR2,
189   X_ATTRIBUTE8 in VARCHAR2,
190   X_NAME in VARCHAR2,
191   X_LAST_UPDATE_DATE in DATE,
192   X_LAST_UPDATED_BY in NUMBER,
193   X_LAST_UPDATE_LOGIN in NUMBER,
194   X_AGREEMENT_SOURCE_CODE in VARCHAR2, --added by rchellam for OKC
195   X_ORIG_SYSTEM_AGR_ID in NUMBER, --added by rchellam for OKC
196   X_INVOICE_TO_CUSTOMER_ID in NUMBER); -- Added for bug#4029589
197 
198 procedure DELETE_ROW (
199   X_AGREEMENT_ID in NUMBER
200 );
201 procedure ADD_LANGUAGE;
202 end OE_AGREEMENTS_PKG;