APPS.UMX_REG_REQUESTS_PKG dependencies on UMX_REG_REQUESTS_S

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 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),