eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WORKSHEET_PVT SQL Statements

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

Line: 99


PROCEDURE Delete_WS_Line_Items
( 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_global_worksheet  IN   VARCHAR2 := FND_API.G_TRUE
) IS

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

Line: 118


  SAVEPOINT     Delete_WS_Line_Items_Pvt;

Line: 141


  PSB_WORKSHEET.Delete_WS_Line_Items
     (p_api_version => 1.0,
      p_return_status => p_return_status,
      p_worksheet_id => p_worksheet_id,
      p_global_worksheet => p_global_worksheet);

Line: 163


     rollback to Delete_WS_Line_Items_Pvt;

Line: 170


     rollback to Delete_WS_Line_Items_Pvt;

Line: 177


     rollback to Delete_WS_Line_Items_Pvt;

Line: 188


END Delete_WS_Line_Items;

Line: 400


PROCEDURE Update_Worksheet
( 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_worksheet_type                    IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_description                       IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_ws_creation_complete              IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_global_worksheet_id               IN   NUMBER := FND_API.G_MISS_NUM,
  p_current_stage_seq                 IN   NUMBER := FND_API.G_MISS_NUM,
  p_local_copy_flag                   IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_copy_of_worksheet_id              IN   NUMBER := FND_API.G_MISS_NUM,
  p_freeze_flag                       IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_use_revised_element_rates         IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  /* Bug # 3083970 */
  p_num_proposed_years                IN   NUMBER := FND_API.G_MISS_NUM,
  p_rounding_factor                   IN   NUMBER := FND_API.G_MISS_NUM,
  /* End bug */
  p_date_submitted                    IN   DATE := FND_API.G_MISS_DATE,
  p_submitted_by                      IN   NUMBER := FND_API.G_MISS_NUM,
  p_attribute1                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute2                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute3                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute4                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute5                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute6                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute7                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute8                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute9                        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute10                       IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_context                           IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_create_non_pos_line_items         IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_apply_element_parameters          IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_apply_position_parameters         IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_create_positions                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_create_summary_totals             IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_apply_constraints                 IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_include_gl_commit_balance         IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_include_gl_oblig_balance          IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_include_gl_other_balance          IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_include_cbc_commit_balance        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_include_cbc_oblig_balance         IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_include_cbc_budget_balance        IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  /* For Bug No. 2312657 : Start */
  p_gl_cutoff_period                  IN   DATE := NULL,
  p_gl_budget_set_id                  IN   NUMBER := NULL,
  /* For Bug No. 2312657 : End */
  p_federal_ws_flag                   IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  /* bug no 4725091 */
  p_include_gl_forwd_balance          IN   VARCHAR2 := FND_API.G_MISS_CHAR
) IS

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

Line: 463


  SAVEPOINT     Update_Worksheet_Pvt;

Line: 486


  PSB_WORKSHEET.Update_Worksheet
     (p_api_version => 1.0,
      p_validation_level => p_validation_level,
      p_return_status => p_return_status,
      p_worksheet_id => p_worksheet_id,
      p_worksheet_type => p_worksheet_type,
      p_description => p_description,
      p_ws_creation_complete => p_ws_creation_complete,
      p_global_worksheet_id => p_global_worksheet_id,
      p_current_stage_seq => p_current_stage_seq,
      p_local_copy_flag => p_local_copy_flag,
      p_copy_of_worksheet_id => p_copy_of_worksheet_id,
      p_freeze_flag => p_freeze_flag,
      p_use_revised_element_rates => p_use_revised_element_rates,
      /* Bug # 3083970 */
      p_num_proposed_years => p_num_proposed_years,
      p_rounding_factor => p_rounding_factor,
      /* End bug */
      p_date_submitted => p_date_submitted,
      p_submitted_by => p_submitted_by,
      p_attribute1 => p_attribute1,
      p_attribute2 => p_attribute2,
      p_attribute3 => p_attribute3,
      p_attribute4 => p_attribute4,
      p_attribute5 => p_attribute5,
      p_attribute6 => p_attribute6,
      p_attribute7 => p_attribute7,
      p_attribute8 => p_attribute8,
      p_attribute9 => p_attribute9,
      p_attribute10 => p_attribute10,
      p_context => p_context,
      p_create_non_pos_line_items => p_create_non_pos_line_items,
      p_apply_element_parameters  => p_apply_element_parameters,
      p_apply_position_parameters => p_apply_position_parameters,
      p_create_positions          => p_create_positions,
      p_create_summary_totals     => p_create_summary_totals,
      p_apply_constraints         => p_apply_constraints,
      p_include_gl_commit_balance => p_include_gl_commit_balance,
      p_include_gl_oblig_balance  => p_include_gl_oblig_balance,
      p_include_gl_other_balance  => p_include_gl_other_balance,
      p_include_cbc_commit_balance => p_include_cbc_commit_balance,
      p_include_cbc_oblig_balance => p_include_cbc_oblig_balance,
      p_include_cbc_budget_balance => p_include_cbc_budget_balance,
     /* For Bug No. 2312657 : Start */
      p_gl_cutoff_period           => p_gl_cutoff_period,
      p_gl_budget_set_id           => p_gl_budget_set_id,
      /* For Bug No. 2312657 : End */
      /* For Bug No. 3157960, added federal_ws_flag */
      p_federal_ws_flag            => p_federal_ws_flag,
      /* bug no 4725091 */
      p_include_gl_forwd_balance   => p_include_gl_forwd_balance
      );

Line: 554


     rollback to Update_Worksheet_Pvt;

Line: 561


     rollback to Update_Worksheet_Pvt;

Line: 568


     rollback to Update_Worksheet_Pvt;

Line: 579


END Update_Worksheet;

Line: 583


PROCEDURE Delete_Worksheet
( p_api_version    IN   NUMBER,
  p_init_msg_list  IN   VARCHAR2 := FND_API.G_FALSE,
  p_commit         IN   VARCHAR2 := FND_API.G_FALSE,
  p_return_status  OUT  NOCOPY  VARCHAR2,
  p_msg_count      OUT  NOCOPY  NUMBER,
  p_msg_data       OUT  NOCOPY  VARCHAR2,
  p_worksheet_id   IN   NUMBER
) IS

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

Line: 600


  SAVEPOINT     Delete_Worksheet_Pvt;

Line: 623


  PSB_WORKSHEET.Delete_Worksheet
     (p_api_version => 1.0,
      p_return_status => p_return_status,
      p_worksheet_id => p_worksheet_id);

Line: 644


     rollback to Delete_Worksheet_Pvt;

Line: 652


     rollback to Delete_Worksheet_Pvt;

Line: 660


     rollback to Delete_Worksheet_Pvt;

Line: 672


END Delete_Worksheet;

Line: 880


PROCEDURE Delete_WPL
( p_api_version       IN   NUMBER,
  p_init_msg_list     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
) IS

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

Line: 898


  SAVEPOINT     Delete_WPL_Pvt;

Line: 921


  PSB_WORKSHEET.Delete_WPL
     (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);

Line: 937


     rollback to Delete_WPL_Pvt;

Line: 945


     rollback to Delete_WPL_Pvt;

Line: 953


     rollback to Delete_WPL_Pvt;

Line: 965


END Delete_WPL;

Line: 1005


    select nvl(b.data_extract_id, b.global_data_extract_id) data_extract_id,
           nvl(a.root_budget_group_id, a.budget_group_id) root_budget_group_id
      from PSB_BUDGET_GROUPS_V a,
           PSB_WORKSHEETS_V b
     where a.budget_group_id = b.budget_group_id
       and b.worksheet_id = p_worksheet_id;

Line: 1016


  SELECT nvl(global_worksheet_id, worksheet_id) global_worksheet_id,
         data_extract_id
  INTO   l_global_worksheet_id,
         l_data_extract_id
  FROM   psb_worksheets
  WHERE  worksheet_id = p_worksheet_id;

Line: 1025


    SELECT data_extract_id INTO l_data_extract_id
    FROM   psb_worksheets
    WHERE  worksheet_id = l_global_worksheet_id ;

Line: 1195


  SELECT bg.budget_group_id,
         bg.set_of_books_id
    INTO l_root_budget_group_id,
         l_set_of_books_id
    FROM psb_budget_groups bg
   WHERE bg.budget_group_id =
         (SELECT nvl(bg1.root_budget_group_id, bg1.budget_group_id) root_budget_group_id
            FROM psb_worksheets ws, psb_budget_groups bg1
           WHERE bg1.budget_group_id = ws.budget_group_id
                 and ws.worksheet_id = p_worksheet_id);