[Home] [Help]
5516: cursor c_bp is
5517: select data_extract_id from psb_worksheets where worksheet_id = p_source_id;
5518:
5519: cursor c_revision is
5520: select budget_group_id from psb_budget_revisions where budget_revision_id = p_source_id;
5521:
5522: cursor c_position is
5523: select position_id, name, hr_position_id, hr_employee_id
5524: from psb_positions
5584: for c_revision_rec in c_revision loop
5585: l_budget_group_id := c_revision_rec.budget_group_id;
5586: end loop;
5587:
5588: l_data_extract_id := PSB_BUDGET_REVISIONS_PVT.Find_System_Data_Extract
5589: (p_budget_group_id => l_budget_group_id);
5590:
5591: for c_position_rec in c_position loop
5592:
5797: END LOOP;
5798: -- for bug 4507389
5799:
5800:
5801: l_system_data_extract_id := PSB_BUDGET_REVISIONS_PVT.Find_System_Data_Extract
5802: (p_budget_group_id => l_budget_group_id);
5803:
5804: if l_system_data_extract_id is null then
5805: begin
9627: l_total_fte := 0;
9628:
9629: for c_revision_fte_rec in c_revision_fte loop
9630:
9631: PSB_BUDGET_REVISIONS_PVT.Find_FTE
9632: (p_api_version => 1.0,
9633: p_return_status => l_return_status,
9634: p_msg_count => l_msg_count,
9635: p_msg_data => l_msg_data,
11606: where worksheet_id = p_source_id;
11607:
11608: cursor c_BR is
11609: select budget_group_id
11610: from psb_budget_revisions
11611: where budget_revision_id = p_source_id;
11612:
11613: /*For Bug No : 2292003 Start*/
11614: --added the budget_calendar_id filter
11647:
11648: end;
11649: end if;
11650:
11651: l_system_data_extract_id := PSB_BUDGET_REVISIONS_PVT.Find_System_Data_Extract
11652: (p_budget_group_id => l_budget_group_id);
11653:
11654: -- check that all position transactions in the worksheet have been approved
11655: