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.OZF_SD_REQUEST_HEADERS_ALL_PKG

Source


1 package OZF_SD_REQUEST_HEADERS_ALL_PKG as
2 /* $Header: ozftsdrs.pls 120.2 2008/02/28 01:23:38 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_REQUEST_HEADER_ID in NUMBER,
6   X_USER_STATUS_ID in NUMBER,
7   X_OBJECT_VERSION_NUMBER in NUMBER,
8   X_REQUEST_ID in NUMBER,
9   X_CREATED_FROM in VARCHAR2,
10   X_REQUEST_NUMBER in VARCHAR2,
11   X_REQUEST_CLASS in VARCHAR2,
12   X_OFFER_TYPE in VARCHAR2,
13   X_OFFER_ID in NUMBER,
14   X_ROOT_REQUEST_HEADER_ID in NUMBER,
15   X_LINKED_REQUEST_HEADER_ID in NUMBER,
16   X_REQUEST_START_DATE in DATE,
17   X_REQUEST_END_DATE in DATE,
18   X_REQUEST_OUTCOME in VARCHAR2,
19   X_DECLINE_REASON_CODE in VARCHAR2,
20   X_RETURN_REASON_CODE in VARCHAR2,
21   X_REQUEST_CURRENCY_CODE in VARCHAR2,
22   X_AUTHORIZATION_NUMBER in VARCHAR2,
23   X_REQUESTED_BUDGET_AMOUNT in NUMBER,
24   X_APPROVED_BUDGET_AMOUNT in NUMBER,
25   X_ATTRIBUTE_CATEGORY in VARCHAR2,
26   X_ATTRIBUTE1 in VARCHAR2,
27   X_ATTRIBUTE2 in VARCHAR2,
28   X_ATTRIBUTE3 in VARCHAR2,
29   X_ATTRIBUTE4 in VARCHAR2,
30   X_ATTRIBUTE5 in VARCHAR2,
31   X_ATTRIBUTE6 in VARCHAR2,
32   X_ATTRIBUTE7 in VARCHAR2,
33   X_ATTRIBUTE8 in VARCHAR2,
34   X_ATTRIBUTE9 in VARCHAR2,
35   X_ATTRIBUTE10 in VARCHAR2,
36   X_ATTRIBUTE11 in VARCHAR2,
37   X_ATTRIBUTE12 in VARCHAR2,
38   X_ATTRIBUTE13 in VARCHAR2,
39   X_ATTRIBUTE14 in VARCHAR2,
40   X_ATTRIBUTE15 in VARCHAR2,
41   X_SUPPLIER_ID in NUMBER,
42   X_SUPPLIER_SITE_ID in NUMBER,
43   X_SUPPLIER_CONTACT_ID in NUMBER,
44   X_REQUEST_BASIS in VARCHAR2,
45   X_SUPPLIER_RESPONSE_DATE in DATE,
46   X_SUPPLIER_SUBMISSION_DATE in DATE,
47   X_REQUESTOR_ID in NUMBER,
48   X_SUPPLIER_QUOTE_NUMBER in VARCHAR2,
49   X_INTERNAL_ORDER_NUMBER in NUMBER,
50   X_SALES_ORDER_CURRENCY in VARCHAR2,
51   X_REQUEST_SOURCE in VARCHAR2,
52   X_ASIGNEE_RESOURCE_ID in NUMBER,
53   X_ACCRUAL_TYPE in VARCHAR2,
54   X_CUST_ACCOUNT_ID in NUMBER,
55   X_SUPPLIER_CONTACT_EMAIL_ADDRE in VARCHAR2,
56   X_SUPPLIER_CONTACT_PHONE_NUMBE in VARCHAR2,
57   X_REQUEST_TYPE_SETUP_ID in NUMBER,
58   X_SUPPLIER_RESPONSE_BY_DATE in DATE,
59   X_INTERNAL_SUBMISSION_DATE in DATE,
60   X_ASIGNEE_RESPONSE_BY_DATE in DATE,
61   X_ASIGNEE_RESPONSE_DATE in DATE,
62   X_SUBMTD_BY_FOR_SUPP_APPROVAL in NUMBER,
63   X_REQUEST_DESCRIPTION in VARCHAR2,
64   X_CREATION_DATE in DATE,
65   X_CREATED_BY in NUMBER,
66   X_LAST_UPDATE_DATE in DATE,
67   X_LAST_UPDATED_BY in NUMBER,
68   X_LAST_UPDATE_LOGIN in NUMBER);
69 procedure LOCK_ROW (
70   X_REQUEST_HEADER_ID in NUMBER,
71   X_USER_STATUS_ID in NUMBER,
72   X_OBJECT_VERSION_NUMBER in NUMBER,
73   X_REQUEST_ID in NUMBER,
74   X_CREATED_FROM in VARCHAR2,
75   X_REQUEST_NUMBER in VARCHAR2,
76   X_REQUEST_CLASS in VARCHAR2,
77   X_OFFER_TYPE in VARCHAR2,
78   X_OFFER_ID in NUMBER,
79   X_ROOT_REQUEST_HEADER_ID in NUMBER,
80   X_LINKED_REQUEST_HEADER_ID in NUMBER,
81   X_REQUEST_START_DATE in DATE,
82   X_REQUEST_END_DATE in DATE,
83   X_REQUEST_OUTCOME in VARCHAR2,
84   X_DECLINE_REASON_CODE in VARCHAR2,
85   X_RETURN_REASON_CODE in VARCHAR2,
86   X_REQUEST_CURRENCY_CODE in VARCHAR2,
87   X_AUTHORIZATION_NUMBER in VARCHAR2,
88   X_REQUESTED_BUDGET_AMOUNT in NUMBER,
89   X_APPROVED_BUDGET_AMOUNT in NUMBER,
90   X_ATTRIBUTE_CATEGORY in VARCHAR2,
91   X_ATTRIBUTE1 in VARCHAR2,
92   X_ATTRIBUTE2 in VARCHAR2,
93   X_ATTRIBUTE3 in VARCHAR2,
94   X_ATTRIBUTE4 in VARCHAR2,
95   X_ATTRIBUTE5 in VARCHAR2,
96   X_ATTRIBUTE6 in VARCHAR2,
97   X_ATTRIBUTE7 in VARCHAR2,
98   X_ATTRIBUTE8 in VARCHAR2,
99   X_ATTRIBUTE9 in VARCHAR2,
100   X_ATTRIBUTE10 in VARCHAR2,
101   X_ATTRIBUTE11 in VARCHAR2,
102   X_ATTRIBUTE12 in VARCHAR2,
103   X_ATTRIBUTE13 in VARCHAR2,
104   X_ATTRIBUTE14 in VARCHAR2,
105   X_ATTRIBUTE15 in VARCHAR2,
106   X_SUPPLIER_ID in NUMBER,
107   X_SUPPLIER_SITE_ID in NUMBER,
108   X_SUPPLIER_CONTACT_ID in NUMBER,
109   X_REQUEST_BASIS in VARCHAR2,
110   X_SUPPLIER_RESPONSE_DATE in DATE,
111   X_SUPPLIER_SUBMISSION_DATE in DATE,
112   X_REQUESTOR_ID in NUMBER,
113   X_SUPPLIER_QUOTE_NUMBER in VARCHAR2,
114   X_INTERNAL_ORDER_NUMBER in NUMBER,
115   X_SALES_ORDER_CURRENCY in VARCHAR2,
116   X_REQUEST_SOURCE in VARCHAR2,
117   X_ASIGNEE_RESOURCE_ID in NUMBER,
118   X_ACCRUAL_TYPE in VARCHAR2,
119   X_CUST_ACCOUNT_ID in NUMBER,
120   X_SUPPLIER_CONTACT_EMAIL_ADDRE in VARCHAR2,
121   X_SUPPLIER_CONTACT_PHONE_NUMBE in VARCHAR2,
122   X_REQUEST_TYPE_SETUP_ID in NUMBER,
123   X_SUPPLIER_RESPONSE_BY_DATE in DATE,
124   X_INTERNAL_SUBMISSION_DATE in DATE,
125   X_ASIGNEE_RESPONSE_BY_DATE in DATE,
126   X_ASIGNEE_RESPONSE_DATE in DATE,
127   X_SUBMTD_BY_FOR_SUPP_APPROVAL in NUMBER,
128   X_REQUEST_DESCRIPTION in VARCHAR2
129 );
130 procedure UPDATE_ROW (
131   X_REQUEST_HEADER_ID in NUMBER,
132   X_USER_STATUS_ID in NUMBER,
133   X_OBJECT_VERSION_NUMBER in NUMBER,
134   X_REQUEST_ID in NUMBER,
135   X_CREATED_FROM in VARCHAR2,
136   X_REQUEST_NUMBER in VARCHAR2,
137   X_REQUEST_CLASS in VARCHAR2,
138   X_OFFER_TYPE in VARCHAR2,
139   X_OFFER_ID in NUMBER,
140   X_ROOT_REQUEST_HEADER_ID in NUMBER,
141   X_LINKED_REQUEST_HEADER_ID in NUMBER,
142   X_REQUEST_START_DATE in DATE,
143   X_REQUEST_END_DATE in DATE,
144   X_REQUEST_OUTCOME in VARCHAR2,
145   X_DECLINE_REASON_CODE in VARCHAR2,
146   X_RETURN_REASON_CODE in VARCHAR2,
147   X_REQUEST_CURRENCY_CODE in VARCHAR2,
148   X_AUTHORIZATION_NUMBER in VARCHAR2,
149   X_REQUESTED_BUDGET_AMOUNT in NUMBER,
150   X_APPROVED_BUDGET_AMOUNT in NUMBER,
151   X_ATTRIBUTE_CATEGORY in VARCHAR2,
152   X_ATTRIBUTE1 in VARCHAR2,
153   X_ATTRIBUTE2 in VARCHAR2,
154   X_ATTRIBUTE3 in VARCHAR2,
155   X_ATTRIBUTE4 in VARCHAR2,
156   X_ATTRIBUTE5 in VARCHAR2,
157   X_ATTRIBUTE6 in VARCHAR2,
158   X_ATTRIBUTE7 in VARCHAR2,
159   X_ATTRIBUTE8 in VARCHAR2,
160   X_ATTRIBUTE9 in VARCHAR2,
161   X_ATTRIBUTE10 in VARCHAR2,
162   X_ATTRIBUTE11 in VARCHAR2,
163   X_ATTRIBUTE12 in VARCHAR2,
164   X_ATTRIBUTE13 in VARCHAR2,
165   X_ATTRIBUTE14 in VARCHAR2,
166   X_ATTRIBUTE15 in VARCHAR2,
167   X_SUPPLIER_ID in NUMBER,
168   X_SUPPLIER_SITE_ID in NUMBER,
169   X_SUPPLIER_CONTACT_ID in NUMBER,
170   X_REQUEST_BASIS in VARCHAR2,
171   X_SUPPLIER_RESPONSE_DATE in DATE,
172   X_SUPPLIER_SUBMISSION_DATE in DATE,
173   X_REQUESTOR_ID in NUMBER,
174   X_SUPPLIER_QUOTE_NUMBER in VARCHAR2,
175   X_INTERNAL_ORDER_NUMBER in NUMBER,
176   X_SALES_ORDER_CURRENCY in VARCHAR2,
177   X_REQUEST_SOURCE in VARCHAR2,
178   X_ASIGNEE_RESOURCE_ID in NUMBER,
179   X_ACCRUAL_TYPE in VARCHAR2,
180   X_CUST_ACCOUNT_ID in NUMBER,
181   X_SUPPLIER_CONTACT_EMAIL_ADDRE in VARCHAR2,
182   X_SUPPLIER_CONTACT_PHONE_NUMBE in VARCHAR2,
183   X_REQUEST_TYPE_SETUP_ID in NUMBER,
184   X_SUPPLIER_RESPONSE_BY_DATE in DATE,
185   X_INTERNAL_SUBMISSION_DATE in DATE,
186   X_ASIGNEE_RESPONSE_BY_DATE in DATE,
187   X_ASIGNEE_RESPONSE_DATE in DATE,
188   X_SUBMTD_BY_FOR_SUPP_APPROVAL in NUMBER,
189   X_REQUEST_DESCRIPTION in VARCHAR2,
190   X_LAST_UPDATE_DATE in DATE,
191   X_LAST_UPDATED_BY in NUMBER,
192   X_LAST_UPDATE_LOGIN in NUMBER
193 );
194 procedure DELETE_ROW (
195   X_REQUEST_HEADER_ID in NUMBER
196 );
197 procedure ADD_LANGUAGE;
198 end OZF_SD_REQUEST_HEADERS_ALL_PKG;