APPS.PSB_WS_POS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 444

    SELECT position_line_id,
	   budget_year_id,
	   service_package_id,
	   stage_set_id,
	   start_stage_seq,
	   current_stage_seq,
	   end_stage_seq
      FROM PSB_WS_FTE_LINES
     WHERE fte_line_id = p_fte_line_id;

Line: 455

    SELECT annual_fte
      FROM PSB_WS_ACCOUNT_LINES
     WHERE l_current_stage_seq BETWEEN start_stage_seq AND current_stage_seq
       AND stage_set_id       = l_stage_set_id
       AND service_package_id = l_service_package_id
       AND budget_year_id     = l_budget_year_id
       AND position_line_id   = l_position_line_id;

Line: 464

    SELECT annual_fte,
           period1_fte,
           period2_fte,
           period3_fte,
           period4_fte,
           period5_fte,
           period6_fte,
           period7_fte,
           period8_fte,
           period9_fte,
           period10_fte,
           period11_fte,
           period12_fte
      FROM psb_ws_fte_lines
     WHERE l_current_stage_seq BETWEEN start_stage_seq AND current_stage_seq
       AND stage_set_id       = l_stage_set_id
       AND service_package_id = l_service_package_id
       AND budget_year_id     = l_budget_year_id
       AND position_line_id   = l_position_line_id;

Line: 831

PROCEDURE Update_Annual_FTE
( p_api_version         IN   NUMBER,
  p_init_msg_list       IN   VARCHAR2 := FND_API.G_FALSE,
  p_commit              IN   VARCHAR2 := FND_API.G_FALSE,
  p_validation_level    IN   NUMBER  := FND_API.G_VALID_LEVEL_NONE,
  p_return_status       OUT  NOCOPY  VARCHAR2,
  p_msg_count           OUT  NOCOPY  NUMBER,
  p_msg_data            OUT  NOCOPY  VARCHAR2,
  p_worksheet_id        IN   NUMBER,
  p_position_line_id    IN   NUMBER,
  p_budget_year_id      IN   NUMBER,
  p_service_package_id  IN   NUMBER,
  p_stage_set_id        IN   NUMBER,
  p_current_stage_seq   IN   NUMBER,
  p_budget_group_id     IN   NUMBER := FND_API.G_MISS_NUM
) IS

  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Annual_FTE';

Line: 855

  SAVEPOINT  Update_Annual_FTE_Pvt;

Line: 878

  PSB_WS_POS1.Update_Annual_FTE
     (p_api_version => 1.0,
      p_validation_level => p_validation_level,
      p_return_status => p_return_status,
      p_worksheet_id => p_worksheet_id,
      p_position_line_id => p_position_line_id,
      p_budget_year_id => p_budget_year_id,
      p_service_package_id => p_service_package_id,
      p_stage_set_id => p_stage_set_id,
      p_current_stage_seq => p_current_stage_seq,
      p_budget_group_id => p_budget_group_id);

Line: 907

     rollback to Update_Annual_FTE_Pvt;

Line: 915

     rollback to Update_Annual_FTE_Pvt;

Line: 923

     rollback to Update_Annual_FTE_Pvt;

Line: 934

END Update_Annual_FTE;

Line: 1354

  FOR rec_wal IN (SELECT count(*) record_count
                   FROM psb_ws_account_lines
                  WHERE position_line_id = p_position_line_id
                    AND budget_group_changed = 'Y')
  LOOP
    IF rec_wal.record_count > 0
    THEN
      DELETE FROM psb_ws_lines
       WHERE account_line_id IN (SELECT account_line_id
                                   FROM psb_ws_account_lines
                                  WHERE position_line_id = p_position_line_id
                                    AND budget_group_changed = 'Y');

Line: 1367

      DELETE FROM psb_ws_account_lines
       WHERE position_line_id = p_position_line_id
         AND budget_group_changed = 'Y';