APPS.IGW_BUDGET_DETAILS_OH_PVT dependencies on IGW_BUDGET_DETAILS_CAL_AMTS

Line 153: FROM igw_budget_details_cal_amts

149:
150:
151: BEGIN
152: SELECT 'x' INTO l_dummy
153: FROM igw_budget_details_cal_amts
154: WHERE ((line_item_id = p_line_item_id and rate_class_id = p_rate_class_id and rate_type_id = p_rate_type_id)
155: OR rowid = p_rowid)
156: AND record_version_number = p_record_version_number;
157: EXCEPTION

Line 196: update igw_budget_details_cal_amts

192: l_calculated_cost_sharing := 0;
193: end if;
194:
195: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
196: update igw_budget_details_cal_amts
197: set apply_rate_flag = p_apply_rate_flag
198: , calculated_cost = l_calculated_cost
199: , calculated_cost_sharing = l_calculated_cost_sharing
200: , record_version_number = record_version_number + 1

Line 307: FROM igw_budget_details_cal_amts

303: x_return_status := 'S';
304:
305: BEGIN
306: SELECT 'x' INTO l_dummy
307: FROM igw_budget_details_cal_amts
308: WHERE ((line_item_id = p_line_item_id and rate_class_id = p_rate_class_id and rate_type_id = p_rate_type_id)
309: OR rowid = p_rowid)
310: AND record_version_number = p_record_version_number;
311: EXCEPTION

Line 337: delete from igw_budget_details_cal_amts

333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335:
336: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
337: delete from igw_budget_details_cal_amts
338: where line_item_id = p_line_item_id
339: and rate_class_id = p_rate_class_id
340: and rate_type_id = p_rate_type_id;
341: