APPS.IGW_BUDGETS_PVT dependencies on DUAL

Line 330: select igw_award_budget_s.nextval into l_award_budget_id from dual;

326:
327:
328: for rec_budget_details in c_budget_details
329: LOOP
330: select igw_award_budget_s.nextval into l_award_budget_id from dual;
331:
332: if (l_time_phased_type_code IN ('G', 'P')) then
333: Begin
334: --dbms_output.put_line('--------till here 8----------');

Line 424: select igw_award_budget_s.nextval into l_award_budget_id from dual;

420:
421: for rec_budget_indirect_cost in c_budget_indirect_cost
422: LOOP
423: if (rec_budget_indirect_cost.indirect_cost > 0) then
424: select igw_award_budget_s.nextval into l_award_budget_id from dual;
425:
426: select start_date, end_date
427: into l_start_date, l_end_date
428: from igw_budget_periods

Line 741: ,p_residual_funds NUMBER := 0

737: ,p_total_direct_cost NUMBER := 0
738: ,p_total_indirect_cost NUMBER := 0
739: ,p_cost_sharing_amount NUMBER := 0
740: ,p_underrecovery_amount NUMBER := 0
741: ,p_residual_funds NUMBER := 0
742: ,p_total_cost_limit NUMBER
743: ,p_oh_rate_class_id NUMBER
744: ,p_oh_rate_class_name VARCHAR2
745: ,p_proposal_form_number VARCHAR2

Line 883: ,p_residual_funds => p_residual_funds

879: ,p_total_direct_cost => p_total_direct_cost
880: ,p_total_indirect_cost => p_total_indirect_cost
881: ,p_cost_sharing_amount => p_cost_sharing_amount
882: ,p_underrecovery_amount => p_underrecovery_amount
883: ,p_residual_funds => p_residual_funds
884: ,p_total_cost_limit => p_total_cost_limit
885: ,p_oh_rate_class_id => l_rate_class_id
886: ,p_proposal_form_number => p_proposal_form_number
887: ,p_comments => p_comments

Line 1037: ,p_residual_funds NUMBER

1033: ,p_total_direct_cost NUMBER
1034: ,p_total_indirect_cost NUMBER
1035: ,p_cost_sharing_amount NUMBER
1036: ,p_underrecovery_amount NUMBER
1037: ,p_residual_funds NUMBER
1038: ,p_total_cost_limit NUMBER
1039: ,p_oh_rate_class_id NUMBER
1040: ,p_oh_rate_class_name VARCHAR2
1041: ,p_proposal_form_number VARCHAR2

Line 1220: ,p_residual_funds => p_residual_funds

1216: ,p_total_direct_cost => p_total_direct_cost
1217: ,p_total_indirect_cost => p_total_indirect_cost
1218: ,p_cost_sharing_amount => p_cost_sharing_amount
1219: ,p_underrecovery_amount => p_underrecovery_amount
1220: ,p_residual_funds => p_residual_funds
1221: ,p_total_cost_limit => p_total_cost_limit
1222: ,p_oh_rate_class_id => l_rate_class_id
1223: ,p_proposal_form_number => p_proposal_form_number
1224: ,p_comments => p_comments