DBA Data[Home] [Help]

APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_QP_PRODUCTS_PVT

Line 751: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

747: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
748: )
749: IS
750: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
751: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
752: l_qpDiscountId NUMBER;
753: l_qpProductId NUMBER;
754: l_objectVersion NUMBER;
755: l_prodObjectVersion NUMBER;

Line 836: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(

832: THEN
833: --dbms_output.put_line('Pricing Attribute id:'||p_pricing_attr_tbl(i).pricing_attribute_id||': Product Id :'||l_products.off_discount_product_id);
834: l_qpProductsRec.off_discount_product_id := l_products.off_discount_product_id;
835: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
836: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
837: p_api_version_number => 1.0
838: , p_init_msg_list => FND_API.G_FALSE
839: , p_commit => FND_API.G_FALSE
840: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1690: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

1686: , x_msg_data OUT NOCOPY VARCHAR2
1687: )
1688: IS
1689: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
1690: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
1691: l_qpDiscountId NUMBER;
1692: l_qpProductId NUMBER;
1693: l_objectVersion NUMBER;
1694: l_prodObjectVersion NUMBER;

Line 1732: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(

1728: --dbms_output.put_line('Product Mapping:'||i||' : '||p_offDiscountProductId||' : '||p_pricing_attr_tbl(i).pricing_attribute_id);
1729: l_qpProductsRec := null;
1730: l_qpProductsRec.off_discount_product_id := p_offDiscountProductId;
1731: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1732: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1733: p_api_version_number => 1.0
1734: , p_init_msg_list => FND_API.G_FALSE
1735: , p_commit => FND_API.G_FALSE
1736: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1764: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

1760: , x_msg_count OUT NOCOPY NUMBER
1761: , x_msg_data OUT NOCOPY VARCHAR2
1762: )
1763: IS
1764: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
1765: l_qpProductId NUMBER;
1766: l_prodObjectVersion NUMBER;
1767: BEGIN
1768: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1774: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(

1770: IF p_pricing_attr_tbl.exists(i) THEN
1771: l_qpProductsRec := null;
1772: l_qpProductsRec.off_discount_product_id := p_offDiscountProductId;
1773: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1774: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1775: p_api_version_number => 1.0
1776: , p_init_msg_list => FND_API.G_FALSE
1777: , p_commit => FND_API.G_FALSE
1778: , p_validation_level => FND_API.G_VALID_LEVEL_FULL