APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_QP_PRODUCTS_PVT

Line 806: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

802: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
803: )
804: IS
805: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
806: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
807: l_qpDiscountId NUMBER;
808: l_qpProductId NUMBER;
809: l_objectVersion NUMBER;
810: l_prodObjectVersion NUMBER;

Line 891: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(

887: THEN
888: --dbms_output.put_line('Pricing Attribute id:'||p_pricing_attr_tbl(i).pricing_attribute_id||': Product Id :'||l_products.off_discount_product_id);
889: l_qpProductsRec.off_discount_product_id := l_products.off_discount_product_id;
890: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
891: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
892: p_api_version_number => 1.0
893: , p_init_msg_list => FND_API.G_FALSE
894: , p_commit => FND_API.G_FALSE
895: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1749: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

1745: , x_msg_data OUT NOCOPY VARCHAR2
1746: )
1747: IS
1748: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
1749: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
1750: l_qpDiscountId NUMBER;
1751: l_qpProductId NUMBER;
1752: l_objectVersion NUMBER;
1753: l_prodObjectVersion NUMBER;

Line 1791: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(

1787: --dbms_output.put_line('Product Mapping:'||i||' : '||p_offDiscountProductId||' : '||p_pricing_attr_tbl(i).pricing_attribute_id);
1788: l_qpProductsRec := null;
1789: l_qpProductsRec.off_discount_product_id := p_offDiscountProductId;
1790: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1791: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1792: p_api_version_number => 1.0
1793: , p_init_msg_list => FND_API.G_FALSE
1794: , p_commit => FND_API.G_FALSE
1795: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1823: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

1819: , x_msg_count OUT NOCOPY NUMBER
1820: , x_msg_data OUT NOCOPY VARCHAR2
1821: )
1822: IS
1823: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
1824: l_qpProductId NUMBER;
1825: l_prodObjectVersion NUMBER;
1826: BEGIN
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1833: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(

1829: IF p_pricing_attr_tbl.exists(i) THEN
1830: l_qpProductsRec := null;
1831: l_qpProductsRec.off_discount_product_id := p_offDiscountProductId;
1832: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1833: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1834: p_api_version_number => 1.0
1835: , p_init_msg_list => FND_API.G_FALSE
1836: , p_commit => FND_API.G_FALSE
1837: , p_validation_level => FND_API.G_VALID_LEVEL_FULL