[Home] [Help]
148: for rec_budget_details in c_budget_details
149: LOOP
150: l_line_item_id := rec_budget_details.line_item_id;
151: l_rate_class_id_oh := p_oh_rate_class_id;
152: IGW_OVERHEAD_CAL.get_rate_id(rec_budget_details.expenditure_type
153: ,rec_budget_details.expenditure_category_flag
154: , 'O'
155: ,l_rate_class_id_oh
156: ,l_rate_type_id_oh
164:
165: if rec_budget_details.personnel_attached_flag = 'N' then
166:
167: if rec_budget_details.apply_inflation_flag = 'Y' then
168: IGW_OVERHEAD_CAL.get_rate_id(rec_budget_details.expenditure_type
169: ,rec_budget_details.expenditure_category_flag
170: ,'I'
171: , l_rate_class_id_inf
172: ,l_rate_type_id_inf
187: End;
188:
189: l_base_amount := rec_budget_details.line_item_cost;
190:
191: IGW_OVERHEAD_CAL.calc_oh(p_proposal_id
192: ,p_version_id
193: ,l_base_amount
194: ,rec_budget_periods.start_date
195: ,rec_budget_periods.end_date
210: if l_apply_rate_flag_oh = 'N' then
211: l_oh_value_ov := 0;
212: l_calculated_cost_share_ov := 0;
213: elsif l_apply_rate_flag_oh = 'Y' then
214: IGW_OVERHEAD_CAL.calc_oh(p_proposal_id
215: ,p_version_id
216: ,rec_budget_details.cost_sharing_amount
217: ,rec_budget_periods.start_date
218: ,rec_budget_periods.end_date
256: ,nvl(l_calculated_cost_share_ov,0));
257: end if;
258:
259: elsif rec_budget_details.personnel_attached_flag = 'Y' then
260: IGW_OVERHEAD_CAL.get_rate_id(rec_budget_details.expenditure_type
261: ,rec_budget_details.expenditure_category_flag
262: ,'E'
263: ,l_rate_class_id_eb,l_rate_type_id_eb,l_return_status, l_msg_data);
264:
311: and version_id = p_version_id
312: and person_id = rec_budget_personnel.person_id
313: and appointment_type_code = rec_budget_personnel.appointment_type_code;
314:
315: IGW_OVERHEAD_CAL.calc_salary(p_proposal_id
316: ,p_version_id
317: ,l_calculation_base
318: ,l_effective_date
319: ,l_appointment_type_code
349: l_rate_type_id_eb_d := l_rate_type_id_eb;
350: end if;
351:
352:
353: IGW_OVERHEAD_CAL.calc_oh_eb (p_proposal_id
354: ,p_version_id
355: ,l_inflated_salary_ov
356: ,rec_budget_personnel.start_date
357: ,rec_budget_personnel.end_date
371: if l_return_status <> 'S' then
372: raise FND_API.G_EXC_ERROR;
373: end if;
374:
375: IGW_OVERHEAD_CAL.calc_oh_eb (p_proposal_id
376: ,p_version_id
377: ,l_inflated_salary_ov
378: ,rec_budget_personnel.start_date
379: ,rec_budget_personnel.end_date
1362: for rec_budget_details in c_budget_details
1363: LOOP
1364: l_line_item_id := rec_budget_details.line_item_id;
1365: l_rate_class_id_oh := l_oh_rate_class_id;
1366: IGW_OVERHEAD_CAL.get_rate_id(rec_budget_details.expenditure_type
1367: ,rec_budget_details.expenditure_category_flag
1368: , 'O'
1369: ,l_rate_class_id_oh
1370: ,l_rate_type_id_oh
1378:
1379: if rec_budget_details.personnel_attached_flag = 'N' then
1380:
1381: if rec_budget_details.apply_inflation_flag = 'Y' then
1382: IGW_OVERHEAD_CAL.get_rate_id(rec_budget_details.expenditure_type
1383: ,rec_budget_details.expenditure_category_flag
1384: ,'I'
1385: , l_rate_class_id_inf
1386: ,l_rate_type_id_inf
1403: l_base_amount := rec_budget_details.line_item_cost;
1404:
1405: /* NON_PERSONNEL: the reason why we are calculating cal_oh twice is because, once to calculate cost share amt
1406: for line and second time to calculate cost share for Overhead line. */
1407: IGW_OVERHEAD_CAL.calc_oh(p_proposal_id
1408: ,p_version_id
1409: ,l_base_amount
1410: ,rec_budget_periods.start_date
1411: ,rec_budget_periods.end_date
1428: l_calculated_cost_share_ov := 0;
1429: elsif l_apply_rate_flag_oh = 'Y' then
1430: if l_apply_oh_setup_rates = 'Y' then
1431: /*this proc is for calculationg Overhead cost share amt from line cost share amt */
1432: IGW_OVERHEAD_CAL.calc_oh(p_proposal_id
1433: ,p_version_id
1434: ,rec_budget_details.cost_sharing_amount
1435: ,rec_budget_periods.start_date
1436: ,rec_budget_periods.end_date
1493: end if;
1494: end if;
1495:
1496: elsif rec_budget_details.personnel_attached_flag = 'Y' then
1497: IGW_OVERHEAD_CAL.get_rate_id(rec_budget_details.expenditure_type
1498: ,rec_budget_details.expenditure_category_flag
1499: ,'E'
1500: ,l_rate_class_id_eb,l_rate_type_id_eb,l_return_status, l_msg_data);
1501:
1549: --and person_id = rec_budget_personnel.person_id
1550: and party_id = rec_budget_personnel.party_id
1551: and appointment_type_code = rec_budget_personnel.appointment_type_code;
1552:
1553: IGW_OVERHEAD_CAL.calc_salary(p_proposal_id
1554: ,p_version_id
1555: ,l_calculation_base
1556: ,l_effective_date
1557: ,l_appointment_type_code
1593: /* PERSONNEL: the reason why we are calculating cal_oh_eb twice is because of multiple combinations of apply rate
1594: flag for eb and oh. we always need to calculate with setup rates(1st time). Second time we need based on
1595: apply rate flag. Cost share amt is calculed internally based on the cost share percentage unlike for NON-PERSONNEL*/
1596:
1597: IGW_OVERHEAD_CAL.calc_oh_eb (p_proposal_id
1598: ,p_version_id
1599: ,l_inflated_salary_ov
1600: ,rec_budget_personnel.start_date
1601: ,rec_budget_personnel.end_date
1615: if l_return_status <> 'S' then
1616: raise FND_API.G_EXC_ERROR;
1617: end if;
1618:
1619: IGW_OVERHEAD_CAL.calc_oh_eb (p_proposal_id
1620: ,p_version_id
1621: ,l_inflated_salary_ov
1622: ,rec_budget_personnel.start_date
1623: ,rec_budget_personnel.end_date