[Home] [Help]
18: p_LAST_UPDATE_DATE DATE,
19: p_LAST_UPDATE_LOGIN NUMBER,
20: p_OBJECT_VERSION_NUMBER NUMBER)
21: IS
22: CURSOR C2 IS SELECT CSI_A_LOCATIONS_S.nextval FROM sys.dual;
23: BEGIN
24: If (px_ASSET_LOCATION_ID IS NULL) OR (px_ASSET_LOCATION_ID = FND_API.G_MISS_NUM) then
25: OPEN C2;
26: FETCH C2 INTO px_ASSET_LOCATION_ID;