DBA Data[Home] [Help]

APPS.OZF_PRICE_LIST_PVT dependencies on FND_GLOBAL

Line 657: FND_GLOBAL.USER_ID,

653: 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),
654: 1,
655: decode( p_OZF_PRICE_LIST_rec.STATUS_DATE, FND_API.G_MISS_DATE, NULL, p_OZF_PRICE_LIST_rec.STATUS_DATE),
656: decode( p_OZF_PRICE_LIST_rec.WF_ITEM_KEY, FND_API.G_MISS_CHAR, NULL, p_OZF_PRICE_LIST_rec.WF_ITEM_KEY),
657: FND_GLOBAL.USER_ID,
658: SYSDATE,
659: SYSDATE,
660: FND_GLOBAL.CONC_LOGIN_ID,
661: FND_GLOBAL.USER_ID);

Line 660: FND_GLOBAL.CONC_LOGIN_ID,

656: decode( p_OZF_PRICE_LIST_rec.WF_ITEM_KEY, FND_API.G_MISS_CHAR, NULL, p_OZF_PRICE_LIST_rec.WF_ITEM_KEY),
657: FND_GLOBAL.USER_ID,
658: SYSDATE,
659: SYSDATE,
660: FND_GLOBAL.CONC_LOGIN_ID,
661: FND_GLOBAL.USER_ID);
662:
663: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
664: RAISE FND_API.G_EXC_ERROR;

Line 661: FND_GLOBAL.USER_ID);

657: FND_GLOBAL.USER_ID,
658: SYSDATE,
659: SYSDATE,
660: FND_GLOBAL.CONC_LOGIN_ID,
661: FND_GLOBAL.USER_ID);
662:
663: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;

Line 792: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

788: OBJECT_VERSION_NUMBER = p_OZF_PRICE_LIST_rec.object_version_number + 1,
789: STATUS_DATE = decode( p_OZF_PRICE_LIST_rec.STATUS_DATE, FND_API.G_MISS_DATE, STATUS_DATE, p_OZF_PRICE_LIST_rec.STATUS_DATE),
790: 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),
791: LAST_UPDATE_DATE = SYSDATE,
792: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
793: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
794: where qp_list_header_id = p_OZF_PRICE_LIST_rec.qp_list_header_id
795: and object_version_number = p_OZF_PRICE_LIST_rec.object_version_number;
796:

Line 793: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

789: STATUS_DATE = decode( p_OZF_PRICE_LIST_rec.STATUS_DATE, FND_API.G_MISS_DATE, STATUS_DATE, p_OZF_PRICE_LIST_rec.STATUS_DATE),
790: 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),
791: LAST_UPDATE_DATE = SYSDATE,
792: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
793: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
794: where qp_list_header_id = p_OZF_PRICE_LIST_rec.qp_list_header_id
795: and object_version_number = p_OZF_PRICE_LIST_rec.object_version_number;
796:
797: IF (SQL%NOTFOUND) THEN