APPS.OZF_QP_PRODUCTS_PKG dependencies on OZF_QP_PRODUCTS

Line 1: PACKAGE BODY OZF_QP_PRODUCTS_PKG AS

1: PACKAGE BODY OZF_QP_PRODUCTS_PKG AS
2: /* $Header: ozftoqppb.pls 120.1 2005/08/24 02:59:26 rssharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- OZF_QP_PRODUCTS_PKG

2: /* $Header: ozftoqppb.pls 120.1 2005/08/24 02:59:26 rssharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- OZF_QP_PRODUCTS_PKG
7: -- Purpose
8: --
9: -- History
10: -- NOTE

Line 46: INSERT INTO ozf_qp_products

42: IS
43: BEGIN
44: px_object_version_number := nvl(px_object_version_number,1);
45:
46: INSERT INTO ozf_qp_products
47: (
48: qp_product_id
49: , off_discount_product_id
50: , pricing_attribute_id

Line 96: UPDATE ozf_qp_products

92: , p_last_update_login NUMBER
93: )
94: IS
95: BEGIN
96: UPDATE ozf_qp_products
97: SET
98: qp_product_id = DECODE(p_qp_product_id , NULL, qp_product_id, FND_API.G_MISS_NUM, null, p_qp_product_id)
99: , off_discount_product_id = DECODE(p_off_discount_product_id, NULL , off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
100: , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)

Line 132: DELETE FROM ozf_qp_products

128: p_qp_product_id NUMBER
129: , p_object_version_number NUMBER)
130: IS
131: BEGIN
132: DELETE FROM ozf_qp_products
133: WHERE qp_product_id = p_qp_product_id
134: AND object_version_number = p_object_version_number;
135: If (SQL%NOTFOUND) then
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 161: FROM ozf_qp_products

157: , p_object_version_number NUMBER)
158: IS
159: CURSOR C IS
160: SELECT *
161: FROM ozf_qp_products
162: WHERE qp_product_id = p_qp_product_id
163: AND object_version_number = p_object_version_number
164: FOR UPDATE OF qp_product_id NOWAIT;
165: Recinfo C%ROWTYPE;

Line 181: END OZF_QP_PRODUCTS_PKG;

177:
178:
179:
180:
181: END OZF_QP_PRODUCTS_PKG;