APPS.IGW_BUDGET_OPERATIONS dependencies on IGW_BUDGET_PERIODS

Line 50: from igw_budget_periods

46: cursor c_budget_periods is
47: select budget_period_id
48: , start_date
49: , end_date
50: from igw_budget_periods
51: where proposal_id = p_proposal_id
52: and version_id = p_version_id;
53:
54: l_budget_period_id NUMBER(15);

Line 556: update igw_budget_periods

552: from igw_rate_classes pr
553: where pc.rate_class_id = pr.rate_class_id
554: and pr.rate_class_type = 'E');
555:
556: update igw_budget_periods
557: set total_cost = (l_direct_cost1+l_direct_cost2+l_indirect_cost)
558: , total_direct_cost = (l_direct_cost1+l_direct_cost2)
559: , total_indirect_cost = l_indirect_cost
560: , cost_sharing_amount = (l_cost_share1+l_cost_share2+l_cost_share3)

Line 581: from igw_budget_periods

577: , l_total_indirect_cost
578: , l_cost_sharing_amt
579: , l_underrecovery_amount
580: , l_total_cost_limit
581: from igw_budget_periods
582: where proposal_id = p_proposal_id
583: and version_id = p_version_id;
584:
585:

Line 645: from igw_budget_periods

641: l_version_id NUMBER(4);
642:
643: cursor c_budget_periods is
644: select *
645: from igw_budget_periods
646: where proposal_id = p_proposal_id
647: and version_id = l_version_id;
648:
649: l_budget_period_id NUMBER(15);

Line 848: insert into igw_budget_periods( proposal_id

844: if p_copy_first_period = 'S' then
845: EXIT when l_loop_counter = 2;
846: end if;
847:
848: insert into igw_budget_periods( proposal_id
849: ,version_id
850: ,budget_period_id
851: ,start_date
852: ,end_date

Line 1107: update igw_budget_periods

1103: from igw_rate_classes pr
1104: where pc.rate_class_id = pr.rate_class_id
1105: and pr.rate_class_type = 'E');
1106:
1107: update igw_budget_periods
1108: set total_cost = (l_direct_cost1+l_direct_cost2+l_indirect_cost)
1109: , total_direct_cost = (l_direct_cost1+l_direct_cost2)
1110: , total_indirect_cost = l_indirect_cost
1111: , cost_sharing_amount = (l_cost_share1+l_cost_share2+l_cost_share3)

Line 1131: from igw_budget_periods

1127: , l_total_indirect_cost
1128: , l_cost_sharing_amt
1129: , l_underrecovery_amount
1130: , l_total_cost_limit
1131: from igw_budget_periods
1132: where proposal_id = p_target_proposal_id
1133: and version_id = l_target_version_id;
1134:
1135:

Line 1221: from igw_budget_periods

1217: , end_date
1218: , total_direct_cost
1219: , total_indirect_cost
1220: , total_cost
1221: from igw_budget_periods
1222: where proposal_id = p_proposal_id
1223: and version_id = p_version_id
1224: and budget_period_id = nvl(p_budget_period_id, budget_period_id);
1225:

Line 1834: update igw_budget_periods

1830: from igw_rate_classes pr
1831: where pc.rate_class_id = pr.rate_class_id
1832: and pr.rate_class_type = 'E');
1833:
1834: update igw_budget_periods
1835: set total_cost = (l_direct_cost1+l_direct_cost2+l_indirect_cost)
1836: , total_direct_cost = (l_direct_cost1+l_direct_cost2)
1837: , total_indirect_cost = l_indirect_cost
1838: , cost_sharing_amount = (l_cost_share1+l_cost_share2+l_cost_share3)

Line 1848: update igw_budget_periods

1844: end LOOP; --rec_budget_periods
1845: elsif l_enter_budget_at_period_level = 'Y' then
1846: for rec_budget_periods in c_budget_periods
1847: LOOP
1848: update igw_budget_periods
1849: set total_cost = nvl(rec_budget_periods.total_direct_cost,0) + nvl(rec_budget_periods.total_indirect_Cost,0)
1850: where proposal_id = p_proposal_id
1851: and version_id = p_version_id
1852: and budget_period_id = rec_budget_periods.budget_period_id;

Line 1870: from igw_budget_periods

1866: , l_total_indirect_cost
1867: , l_cost_sharing_amt
1868: , l_underrecovery_amount
1869: --, l_total_cost_limit
1870: from igw_budget_periods
1871: where proposal_id = p_proposal_id
1872: and version_id = p_version_id;
1873:
1874: