APPS.OZF_PRICE_LIST_PVT dependencies on OZF_PRICE_LIST_ATTRIBUTES

Line 57: 'OZF_PRICE_LIST_ATTRIBUTES',

53: 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
54: THEN
55: l_uk_flag := OZF_Utility_PVT.check_uniqueness
56: (
57: 'OZF_PRICE_LIST_ATTRIBUTES',
58: 'price_list_attribute_id = ' || p_ozf_price_list_rec.price_list_attribute_id
59: );
60: END IF;
61: IF l_uk_flag = FND_API.g_false THEN

Line 77: 'OZF_PRICE_LIST_ATTRIBUTES',

73: AND p_ozf_price_list_rec.qp_list_header_id IS NOT NULL
74: THEN
75: l_uk_flag := OZF_Utility_PVT.check_uniqueness
76: (
77: 'OZF_PRICE_LIST_ATTRIBUTES',
78: 'qp_list_header_id = ' || p_ozf_price_list_rec.qp_list_header_id
79: );
80: END IF;
81:

Line 341: FROM OZF_price_list_attributes

337: )
338: IS
339: CURSOR c_ozf_price_list IS
340: SELECT *
341: FROM OZF_price_list_attributes
342: -- WHERE price_list_attribute_id = p_ozf_price_list_rec.price_list_attribute_id;
343: WHERE qp_list_header_id = p_ozf_price_list_rec.qp_list_header_id;
344:
345: l_price_list_rec c_ozf_price_list%ROWTYPE;

Line 561: FROM OZF_PRICE_LIST_ATTRIBUTES

557:
558: IS
559: CURSOR C IS
560: SELECT *
561: FROM OZF_PRICE_LIST_ATTRIBUTES
562: WHERE PRICE_LIST_ATTRIBUTE_ID = p_PRICE_LIST_ATTRIBUTE_ID
563: FOR UPDATE of PRICE_LIST_ATTRIBUTE_ID NOWAIT;
564: Recinfo C%ROWTYPE;
565: BEGIN

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

586: l_object_version_number NUMBER := 1;
587: l_org_id NUMBER := FND_API.G_MISS_NUM;
588: l_PRICE_LIST_ATTRIBUTE_ID NUMBER;
589:
590: CURSOR C2 IS SELECT OZF_PRICE_LIST_ATTRIBUTES_S.nextval FROM sys.dual;
591:
592: BEGIN
593:
594: SAVEPOINT CREATE_PRICE_LIST_PVT;

Line 645: INSERT INTO OZF_PRICE_LIST_ATTRIBUTES(

641:
642: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645: INSERT INTO OZF_PRICE_LIST_ATTRIBUTES(
646: PRICE_LIST_ATTRIBUTE_ID,
647: USER_STATUS_ID,
648: CUSTOM_SETUP_ID,
649: STATUS_CODE,

Line 746: FROM ozf_price_list_attributes

742: l_rowid ROWID;
743:
744: CURSOR c_is_qp_pricelist(p_id NUMBER) IS
745: SELECT 'N'
746: FROM ozf_price_list_attributes
747: WHERE qp_list_header_id = p_id;
748: l_is_qp_pricelist VARCHAR2(1);
749: BEGIN
750:

Line 793: Update OZF_PRICE_LIST_ATTRIBUTES

789: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
790: RAISE FND_API.G_EXC_ERROR;
791: END IF;
792:
793: Update OZF_PRICE_LIST_ATTRIBUTES
794: SET
795: 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),
796: 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),
797: 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 903: DELETE FROM OZF_PRICE_LIST_ATTRIBUTES

899: END IF;
900:
901: x_return_status := FND_API.G_RET_STS_SUCCESS;
902:
903: DELETE FROM OZF_PRICE_LIST_ATTRIBUTES
904: WHERE PRICE_LIST_ATTRIBUTE_ID = p_PRICE_LIST_ATTRIBUTE_ID
905: AND object_version_number = p_object_version_number;
906:
907: IF (SQL%NOTFOUND) THEN