APPS.IGC_CC_BC_ENABLE_PKG SQL Statements

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

Line: 11

 |                       PROCEDURE Insert_Row                            |
 +=======================================================================*/
PROCEDURE Insert_Row
(
  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_FULL,
  x_return_status             OUT NOCOPY      VARCHAR2,
  x_msg_count                 OUT NOCOPY      NUMBER,
  x_msg_data                  OUT NOCOPY      VARCHAR2,

  p_row_id    	              IN OUT NOCOPY   VARCHAR2,
  p_set_of_books_id                    NUMBER,
  p_cc_bc_enable_flag                  VARCHAR2,
  p_last_update_date		       DATE,
  p_last_updated_by		       NUMBER,
  p_last_update_login		       NUMBER,
  p_created_by                         NUMBER,
  p_creation_date		       DATE,
  p_cbc_po_enable                      VARCHAR2
)
IS

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

Line: 38

  CURSOR C IS SELECT ROWID FROM igc_cc_bc_enable
              WHERE set_of_books_id = p_set_of_books_id;

Line: 43

  SAVEPOINT Insert_Row_Pvt ;

Line: 60

  INSERT INTO igc_cc_bc_enable
              (
		set_of_books_id,
                cc_bc_enable_flag,
		last_update_date,
		last_updated_by,
		last_update_login,
                created_by,
		creation_date,
                cbc_po_enable
              )
  VALUES
              (
		p_set_of_books_id,
		p_cc_bc_enable_flag,
  		p_last_update_date,
  		p_last_updated_by,
  		p_last_update_login,
  		p_created_by,
  		p_creation_date,
                p_cbc_po_enable
              );

Line: 102

    ROLLBACK TO Insert_Row_Pvt ;

Line: 109

    ROLLBACK TO Insert_Row_Pvt ;

Line: 116

    ROLLBACK TO Insert_Row_Pvt ;

Line: 127

END Insert_Row;

Line: 160

       SELECT * FROM igc_cc_bc_enable
       WHERE rowid = p_row_id
       FOR UPDATE NOWAIT;

Line: 190

    FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 262

 |                       PROCEDURE Update_Row                               |
 +==========================================================================*/
PROCEDURE Update_Row
(
  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_FULL,
  x_return_status             OUT NOCOPY      VARCHAR2,
  x_msg_count                 OUT NOCOPY      NUMBER,
  x_msg_data                  OUT NOCOPY      VARCHAR2,

  p_row_id                    IN OUT NOCOPY   VARCHAR2,
  p_set_of_books_id	               NUMBER,
  p_cc_bc_enable_flag	               VARCHAR2,
  p_last_update_date                   DATE,
  p_last_updated_by                    NUMBER,
  p_last_update_login                  NUMBER,
  p_cbc_po_enable                      VARCHAR2
)
IS

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

Line: 289

  SAVEPOINT Update_Row_Pvt ;

Line: 307

  UPDATE igc_cc_bc_enable
  SET
	set_of_books_id         =  p_set_of_books_id,
        cc_bc_enable_flag       =  p_cc_bc_enable_flag,
        last_update_date        =  p_last_update_date ,
        last_updated_by         =  p_last_updated_by ,
        last_update_login       =  p_last_update_login,
        cbc_po_enable           =  p_cbc_po_enable
  WHERE rowid = p_row_id;

Line: 333

    ROLLBACK TO Update_Row_Pvt ;

Line: 340

    ROLLBACK TO Update_Row_Pvt ;

Line: 347

    ROLLBACK TO Update_Row_Pvt ;

Line: 358

END Update_Row;

Line: 365

 |                       PROCEDURE Delete_Row                               |
 +==========================================================================*/
PROCEDURE Delete_Row
(
  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_FULL,
  x_return_status             OUT NOCOPY      VARCHAR2,
  x_msg_count                 OUT NOCOPY      NUMBER,
  x_msg_data                  OUT NOCOPY      VARCHAR2,

  p_row_id                    IN        VARCHAR2
)
IS

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

Line: 390

  SAVEPOINT Delete_Row_Pvt ;

Line: 409

  DELETE FROM igc_cc_bc_enable
  WHERE rowid = p_row_id;

Line: 429

    ROLLBACK TO Delete_Row_Pvt ;

Line: 436

    ROLLBACK TO Delete_Row_Pvt ;

Line: 443

    ROLLBACK TO Delete_Row_Pvt ;

Line: 454

END Delete_Row;

Line: 484

    SELECT '1'
    FROM  igc_cc_bc_enable
    WHERE set_of_books_id = p_set_of_books_id
      AND  (
             p_row_id IS NULL
             OR
             rowid <> p_row_id
           );