[Home] [Help]
109: ,p_apply_rate_flag VARCHAR2
110: ,p_calculated_cost NUMBER
111: ,p_calculated_cost_sharing NUMBER) is
112: BEGIN
113: insert into igw_budget_details_cal_amts (
114: proposal_id
115: ,version_id
116: ,budget_period_id
117: ,line_item_id
334: if rec_budget_details.personnel_attached_flag = 'N' then
335: BEGIN
336: select apply_rate_flag
337: into l_apply_rate_flag_oh
338: from igw_budget_details_cal_amts
339: where line_item_id = rec_budget_details.line_item_id;
340: EXCEPTION
341: when no_data_found then null;
342: End;
492: ,rec_budget_details.budget_justification
493: ,rec_budget_details.location_code);
494:
495: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
496: insert into igw_budget_details_cal_amts (
497: proposal_id
498: ,version_id
499: ,budget_period_id
500: ,line_item_id
605: ,rec_budget_details.budget_justification
606: ,rec_budget_details.location_code);
607:
608: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
609: insert into igw_budget_details_cal_amts (
610: proposal_id
611: ,version_id
612: ,budget_period_id
613: ,line_item_id
638: ,fnd_global.login_id);
639: end if;
640:
641: if l_rate_class_id_eb is not null and l_rate_type_id_eb is not null then
642: insert into igw_budget_details_cal_amts (
643: proposal_id
644: ,version_id
645: ,budget_period_id
646: ,line_item_id
913: into l_line_item_seq
914: from dual;
915:
916:
917: update igw_budget_details_cal_amts pdc
918: set pdc.calculated_cost =
919: (select nvl(sum(ppc.calculated_cost),0)
920: from igw_budget_personnel_cal_amts ppc
921: , igw_budget_personnel_details ppd
976: select nvl(sum(calculated_cost_sharing),0)
977: , nvl(sum(calculated_cost),0)
978: into l_cost_share2
979: , l_indirect_cost
980: from igw_budget_details_cal_amts pc
981: where proposal_id = p_proposal_id
982: and version_id = p_version_id
983: and budget_period_id = i+1
984: and pc.rate_class_id = ( select pr.rate_class_id
988: select nvl(sum(calculated_cost_sharing),0)
989: , nvl(sum(calculated_cost),0)
990: into l_cost_share3
991: , l_direct_cost2
992: from igw_budget_details_cal_amts pc
993: where proposal_id = p_proposal_id
994: and version_id = p_version_id
995: and budget_period_id = i+1
996: and pc.rate_class_id = ( select pr.rate_class_id
1229: end if;
1230: BEGIN
1231: select apply_rate_flag
1232: into l_apply_rate_flag_oh
1233: from igw_budget_details_cal_amts
1234: where line_item_id = rec_budget_details.line_item_id;
1235: EXCEPTION
1236: when no_data_found then null;
1237: End;
1246: End;
1247:
1248:
1249: if l_dummy_based_on is not null then
1250: delete from igw_budget_details_cal_amts
1251: where line_item_id IN (select line_item_id
1252: from igw_budget_details pd
1253: where pd.based_on_line_item = l_dummy_based_on);
1254:
1366:
1367:
1368:
1369: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
1370: insert into igw_budget_details_cal_amts (
1371: proposal_id
1372: ,version_id
1373: ,budget_period_id
1374: ,line_item_id
1456: where line_item_id IN (select line_item_id
1457: from igw_budget_details pd
1458: where pd.based_on_line_item = l_dummy_based_on);
1459:
1460: delete from igw_budget_details_cal_amts
1461: where line_item_id IN (select line_item_id
1462: from igw_budget_details pd
1463: where pd.based_on_line_item = l_dummy_based_on);
1464:
1503: ,rec_budget_details.budget_justification
1504: ,rec_budget_details.location_code);
1505:
1506: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
1507: insert into igw_budget_details_cal_amts (
1508: proposal_id
1509: ,version_id
1510: ,budget_period_id
1511: ,line_item_id
1536: ,fnd_global.login_id);
1537: end if;
1538:
1539: if l_rate_class_id_eb is not null and l_rate_type_id_eb is not null then
1540: insert into igw_budget_details_cal_amts (
1541: proposal_id
1542: ,version_id
1543: ,budget_period_id
1544: ,line_item_id
1764: select igw_budget_details_s.currval
1765: into l_line_item_seq
1766: from dual;
1767:
1768: update igw_budget_details_cal_amts pdc
1769: set pdc.calculated_cost =
1770: (select nvl(sum(ppc.calculated_cost),0)
1771: from igw_budget_personnel_cal_amts ppc
1772: , igw_budget_personnel_details ppd
1828: select nvl(sum(calculated_cost_sharing),0)
1829: , nvl(sum(calculated_cost),0)
1830: into l_cost_share2
1831: , l_indirect_cost
1832: from igw_budget_details_cal_amts pc
1833: where proposal_id = p_proposal_id
1834: and version_id = p_version_id
1835: and budget_period_id = i
1836: and pc.rate_class_id = ( select pr.rate_class_id
1840: select nvl(sum(calculated_cost_sharing),0)
1841: , nvl(sum(calculated_cost),0)
1842: into l_cost_share3
1843: , l_direct_cost2
1844: from igw_budget_details_cal_amts pc
1845: where proposal_id = p_proposal_id
1846: and version_id = p_version_id
1847: and budget_period_id = i
1848: and pc.rate_class_id = ( select pr.rate_class_id
1970:
1971: begin
1972: select calculated_cost
1973: into l_calculated_cost
1974: from igw_budget_details_cal_amts
1975: where line_item_id = p_line_item_id;
1976: exception
1977: when no_data_found then null;
1978: end;
2170: update igw_budget_details
2171: set line_item_cost = nvl(l_new_line_item_cost, line_item_cost)
2172: where line_item_id = p_line_item_id;
2173:
2174: update igw_budget_details_cal_amts
2175: set calculated_cost = nvl(l_new_calculated_cost, calculated_cost)
2176: where line_item_id = p_line_item_id;
2177:
2178: