APPS.OZF_QP_DISCOUNTS_PKG dependencies on OZF_QP_DISCOUNTS

Line 1: PACKAGE BODY OZF_QP_DISCOUNTS_PKG AS

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

Line 45: INSERT INTO ozf_qp_discounts

41: )
42: IS
43: BEGIN
44: px_object_version_number := nvl(px_object_version_number,1);
45: INSERT INTO ozf_qp_discounts
46: (
47: ozf_qp_discount_id
48: , list_line_id
49: , offer_discount_line_id

Line 94: UPDATE ozf_qp_discounts

90: , p_last_update_login NUMBER
91: )
92: IS
93: BEGIN
94: UPDATE ozf_qp_discounts
95: SET
96: ozf_qp_discount_id = DECODE(p_qp_discount_id, NULL, ozf_qp_discount_id, FND_API.G_MISS_NUM, NULL, p_qp_discount_id)
97: , list_line_id = DECODE(p_list_line_id , NULL, list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
98: , offer_discount_line_id = DECODE(p_offer_discount_line_id, NULL, offer_discount_line_id,FND_API.G_MISS_NUM, null, p_offer_discount_line_id)

Line 130: DELETE FROM ozf_qp_discounts

126: p_qp_discount_id NUMBER
127: , p_object_version_number NUMBER)
128: IS
129: BEGIN
130: DELETE FROM ozf_qp_discounts
131: WHERE ozf_qp_discount_id = p_qp_discount_id
132: AND object_version_number = p_object_version_number;
133:
134: IF SQL%NOTFOUND THEN

Line 159: SELECT * FROM ozf_qp_discounts

155: p_qp_discount_id NUMBER
156: , p_object_version_number NUMBER)
157: IS
158: CURSOR c IS
159: SELECT * FROM ozf_qp_discounts
160: WHERE ozf_qp_discount_id = p_qp_discount_id
161: AND object_version_number = p_object_version_number
162: FOR UPDATE OF ozf_qp_discount_id NOWAIT;
163:

Line 178: END OZF_QP_DISCOUNTS_PKG;

174:
175:
176:
177:
178: END OZF_QP_DISCOUNTS_PKG;