666: decode( p_OZF_PRICE_LIST_rec.QP_LIST_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_OZF_PRICE_LIST_rec.QP_LIST_HEADER_ID),
667: 1,
668: decode( p_OZF_PRICE_LIST_rec.STATUS_DATE, FND_API.G_MISS_DATE, NULL, p_OZF_PRICE_LIST_rec.STATUS_DATE),
669: decode( p_OZF_PRICE_LIST_rec.WF_ITEM_KEY, FND_API.G_MISS_CHAR, NULL, p_OZF_PRICE_LIST_rec.WF_ITEM_KEY),
670: FND_GLOBAL.USER_ID,
671: SYSDATE,
672: SYSDATE,
673: FND_GLOBAL.CONC_LOGIN_ID,
674: FND_GLOBAL.USER_ID);
669: decode( p_OZF_PRICE_LIST_rec.WF_ITEM_KEY, FND_API.G_MISS_CHAR, NULL, p_OZF_PRICE_LIST_rec.WF_ITEM_KEY),
670: FND_GLOBAL.USER_ID,
671: SYSDATE,
672: SYSDATE,
673: FND_GLOBAL.CONC_LOGIN_ID,
674: FND_GLOBAL.USER_ID);
675:
676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
677: RAISE FND_API.G_EXC_ERROR;
670: FND_GLOBAL.USER_ID,
671: SYSDATE,
672: SYSDATE,
673: FND_GLOBAL.CONC_LOGIN_ID,
674: FND_GLOBAL.USER_ID);
675:
676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
677: RAISE FND_API.G_EXC_ERROR;
678: END IF;
801: OBJECT_VERSION_NUMBER = p_OZF_PRICE_LIST_rec.object_version_number + 1,
802: STATUS_DATE = decode( p_OZF_PRICE_LIST_rec.STATUS_DATE, FND_API.G_MISS_DATE, STATUS_DATE, p_OZF_PRICE_LIST_rec.STATUS_DATE),
803: WF_ITEM_KEY = decode( p_OZF_PRICE_LIST_rec.WF_ITEM_KEY, FND_API.G_MISS_CHAR, WF_ITEM_KEY, p_OZF_PRICE_LIST_rec.WF_ITEM_KEY),
804: LAST_UPDATE_DATE = SYSDATE,
805: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
806: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
807: where qp_list_header_id = p_OZF_PRICE_LIST_rec.qp_list_header_id
808: and object_version_number = p_OZF_PRICE_LIST_rec.object_version_number;
809:
802: STATUS_DATE = decode( p_OZF_PRICE_LIST_rec.STATUS_DATE, FND_API.G_MISS_DATE, STATUS_DATE, p_OZF_PRICE_LIST_rec.STATUS_DATE),
803: WF_ITEM_KEY = decode( p_OZF_PRICE_LIST_rec.WF_ITEM_KEY, FND_API.G_MISS_CHAR, WF_ITEM_KEY, p_OZF_PRICE_LIST_rec.WF_ITEM_KEY),
804: LAST_UPDATE_DATE = SYSDATE,
805: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
806: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
807: where qp_list_header_id = p_OZF_PRICE_LIST_rec.qp_list_header_id
808: and object_version_number = p_OZF_PRICE_LIST_rec.object_version_number;
809:
810: IF (SQL%NOTFOUND) THEN