APPS.UMX_REG_REQUESTS_PKG dependencies on UMX_REG_REQUESTS

Line 1: package body UMX_REG_REQUESTS_PKG as

1: package body UMX_REG_REQUESTS_PKG as
2: /* $Header: UMXRGRQB.pls 115.5 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,

Line 19: cursor C is select ROWID from UMX_REG_REQUESTS

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) IS
18:
19: cursor C is select ROWID from UMX_REG_REQUESTS
20: where REG_REQUEST_ID = X_REG_REQUEST_ID;
21:
22: BEGIN
23:

Line 25: select UMX_REG_REQUESTS_S.nextval into X_REG_REQUEST_ID from dual;

21:
22: BEGIN
23:
24: if (X_REG_REQUEST_ID is null) then
25: select UMX_REG_REQUESTS_S.nextval into X_REG_REQUEST_ID from dual;
26: end if;
27:
28: -- do we need to raise a no data found exception??
29:

Line 30: insert into UMX_REG_REQUESTS (

26: end if;
27:
28: -- do we need to raise a no data found exception??
29:
30: insert into UMX_REG_REQUESTS (
31: REG_REQUEST_ID,
32: REG_SERVICE_TYPE,
33: STATUS_CODE,
34: CREATED_BY,

Line 97: UPDATE UMX_REG_REQUESTS SET

93: X_AME_TRANSACTION_TYPE_ID in VARCHAR2 DEFAULT NULL,
94: X_JUSTIFICATION in VARCHAR2 DEFAULT NULL) IS
95: BEGIN
96:
97: UPDATE UMX_REG_REQUESTS SET
98: STATUS_CODE = decode (X_STATUS_CODE, NULL, STATUS_CODE, fnd_api.g_miss_char, NULL, X_STATUS_CODE),
99: LAST_UPDATED_BY = fnd_global.user_id,
100: LAST_UPDATE_DATE = sysdate,
101: REQUESTED_BY_USER_ID = decode (X_REQUESTED_BY_USER_ID, NULL, REQUESTED_BY_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_BY_USER_ID),

Line 121: DELETE FROM UMX_REG_REQUESTS

117:
118: procedure DELETE_ROW (X_REG_REQUEST_ID in NUMBER)IS
119: BEGIN
120:
121: DELETE FROM UMX_REG_REQUESTS
122: WHERE REG_REQUEST_ID = X_REG_REQUEST_ID;
123: if (sql%notfound) then
124: raise no_data_found;
125: end if;

Line 129: end UMX_REG_REQUESTS_PKG;

125: end if;
126:
127: END DELETE_ROW;
128:
129: end UMX_REG_REQUESTS_PKG;