[Home] [Help]
244: ,l_rate_class_id_oh
245: ,l_rate_type_id_oh) then
246:
247:
248: IGW_GENERATE_PERIODS.create_budget_detail_amts(p_proposal_id
249: ,p_version_id
250: ,rec_budget_details.budget_period_id
251: ,rec_budget_details.line_item_id
252: ,l_rate_class_id_oh
416: if check_exp_assignment(rec_budget_details.expenditure_type
417: ,rec_budget_details.expenditure_category_flag
418: ,l_rate_class_id_oh
419: ,l_rate_type_id_oh) then
420: IGW_GENERATE_PERIODS.create_budget_personnel_amts (
421: rec_budget_personnel.budget_personnel_detail_id
422: ,l_rate_class_id_oh
423: ,l_rate_type_id_oh
424: ,l_apply_rate_flag_oh
428: if check_exp_assignment(rec_budget_details.expenditure_type
429: ,rec_budget_details.expenditure_category_flag
430: ,l_rate_class_id_eb
431: ,l_rate_type_id_eb) then
432: IGW_GENERATE_PERIODS.create_budget_personnel_amts (
433: rec_budget_personnel.budget_personnel_detail_id
434: ,l_rate_class_id_eb
435: ,l_rate_type_id_eb
436: ,l_apply_rate_flag_eb
469: if check_exp_assignment(rec_budget_details.expenditure_type
470: ,rec_budget_details.expenditure_category_flag
471: ,l_rate_class_id_oh
472: ,l_rate_type_id_oh) then
473: IGW_GENERATE_PERIODS.create_budget_detail_amts(rec_budget_details.proposal_id
474: ,rec_budget_details.version_id
475: ,rec_budget_details.budget_period_id
476: ,rec_budget_details.line_item_id
477: ,l_rate_class_id_oh
484: if check_exp_assignment(rec_budget_details.expenditure_type
485: ,rec_budget_details.expenditure_category_flag
486: ,l_rate_class_id_eb
487: ,l_rate_type_id_eb) then
488: IGW_GENERATE_PERIODS.create_budget_detail_amts(rec_budget_details.proposal_id
489: ,rec_budget_details.version_id
490: ,rec_budget_details.budget_period_id
491: ,rec_budget_details.line_item_id
492: ,l_rate_class_id_eb
893: elsif l_counter = 2 then
894: select igw_budget_details_s.currval into l_based_on_line_item from dual;
895: end if;
896:
897: IGW_GENERATE_PERIODS.create_budget_detail (
898: p_target_proposal_id
899: ,l_target_version_id
900: ,rec_budget_details.budget_period_id
901: ,l_dummy_line_item_id
968: l_budget_personnel_detail_id := rec_budget_personnel.budget_personnel_detail_id;
969: for rec_budget_personnel_amts in c_budget_personnel_amts
970: LOOP
971: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;
972: IGW_GENERATE_PERIODS.create_budget_personnel_amts (
973: l_dummy_personnel_id
974: ,rec_budget_personnel_amts.rate_class_id
975: ,rec_budget_personnel_amts.rate_type_id
976: ,rec_budget_personnel_amts.apply_rate_flag
984: LOOP
985:
986: select igw_budget_details_s.currval into l_dummy_line_item_id from dual;
987:
988: IGW_GENERATE_PERIODS.create_budget_detail_amts(p_target_proposal_id
989: ,l_target_version_id
990: ,rec_budget_details.budget_period_id
991: ,l_dummy_line_item_id
992: ,rec_budget_detail_amts.rate_class_id
1470: ,l_rate_class_id_oh
1471: ,l_rate_type_id_oh) then
1472:
1473: if l_apply_oh_setup_rates = 'Y' then
1474: IGW_GENERATE_PERIODS.create_budget_detail_amts(p_proposal_id
1475: ,p_version_id
1476: ,rec_budget_details.budget_period_id
1477: ,rec_budget_details.line_item_id
1478: ,l_rate_class_id_oh
1480: ,l_apply_rate_flag_oh
1481: ,nvl(l_oh_value_ov,0)
1482: ,nvl(l_calculated_cost_share_ov,0));
1483: else
1484: IGW_GENERATE_PERIODS.create_budget_detail_amts(p_proposal_id
1485: ,p_version_id
1486: ,rec_budget_details.budget_period_id
1487: ,rec_budget_details.line_item_id
1488: ,l_rate_class_id_oh
1674: ,rec_budget_details.expenditure_category_flag
1675: ,l_rate_class_id_oh
1676: ,l_rate_type_id_oh) then
1677: if l_apply_oh_setup_rates = 'Y' then
1678: IGW_GENERATE_PERIODS.create_budget_personnel_amts (
1679: rec_budget_personnel.budget_personnel_detail_id
1680: ,l_rate_class_id_oh
1681: ,l_rate_type_id_oh
1682: ,l_apply_rate_flag_oh
1682: ,l_apply_rate_flag_oh
1683: ,nvl(l_oh_value_ov,0)
1684: ,rec_budget_personnel.cost_sharing_percent/100 * nvl(l_oh_value_ov,0));
1685: else
1686: IGW_GENERATE_PERIODS.create_budget_personnel_amts (
1687: rec_budget_personnel.budget_personnel_detail_id
1688: ,l_rate_class_id_oh
1689: ,l_rate_type_id_oh
1690: ,l_apply_rate_flag_oh
1697: ,rec_budget_details.expenditure_category_flag
1698: ,l_rate_class_id_eb
1699: ,l_rate_type_id_eb) then
1700: if l_apply_eb_setup_rates = 'Y' then
1701: IGW_GENERATE_PERIODS.create_budget_personnel_amts (
1702: rec_budget_personnel.budget_personnel_detail_id
1703: ,l_rate_class_id_eb
1704: ,l_rate_type_id_eb
1705: ,l_apply_rate_flag_eb
1705: ,l_apply_rate_flag_eb
1706: ,nvl(l_eb_value_ov,0)
1707: ,rec_budget_personnel.cost_sharing_percent/100 * nvl(l_eb_value,0));
1708: else
1709: IGW_GENERATE_PERIODS.create_budget_personnel_amts (
1710: rec_budget_personnel.budget_personnel_detail_id
1711: ,l_rate_class_id_eb
1712: ,l_rate_type_id_eb
1713: ,l_apply_rate_flag_eb
1747: if check_exp_assignment(rec_budget_details.expenditure_type
1748: ,rec_budget_details.expenditure_category_flag
1749: ,l_rate_class_id_oh
1750: ,l_rate_type_id_oh) then
1751: IGW_GENERATE_PERIODS.create_budget_detail_amts(rec_budget_details.proposal_id
1752: ,rec_budget_details.version_id
1753: ,rec_budget_details.budget_period_id
1754: ,rec_budget_details.line_item_id
1755: ,l_rate_class_id_oh
1762: if check_exp_assignment(rec_budget_details.expenditure_type
1763: ,rec_budget_details.expenditure_category_flag
1764: ,l_rate_class_id_eb
1765: ,l_rate_type_id_eb) then
1766: IGW_GENERATE_PERIODS.create_budget_detail_amts(rec_budget_details.proposal_id
1767: ,rec_budget_details.version_id
1768: ,rec_budget_details.budget_period_id
1769: ,rec_budget_details.line_item_id
1770: ,l_rate_class_id_eb