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.

[Home] [Help]

APPS.OZF_ADJ_NEW_LINE_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 790: SELECT modifier_level_code FROM ozf_offers a, ozf_offer_adjustments_b b

786: , x_return_status OUT NOCOPY VARCHAR2
787: )
788: IS
789: CURSOR c_modifierLevelCode(cp_offerAdjustmentId NUMBER) IS
790: SELECT modifier_level_code FROM ozf_offers a, ozf_offer_adjustments_b b
791: WHERE a.qp_list_header_id = b.list_header_id
792: AND b.offer_adjustment_id = cp_offerAdjustmentId;
793: l_modifierLevelCode c_modifierLevelCode%ROWTYPE;
794: CURSOR c_dates (cp_offerAdjustmentId NUMBER) IS

Line 796: FROM ozf_offer_adjustments_b a, qp_list_headers_b b

792: AND b.offer_adjustment_id = cp_offerAdjustmentId;
793: l_modifierLevelCode c_modifierLevelCode%ROWTYPE;
794: CURSOR c_dates (cp_offerAdjustmentId NUMBER) IS
795: SELECT a.effective_date , b.end_date_active
796: FROM ozf_offer_adjustments_b a, qp_list_headers_b b
797: WHERE a.list_header_id = b.list_header_id
798: AND a.offer_adjustment_id = cp_offerAdjustmentId;
799: l_dates c_dates%ROWTYPE;
800: BEGIN

Line 867: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJUSTMENTS_B','OFFER_ADJUSTMENT_ID',to_char(p_adj_new_line_rec.offer_adjustment_id)) = FND_API.g_false THEN

863: )
864: IS
865: BEGIN
866: x_return_status := FND_API.g_ret_sts_success;
867: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJUSTMENTS_B','OFFER_ADJUSTMENT_ID',to_char(p_adj_new_line_rec.offer_adjustment_id)) = FND_API.g_false THEN
868: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ADJ_ID' );
869: x_return_status := FND_API.g_ret_sts_error;
870: return;
871: END IF;

Line 1344: SELECT modifier_level_code, a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b

1340: p_adj_new_prod_rec IN OUT NOCOPY OZF_Adj_New_Prod_PVT.adj_new_prod_rec_type
1341: )
1342: IS
1343: CURSOR c_modifierLevelCode(cp_offerAdjustmentId NUMBER) IS
1344: SELECT modifier_level_code, a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b
1345: WHERE a.qp_list_header_id = b.list_header_id
1346: AND b.offer_adjustment_id = cp_offerAdjustmentId;
1347: l_modifierLevelCode c_modifierLevelCode%ROWTYPE;
1348: BEGIN