APPS.OZF_PRICE_LIST_PVT dependencies on OZF_PRICE_LIST_ATTRIBUTES

Line 44: 'OZF_PRICE_LIST_ATTRIBUTES',

40: AND p_ozf_price_list_rec.price_list_attribute_id IS NOT NULL AND p_ozf_price_list_rec.price_list_attribute_id <> FND_API.G_MISS_NUM
41: THEN
42: l_uk_flag := OZF_Utility_PVT.check_uniqueness
43: (
44: 'OZF_PRICE_LIST_ATTRIBUTES',
45: 'price_list_attribute_id = ' || p_ozf_price_list_rec.price_list_attribute_id
46: );
47: END IF;
48: IF l_uk_flag = FND_API.g_false THEN

Line 64: 'OZF_PRICE_LIST_ATTRIBUTES',

60: AND p_ozf_price_list_rec.qp_list_header_id IS NOT NULL
61: THEN
62: l_uk_flag := OZF_Utility_PVT.check_uniqueness
63: (
64: 'OZF_PRICE_LIST_ATTRIBUTES',
65: 'qp_list_header_id = ' || p_ozf_price_list_rec.qp_list_header_id
66: );
67: END IF;
68:

Line 328: FROM OZF_price_list_attributes

324: )
325: IS
326: CURSOR c_ozf_price_list IS
327: SELECT *
328: FROM OZF_price_list_attributes
329: -- WHERE price_list_attribute_id = p_ozf_price_list_rec.price_list_attribute_id;
330: WHERE qp_list_header_id = p_ozf_price_list_rec.qp_list_header_id;
331:
332: l_price_list_rec c_ozf_price_list%ROWTYPE;

Line 548: FROM OZF_PRICE_LIST_ATTRIBUTES

544:
545: IS
546: CURSOR C IS
547: SELECT *
548: FROM OZF_PRICE_LIST_ATTRIBUTES
549: WHERE PRICE_LIST_ATTRIBUTE_ID = p_PRICE_LIST_ATTRIBUTE_ID
550: FOR UPDATE of PRICE_LIST_ATTRIBUTE_ID NOWAIT;
551: Recinfo C%ROWTYPE;
552: BEGIN

Line 577: CURSOR C2 IS SELECT OZF_PRICE_LIST_ATTRIBUTES_S.nextval FROM sys.dual;

573: l_object_version_number NUMBER := 1;
574: l_org_id NUMBER := FND_API.G_MISS_NUM;
575: l_PRICE_LIST_ATTRIBUTE_ID NUMBER;
576:
577: CURSOR C2 IS SELECT OZF_PRICE_LIST_ATTRIBUTES_S.nextval FROM sys.dual;
578:
579: BEGIN
580:
581: SAVEPOINT CREATE_PRICE_LIST_PVT;

Line 632: INSERT INTO OZF_PRICE_LIST_ATTRIBUTES(

628:
629: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
630: RAISE FND_API.G_EXC_ERROR;
631: END IF;
632: INSERT INTO OZF_PRICE_LIST_ATTRIBUTES(
633: PRICE_LIST_ATTRIBUTE_ID,
634: USER_STATUS_ID,
635: CUSTOM_SETUP_ID,
636: STATUS_CODE,

Line 733: FROM ozf_price_list_attributes

729: l_rowid ROWID;
730:
731: CURSOR c_is_qp_pricelist(p_id NUMBER) IS
732: SELECT 'N'
733: FROM ozf_price_list_attributes
734: WHERE qp_list_header_id = p_id;
735: l_is_qp_pricelist VARCHAR2(1);
736: BEGIN
737:

Line 780: Update OZF_PRICE_LIST_ATTRIBUTES

776: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
777: RAISE FND_API.G_EXC_ERROR;
778: END IF;
779:
780: Update OZF_PRICE_LIST_ATTRIBUTES
781: SET
782: PRICE_LIST_ATTRIBUTE_ID = decode( p_OZF_PRICE_LIST_rec.PRICE_LIST_ATTRIBUTE_ID, FND_API.G_MISS_NUM, PRICE_LIST_ATTRIBUTE_ID, p_OZF_PRICE_LIST_rec.PRICE_LIST_ATTRIBUTE_ID),
783: USER_STATUS_ID = decode( p_OZF_PRICE_LIST_rec.USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_OZF_PRICE_LIST_rec.USER_STATUS_ID),
784: CUSTOM_SETUP_ID = decode( p_OZF_PRICE_LIST_rec.CUSTOM_SETUP_ID, FND_API.G_MISS_NUM, CUSTOM_SETUP_ID, p_OZF_PRICE_LIST_rec.CUSTOM_SETUP_ID),

Line 890: DELETE FROM OZF_PRICE_LIST_ATTRIBUTES

886: END IF;
887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889:
890: DELETE FROM OZF_PRICE_LIST_ATTRIBUTES
891: WHERE PRICE_LIST_ATTRIBUTE_ID = p_PRICE_LIST_ATTRIBUTE_ID
892: AND object_version_number = p_object_version_number;
893:
894: IF (SQL%NOTFOUND) THEN