eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_ADJ_PRODUCTS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 71


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;

Line: 93


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 ;

Line: 105


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;

Line: 332


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);

Line: 384


SELECT effective_date
FROM ozf_offer_adjustments_b
WHERE offer_adjustment_id = cp_offerAdjustmentId;

Line: 551


SELECT ozf_offer_adj_products_s.nextval from dual;

Line: 556


SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X' FROM ozf_offer_adjustment_products where offer_adjustment_product_id = l_offer_adjustment_product_id);

Line: 630


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
);

Line: 698


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';

Line: 717


SELECT * FROM ozf_offer_adjustment_products
WHERE offer_adjustment_product_id = p_adj_product_id
AND object_version_number = p_object_version_number;

Line: 724


SAVEPOINT UPDATE_OFFER_ADJ_PRODUCT;

Line: 746


          OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
                                           , p_token_name   => 'INFO'
                                           , p_token_value  => 'OZF_OFFR_ADJ_PRODUCTS') ;

Line: 773


, 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
);

Line: 788


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
);

Line: 817


ROLLBACK TO UPDATE_OFFER_ADJ_PRODUCT;

Line: 825


ROLLBACK TO UPDATE_OFFER_ADJ_PRODUCT;

Line: 833


ROLLBACK TO UPDATE_OFFER_ADJ_PRODUCT;

Line: 844


END UPDATE_OFFER_ADJ_PRODUCT;

Line: 846


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';

Line: 865


SAVEPOINT DELETE_OFFER_ADJ_PRODUCT;

Line: 884


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
);

Line: 896


ROLLBACK TO DELETE_OFFER_ADJ_PRODUCT;

Line: 904


ROLLBACK TO DELETE_OFFER_ADJ_PRODUCT;

Line: 912


ROLLBACK TO DELETE_OFFER_ADJ_PRODUCT;

Line: 925


END DELETE_OFFER_ADJ_PRODUCT;