APPS.PSB_WS_ACCT_PVT SQL Statements

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

Line: 501

PROCEDURE Update_GL_Balances
( 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
) IS

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

Line: 520

  SAVEPOINT  Update_GL_Balances_Pvt;

Line: 543

  PSB_WS_ACCT2.Update_GL_Balances
     (p_api_version => 1.0,
      p_validation_level => p_validation_level,
      p_return_status => l_return_status,
      p_worksheet_id => p_worksheet_id);

Line: 580

     rollback to Update_GL_Balances_Pvt;

Line: 587

     rollback to Update_GL_Balances_Pvt;

Line: 594

     rollback to Update_GL_Balances_Pvt;

Line: 605

END Update_GL_Balances;

Line: 715

 |                   PROCEDURE Update_GL_Balances_CP                         |
 +===========================================================================*/
--
-- This is the execution file for the concurrent program 'Update_GL_Balances_CP'
-- which runs 'Update GL Balances' program through the
-- Standard Report Submissions.
--
PROCEDURE Update_GL_Balances_CP
(
  errbuf                      OUT  NOCOPY      VARCHAR2  ,
  retcode                     OUT  NOCOPY      VARCHAR2  ,
  p_worksheet_id              IN       NUMBER := FND_API.G_MISS_NUM
)
IS
  --
   l_api_name       CONSTANT VARCHAR2(30)   := 'Update_GL_Balances_CP';

Line: 754

   PSB_WS_ACCT_PVT.Update_GL_Balances
     (p_api_version => 1.0,
      p_init_msg_list => FND_API.G_TRUE,
      p_return_status => l_return_status,
      p_msg_count => l_msg_count,
      p_msg_data => l_msg_data,
      p_worksheet_id => p_worksheet_id);

Line: 847

END Update_GL_Balances_CP ;