APPS.OZF_OFFER_ADJ_PRODUCTS_PKG dependencies on OZF_OFFER_ADJUSTMENT_PRODUCTS

Line 26: INSERT INTO OZF_OFFER_ADJUSTMENT_PRODUCTS

22: )
23: IS
24: BEGIN
25: px_object_version_number := nvl(px_object_version_number,1);
26: INSERT INTO OZF_OFFER_ADJUSTMENT_PRODUCTS
27: (
28: offer_adjustment_product_id
29: , offer_adjustment_id
30: , offer_discount_line_id

Line 86: UPDATE OZF_OFFER_ADJUSTMENT_PRODUCTS

82: , p_last_update_login NUMBER
83: )IS
84: BEGIN
85:
86: UPDATE OZF_OFFER_ADJUSTMENT_PRODUCTS
87: SET
88: offer_adjustment_product_id = DECODE(p_offer_adjustment_product_id, null, offer_adjustment_product_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_product_id)
89: , offer_adjustment_id = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)
90: , 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 118: delete FROM ozf_offer_adjustment_products

114: , p_object_version_number NUMBER
115: )
116: IS
117: BEGIN
118: delete FROM ozf_offer_adjustment_products
119: WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
120: AND object_version_number = p_object_version_number;
121:
122: IF sql%notfound THEN

Line 134: CURSOR C is SELECT * FROM ozf_offer_adjustment_products

130: p_offer_adjustment_product_id NUMBER
131: , p_object_version_number NUMBER
132: )
133: IS
134: CURSOR C is SELECT * FROM ozf_offer_adjustment_products
135: WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
136: AND object_version_number = p_object_version_number
137: FOR UPDATE OF offer_adjustment_product_id NOWAIT;
138: