The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b
WHERE a.qp_list_header_id = b.list_header_id
AND b.offer_adjustment_id = cp_offerAdjustmentId;
SELECT 1 FROM dual WHERE EXISTS
(SELECT 'X' FROM ozf_offer_discount_products a, ozf_offer_adjustments_b b, ozf_offers c
WHERE
a.offer_id = c.offer_id
AND c.qp_list_header_id = b.list_header_id
AND b.offer_adjustment_id = p_offer_adjustment_id
AND product_context = p_product_context
AND product_attribute = p_product_attribute
AND p_product_attr_value = p_product_attr_value
AND excluder_flag = p_excluder_flag ;
SELECT a.offer_id
FROM ozf_offers a, ozf_offer_adjustments_b b
WHERE a.qp_list_header_id = b.list_header_id
AND b.offer_adjustment_id = cp_offerAdjustmentId;
SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X'
FROM ozf_offer_discount_lines a
, ozf_offer_discount_products b
, ozf_offer_adjustments_b c
, ozf_offers d
WHERE a.offer_discount_line_id = b.offer_discount_line_id
AND a.offer_id = d.offer_id
AND d.qp_list_header_id = c.list_header_id
AND a.offer_discount_line_id = p_offer_discount_line_id
AND b.off_discount_product_id = p_off_discount_product_id);
SELECT effective_date
FROM ozf_offer_adjustments_b
WHERE offer_adjustment_id = cp_offerAdjustmentId;
SELECT ozf_offer_adj_products_s.nextval from dual;
SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X' FROM ozf_offer_adjustment_products where offer_adjustment_product_id = l_offer_adjustment_product_id);
OZF_OFFER_ADJ_PRODUCTS_PKG.INSERT_ROW
(
px_offer_adjustment_product_id => l_offer_adjustment_product_id
, p_offer_adjustment_id => p_adj_prod.offer_adjustment_id
, p_offer_discount_line_id => p_adj_prod.offer_discount_line_id
, p_off_discount_product_id => p_adj_prod.off_discount_product_id
, p_product_context => p_adj_prod.product_context
, p_product_attribute => p_adj_prod.product_attribute
, p_product_attr_value => p_adj_prod.product_attr_value
, p_excluder_flag => l_excluder_flag
, p_apply_discount_flag => p_adj_prod.apply_discount_flag
, p_include_volume_flag => p_adj_prod.include_volume_flag
, px_object_version_number => l_object_version_number
, p_creation_date => SYSDATE
, p_created_by => FND_GLOBAL.USER_ID
, p_last_updated_by => FND_GLOBAL.USER_ID
, p_last_update_date => SYSDATE
, p_last_update_login => FND_GLOBAL.conc_login_id
);
PROCEDURE UPDATE_OFFER_ADJ_PRODUCT
(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_adj_prod_rec IN offer_adj_prod_rec
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_OFFER_ADJ_PRODUCT';
SELECT * FROM ozf_offer_adjustment_products
WHERE offer_adjustment_product_id = p_adj_product_id
AND object_version_number = p_object_version_number;
SAVEPOINT UPDATE_OFFER_ADJ_PRODUCT;
OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
, p_token_name => 'INFO'
, p_token_value => 'OZF_OFFR_ADJ_PRODUCTS') ;
, p_validation_mode => jtf_plsql_api.g_update
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_adj_prod => l_tar_rec
);
OZF_OFFER_ADJ_PRODUCTS_PKG.UPDATE_ROW
(
p_offer_adjustment_product_id => l_tar_rec.offer_adjustment_product_id
, p_offer_adjustment_id => l_tar_rec.offer_adjustment_id
, p_offer_discount_line_id => l_tar_rec.offer_discount_line_id
, p_off_discount_product_id => l_tar_rec.off_discount_product_id
, p_product_context => l_tar_rec.product_context
, p_product_attribute => l_tar_rec.product_attribute
, p_product_attr_value => l_tar_rec.product_attr_value
, p_excluder_flag => l_excluder_flag
, p_apply_discount_flag => l_tar_rec.apply_discount_flag
, p_include_volume_flag => l_tar_rec.include_volume_flag
, p_object_version_number => l_tar_rec.object_version_number
, p_last_update_date => sysdate
, p_last_updated_by => FND_GLOBAL.USER_ID
, p_last_update_login => FND_GLOBAL.conc_login_id
);
ROLLBACK TO UPDATE_OFFER_ADJ_PRODUCT;
ROLLBACK TO UPDATE_OFFER_ADJ_PRODUCT;
ROLLBACK TO UPDATE_OFFER_ADJ_PRODUCT;
END UPDATE_OFFER_ADJ_PRODUCT;
PROCEDURE DELETE_OFFER_ADJ_PRODUCT
(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_offer_adjustment_product_id IN NUMBER,
p_object_version_number IN NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_OFFER_ADJ_PRODUCT';
SAVEPOINT DELETE_OFFER_ADJ_PRODUCT;
OZF_OFFER_ADJ_PRODUCTS_PKG.DELETE_ROW
(
p_offer_adjustment_product_id => p_offer_adjustment_product_id
, p_object_version_number => p_object_version_number
);
ROLLBACK TO DELETE_OFFER_ADJ_PRODUCT;
ROLLBACK TO DELETE_OFFER_ADJ_PRODUCT;
ROLLBACK TO DELETE_OFFER_ADJ_PRODUCT;
END DELETE_OFFER_ADJ_PRODUCT;