APPS.IGW_BUDGET_OPERATIONS dependencies on IGW_BUDGETS

Line 586: update igw_budgets

582: where proposal_id = p_proposal_id
583: and version_id = p_version_id;
584:
585:
586: update igw_budgets
587: set total_cost = l_total_cost
588: , total_direct_cost = l_total_direct_cost
589: , total_indirect_cost = l_total_indirect_cost
590: , cost_sharing_amount = l_cost_sharing_amt

Line 637: from igw_budgets

633:
634:
635: cursor c_budgets is
636: select *
637: from igw_budgets
638: where proposal_id = p_proposal_id
639: and version_id = nvl(p_version_id, version_id);
640:
641: l_version_id NUMBER(4);

Line 738: from igw_budgets

734:
735: if p_copy_type = 'B' then
736: select max(version_id)+1
737: into l_target_version_id
738: from igw_budgets
739: where proposal_id = p_proposal_id;
740:
741: --dbms_output.put_line('the max version id available is '||l_target_version_id);
742: end if;

Line 757: insert into igw_budgets( proposal_id

753: end if;
754: end if;
755: l_version_id := rec_budgets.version_id;
756:
757: insert into igw_budgets( proposal_id
758: ,version_id
759: ,start_date
760: ,end_date
761: ,total_cost

Line 1136: update igw_budgets

1132: where proposal_id = p_target_proposal_id
1133: and version_id = l_target_version_id;
1134:
1135:
1136: update igw_budgets
1137: set total_cost = l_total_cost
1138: , total_direct_cost = l_total_direct_cost
1139: , total_indirect_cost = l_total_indirect_cost
1140: , cost_sharing_amount = l_cost_sharing_amt

Line 1209: from igw_budgets

1205: select enter_budget_at_period_level
1206: , apply_inflation_setup_rates
1207: , apply_eb_setup_rates
1208: , apply_oh_setup_rates
1209: from igw_budgets
1210: where proposal_id = p_proposal_id
1211: and version_id = p_version_id;
1212:
1213:

Line 1345: from igw_budgets

1341:
1342: if p_oh_rate_class_id is null then
1343: select oh_rate_class_id
1344: into l_oh_rate_class_id
1345: from igw_budgets
1346: where proposal_id = p_proposal_id
1347: and version_id = p_version_id;
1348: end if;
1349: end if;

Line 1875: update igw_budgets

1871: where proposal_id = p_proposal_id
1872: and version_id = p_version_id;
1873:
1874:
1875: update igw_budgets
1876: set total_cost = l_total_cost
1877: , total_direct_cost = l_total_direct_cost
1878: , total_indirect_cost = l_total_indirect_cost
1879: , cost_sharing_amount = l_cost_sharing_amt