1 package UMX_REG_REQUESTS_PKG AUTHID CURRENT_USER as
2 /* $Header: UMXRGRQS.pls 115.3 2004/01/09 07:44:06 kching noship $ */
3 procedure INSERT_ROW (
4 X_REG_REQUEST_ID in out NOCOPY NUMBER,
5 X_REG_SERVICE_TYPE in VARCHAR2,
6 X_STATUS_CODE in VARCHAR2,
7 X_REQUESTED_BY_USER_ID in NUMBER DEFAULT NULL,
8 X_REQUESTED_FOR_USER_ID in NUMBER DEFAULT NULL,
9 X_REQUESTED_FOR_PARTY_ID in NUMBER DEFAULT NULL,
10 X_REQUESTED_USERNAME in VARCHAR2 DEFAULT NULL,
11 X_REQUESTED_START_DATE in DATE DEFAULT NULL,
12 X_REQUESTED_END_DATE in DATE DEFAULT NULL ,
13 X_WF_ROLE_NAME in VARCHAR2 DEFAULT NULL ,
14 X_REG_SERVICE_CODE in VARCHAR2 DEFAULT NULL,
15 X_AME_APPLICATION_ID in NUMBER DEFAULT NULL ,
16 X_AME_TRANSACTION_TYPE_ID in VARCHAR2 DEFAULT NULL,
17 X_JUSTIFICATION in VARCHAR2 DEFAULT NULL);
18
19 procedure UPDATE_ROW (
20 X_REG_REQUEST_ID in NUMBER,
21 X_STATUS_CODE in VARCHAR2 DEFAULT NULL,
22 X_REQUESTED_BY_USER_ID in NUMBER DEFAULT NULL,
23 X_REQUESTED_FOR_USER_ID in NUMBER DEFAULT NULL,
24 X_REQUESTED_FOR_PARTY_ID in NUMBER DEFAULT NULL,
25 X_REQUESTED_USERNAME in VARCHAR2 DEFAULT NULL,
26 X_REQUESTED_START_DATE in DATE DEFAULT NULL,
27 X_REQUESTED_END_DATE in DATE DEFAULT NULL,
28 X_WF_ROLE_NAME in VARCHAR2 DEFAULT NULL,
29 X_REG_SERVICE_CODE in VARCHAR2 DEFAULT NULL,
30 X_AME_APPLICATION_ID in NUMBER DEFAULT NULL,
31 X_AME_TRANSACTION_TYPE_ID in VARCHAR2 DEFAULT NULL,
32 X_JUSTIFICATION in VARCHAR2 DEFAULT NULL);
33
34 procedure DELETE_ROW (X_REG_REQUEST_ID in NUMBER);
35
36 end UMX_REG_REQUESTS_PKG;