557:
558: UPDATE GMO_DOCUMENT_NUMBERS
559: SET DOC_CURRENTVAL = L_NEXTVAL,
560: LAST_UPDATE_DATE = SYSDATE,
561: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
562: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
563: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
564: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
565:
558: UPDATE GMO_DOCUMENT_NUMBERS
559: SET DOC_CURRENTVAL = L_NEXTVAL,
560: LAST_UPDATE_DATE = SYSDATE,
561: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
562: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
563: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
564: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
565:
566: ELSE
567:
568: UPDATE GMO_DOCUMENT_NUMBERS
569: SET DOC_CURRENTVAL = L_NEXTVAL,
570: LAST_UPDATE_DATE = SYSDATE,
571: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
572: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
573: WHERE ORGANIZATION_ID IS NULL
574: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
575:
568: UPDATE GMO_DOCUMENT_NUMBERS
569: SET DOC_CURRENTVAL = L_NEXTVAL,
570: LAST_UPDATE_DATE = SYSDATE,
571: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
572: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
573: WHERE ORGANIZATION_ID IS NULL
574: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
575:
576: END IF;