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_ADJUSTMENT_PVT dependencies on OZF_OFFER_ADJUSTMENTS_VL

Line 466: FROM OZF_OFFER_ADJUSTMENTS_VL

462: AND object_attribute = 'ADJA';
463:
464: CURSOR c_backdate_flag(p_list_header_id NUMBER, p_offer_adjustment_id NUMBER, p_effective_date DATE) IS
465: SELECT 1
466: FROM OZF_OFFER_ADJUSTMENTS_VL
467: WHERE (p_effective_date 468: AND list_header_id = p_list_header_id
469: AND offer_adjustment_id = p_offer_adjustment_id;
470:

Line 1103: SELECT 1 from ozf_offer_adjustments_vl

1099:
1100: --nepanda : fix for bug 9149865
1101: CURSOR c_check_uniqeness_create
1102: IS
1103: SELECT 1 from ozf_offer_adjustments_vl
1104: WHERE offer_adjustment_name = p_offer_adj_rec.offer_adjustment_name
1105: AND list_header_id = p_offer_adj_rec.list_header_id;
1106:
1107: CURSOR c_check_uniqeness_update

Line 1109: SELECT 1 from ozf_offer_adjustments_vl

1105: AND list_header_id = p_offer_adj_rec.list_header_id;
1106:
1107: CURSOR c_check_uniqeness_update
1108: IS
1109: SELECT 1 from ozf_offer_adjustments_vl
1110: WHERE offer_adjustment_name = p_offer_adj_rec.offer_adjustment_name
1111: AND list_header_id = p_offer_adj_rec.list_header_id
1112: AND offer_adjustment_id <> p_offer_adj_rec.offer_adjustment_id;
1113:

Line 1120: ' ozf_offer_adjustments_vl ',

1116: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1117: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');
1118: --nepanda : fix for bug 9149865
1119: /*l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1120: ' ozf_offer_adjustments_vl ',
1121: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1122: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1123: );*/
1124:

Line 1145: ' ozf_offer_adjustments_vl ',

1141:
1142: ELSE
1143: --nepanda : fix for bug 9149865
1144: /* l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1145: ' ozf_offer_adjustments_vl ',
1146: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1147: ' AND offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1148: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1149: );*/