Line 169: CURSOR C2 IS SELECT UMX_REG_REQUESTS_S.nextval FROM sys.dual;
165: l_ame_transaction_type_id VARCHAR2(200);
166:
167: CURSOR C1 IS SELECT rowid FROM UMX_REG_REQUESTS
168: WHERE REG_REQUEST_ID = p_reg_request_id; 169: CURSOR C2 IS SELECT UMX_REG_REQUESTS_S.nextval FROM sys.dual; 170:
171: CURSOR C3 IS SELECT Reg_Request_Id
172: FROM UMX_REG_REQUESTS
173: WHERE Created_By = nvl(FND_GLOBAL.user_id,-1)