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.IGW_BUDGET_OPERATIONS dependencies on IGW_BUDGET_DETAILS

Line 68: from igw_budget_details pbd

64: , et.personnel_attached_flag
65: , pbd.budget_period_id
66: , pbd.proposal_id
67: , pbd.version_id
68: from igw_budget_details pbd
69: , igw_budget_expenditures_v et
70: where pbd.expenditure_type = et.budget_expenditure
71: and pbd.expenditure_category_flag = et.expenditure_category_flag
72: and pbd.proposal_id = p_proposal_id

Line 182: from igw_budget_details_cal_amts

178: end if;
179: BEGIN
180: select apply_rate_flag
181: into l_apply_rate_flag_oh
182: from igw_budget_details_cal_amts
183: where line_item_id = rec_budget_details.line_item_id;
184: EXCEPTION
185: when no_data_found then
186: l_apply_rate_flag_oh := 'Y';

Line 234: update igw_budget_details

230: end if;
231: end if;
232:
233:
234: update igw_budget_details
235: set line_item_cost = l_base_amount
236: , underrecovery_amount = nvl(l_oh_value - l_oh_value_ov,0)
237: where line_item_id = rec_budget_details.line_item_id;
238:

Line 239: delete from igw_budget_details_cal_amts

235: set line_item_cost = l_base_amount
236: , underrecovery_amount = nvl(l_oh_value - l_oh_value_ov,0)
237: where line_item_id = rec_budget_details.line_item_id;
238:
239: delete from igw_budget_details_cal_amts
240: where line_item_id = rec_budget_details.line_item_id;
241:
242: if check_exp_assignment(rec_budget_details.expenditure_type
243: ,rec_budget_details.expenditure_category_flag

Line 444: delete from igw_budget_details_cal_amts

440:
441: END LOOP; --rec_budget_personnel
442:
443:
444: delete from igw_budget_details_cal_amts
445: where line_item_id = rec_budget_details.line_item_id;
446:
447: select sum(nvl(ppc.calculated_cost,0))
448: , sum(nvl(ppc.calculated_cost_sharing,0))

Line 510: update igw_budget_details pdb

506: , l_underrecovery_amount_upd
507: from igw_budget_personnel_details ppd
508: where ppd.line_item_id = rec_budget_details.line_item_id;
509:
510: update igw_budget_details pdb
511: set line_item_cost = nvl(l_salary_requested_upd,0)
512: , cost_sharing_amount = nvl(l_cost_sharing_amount_upd,0)
513: , underrecovery_amount = nvl(l_underrecovery_amount_upd,0)
514: where pdb.line_item_id = rec_budget_details.line_item_id;

Line 526: from igw_budget_details

522: , nvl(sum(underrecovery_amount),0)
523: into l_direct_cost1
524: , l_cost_share1
525: , l_underrecovery
526: from igw_budget_details
527: where proposal_id = p_proposal_id
528: and version_id = p_version_id
529: and budget_period_id = rec_budget_periods.budget_period_id;
530:

Line 535: from igw_budget_details_cal_amts pc

531: select nvl(sum(calculated_cost_sharing),0)
532: , nvl(sum(calculated_cost),0)
533: into l_cost_share2
534: , l_indirect_cost
535: from igw_budget_details_cal_amts pc
536: where proposal_id = p_proposal_id
537: and version_id = p_version_id
538: and budget_period_id = rec_budget_periods.budget_period_id
539: and pc.rate_class_id = ( select pr.rate_class_id

Line 547: from igw_budget_details_cal_amts pc

543: select nvl(sum(calculated_cost_sharing),0)
544: , nvl(sum(calculated_cost),0)
545: into l_cost_share3
546: , l_direct_cost2
547: from igw_budget_details_cal_amts pc
548: where proposal_id = p_proposal_id
549: and version_id = p_version_id
550: and budget_period_id = rec_budget_periods.budget_period_id
551: and pc.rate_class_id = ( select pr.rate_class_id

Line 666: from igw_budget_details pbd

662: , pbd.budget_justification
663: , pbd.location_code
664: , et.personnel_attached_flag
665: , pbd.budget_period_id
666: from igw_budget_details pbd
667: , igw_budget_expenditures_v et
668: where pbd.expenditure_type = et.budget_expenditure
669: and pbd.expenditure_category_flag = et.expenditure_category_flag
670: and pbd.proposal_id = p_proposal_id

Line 679: from igw_budget_details_cal_amts

675:
676:
677: cursor c_budget_detail_amts is
678: select *
679: from igw_budget_details_cal_amts
680: where line_item_id = l_line_item_id;
681:
682:
683: cursor c_budget_personnel is

Line 894: select igw_budget_details_s.currval into l_based_on_line_item from dual;

890: LOOP
891: if l_counter = 1 then
892: l_based_on_line_item := null;
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

Line 948: ,igw_budget_details_s.currval

944: values (igw_budget_personnel_s.nextval
945: ,p_target_proposal_id
946: ,l_target_version_id
947: ,rec_budget_details.budget_period_id
948: ,igw_budget_details_s.currval
949: ,rec_budget_personnel.person_id
950: ,rec_budget_personnel.party_id
951: ,rec_budget_personnel.start_date
952: ,rec_budget_personnel.end_date

Line 986: select igw_budget_details_s.currval into l_dummy_line_item_id from dual;

982: l_line_item_id := rec_budget_details.line_item_id;
983: for rec_budget_detail_amts in c_budget_detail_amts
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

Line 1077: from igw_budget_details

1073: , nvl(sum(underrecovery_amount),0)
1074: into l_direct_cost1
1075: , l_cost_share1
1076: , l_underrecovery
1077: from igw_budget_details
1078: where proposal_id = p_target_proposal_id
1079: and version_id = l_target_version_id
1080: and budget_period_id = 1;
1081:

Line 1086: from igw_budget_details_cal_amts pc

1082: select nvl(sum(calculated_cost_sharing),0)
1083: , nvl(sum(calculated_cost),0)
1084: into l_cost_share2
1085: , l_indirect_cost
1086: from igw_budget_details_cal_amts pc
1087: where proposal_id = p_target_proposal_id
1088: and version_id = l_target_version_id
1089: and budget_period_id = 1
1090: and pc.rate_class_id = ( select pr.rate_class_id

Line 1098: from igw_budget_details_cal_amts pc

1094: select nvl(sum(calculated_cost_sharing),0)
1095: , nvl(sum(calculated_cost),0)
1096: into l_cost_share3
1097: , l_direct_cost2
1098: from igw_budget_details_cal_amts pc
1099: where proposal_id = p_target_proposal_id
1100: and version_id = l_target_version_id
1101: and budget_period_id = 1
1102: and pc.rate_class_id = ( select pr.rate_class_id

Line 1240: from igw_budget_details pbd

1236: , et.personnel_attached_flag
1237: , pbd.budget_period_id
1238: , pbd.proposal_id
1239: , pbd.version_id
1240: from igw_budget_details pbd
1241: , igw_budget_expenditures_v et
1242: where pbd.expenditure_type = et.budget_expenditure
1243: and pbd.expenditure_category_flag = et.expenditure_category_flag
1244: and pbd.proposal_id = p_proposal_id

Line 1396: from igw_budget_details_cal_amts

1392: end if;
1393: BEGIN
1394: select apply_rate_flag, calculated_cost, calculated_cost_sharing
1395: into l_apply_rate_flag_oh, l_oh_value_ov_usr, l_calculated_cost_share_ov_usr
1396: from igw_budget_details_cal_amts
1397: where line_item_id = rec_budget_details.line_item_id;
1398: EXCEPTION
1399: when no_data_found then
1400: l_apply_rate_flag_oh := 'Y';

Line 1454: update igw_budget_details

1450: end if;
1451:
1452: if l_apply_oh_setup_rates = 'Y' then
1453: /* underrecovery is Oh value using setup rates minus oh value using setup/overwritten rates */
1454: update igw_budget_details
1455: set line_item_cost = l_base_amount
1456: , underrecovery_amount = nvl(l_oh_value - l_oh_value_ov,0)
1457: where line_item_id = rec_budget_details.line_item_id;
1458: else

Line 1459: update igw_budget_details

1455: set line_item_cost = l_base_amount
1456: , underrecovery_amount = nvl(l_oh_value - l_oh_value_ov,0)
1457: where line_item_id = rec_budget_details.line_item_id;
1458: else
1459: update igw_budget_details
1460: set line_item_cost = l_base_amount
1461: , underrecovery_amount = nvl(l_oh_value - l_oh_value_ov_usr,0)
1462: where line_item_id = rec_budget_details.line_item_id;
1463: end if;

Line 1465: delete from igw_budget_details_cal_amts

1461: , underrecovery_amount = nvl(l_oh_value - l_oh_value_ov_usr,0)
1462: where line_item_id = rec_budget_details.line_item_id;
1463: end if;
1464:
1465: delete from igw_budget_details_cal_amts
1466: where line_item_id = rec_budget_details.line_item_id;
1467:
1468: if check_exp_assignment(rec_budget_details.expenditure_type
1469: ,rec_budget_details.expenditure_category_flag

Line 1722: delete from igw_budget_details_cal_amts

1718:
1719: END LOOP; --rec_budget_personnel
1720:
1721:
1722: delete from igw_budget_details_cal_amts
1723: where line_item_id = rec_budget_details.line_item_id;
1724:
1725: select sum(nvl(ppc.calculated_cost,0))
1726: , sum(nvl(ppc.calculated_cost_sharing,0))

Line 1788: update igw_budget_details pdb

1784: , l_underrecovery_amount_upd
1785: from igw_budget_personnel_details ppd
1786: where ppd.line_item_id = rec_budget_details.line_item_id;
1787:
1788: update igw_budget_details pdb
1789: set line_item_cost = nvl(l_salary_requested_upd,0)
1790: , cost_sharing_amount = nvl(l_cost_sharing_amount_upd,0)
1791: , underrecovery_amount = nvl(l_underrecovery_amount_upd,0)
1792: where pdb.line_item_id = rec_budget_details.line_item_id;

Line 1804: from igw_budget_details

1800: , nvl(sum(underrecovery_amount),0)
1801: into l_direct_cost1
1802: , l_cost_share1
1803: , l_underrecovery
1804: from igw_budget_details
1805: where proposal_id = p_proposal_id
1806: and version_id = p_version_id
1807: and budget_period_id = rec_budget_periods.budget_period_id;
1808:

Line 1813: from igw_budget_details_cal_amts pc

1809: select nvl(sum(calculated_cost_sharing),0)
1810: , nvl(sum(calculated_cost),0)
1811: into l_cost_share2
1812: , l_indirect_cost
1813: from igw_budget_details_cal_amts pc
1814: where proposal_id = p_proposal_id
1815: and version_id = p_version_id
1816: and budget_period_id = rec_budget_periods.budget_period_id
1817: and pc.rate_class_id = ( select pr.rate_class_id

Line 1825: from igw_budget_details_cal_amts pc

1821: select nvl(sum(calculated_cost_sharing),0)
1822: , nvl(sum(calculated_cost),0)
1823: into l_cost_share3
1824: , l_direct_cost2
1825: from igw_budget_details_cal_amts pc
1826: where proposal_id = p_proposal_id
1827: and version_id = p_version_id
1828: and budget_period_id = rec_budget_periods.budget_period_id
1829: and pc.rate_class_id = ( select pr.rate_class_id