48: WHERE batch_id = l_batch_id;
49: --
50: CURSOR NEXTID IS SELECT wsh_consol_batches_s.nextval FROM sys.dual;
51: begin
52: user_id := FND_GLOBAL.USER_ID;
53: login_id := FND_GLOBAL.LOGIN_ID;
54:
55: IF (X_BATCH_ID is NULL) THEN
56: OPEN NEXTID;
49: --
50: CURSOR NEXTID IS SELECT wsh_consol_batches_s.nextval FROM sys.dual;
51: begin
52: user_id := FND_GLOBAL.USER_ID;
53: login_id := FND_GLOBAL.LOGIN_ID;
54:
55: IF (X_BATCH_ID is NULL) THEN
56: OPEN NEXTID;
57: FETCH NEXTID INTO l_batch_id;