DBA Data[Home] [Help]

APPS.OZF_PRICE_LIST_PVT dependencies on FND_GLOBAL

Line 670: FND_GLOBAL.USER_ID,

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);

Line 673: FND_GLOBAL.CONC_LOGIN_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;

Line 674: FND_GLOBAL.USER_ID);

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;

Line 805: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

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:

Line 806: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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