APPS.ICX_CAT_R12_UPGRADE_GRP SQL Statements

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

Line: 7

PROCEDURE updatePOHeaderId
(       p_api_version           IN              NUMBER                                  ,
        p_commit                IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_init_msg_list         IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_validation_level      IN              VARCHAR2 := FND_API.G_VALID_LEVEL_FULL  ,
        x_return_status         OUT NOCOPY      VARCHAR2                                ,
        p_interface_header_id   IN              DBMS_SQL.NUMBER_TABLE
)
IS
l_api_name                      CONSTANT VARCHAR2(30)   := 'updatePOHeaderId';

Line: 26

  SAVEPOINT updatePOHeaderId_sp;

Line: 43

  ICX_CAT_R12_UPGRADE_PVT.updatePOHeaderId(p_interface_header_id);

Line: 65

      ROLLBACK TO updatePOHeaderId_sp;

Line: 78

END updatePOHeaderId;

Line: 80

PROCEDURE updatePOLineId
(       p_api_version           IN              NUMBER                                  ,
        p_commit                IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_init_msg_list         IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_validation_level      IN              VARCHAR2 := FND_API.G_VALID_LEVEL_FULL  ,
        x_return_status         OUT NOCOPY      VARCHAR2                                ,
        p_interface_line_id     IN              DBMS_SQL.NUMBER_TABLE
)
IS
l_api_name                      CONSTANT VARCHAR2(30)   := 'updatePOLineId';

Line: 99

  SAVEPOINT updatePOLineId_sp;

Line: 116

  ICX_CAT_R12_UPGRADE_PVT.updatePOLineId(p_interface_line_id);

Line: 139

      ROLLBACK TO updatePOLineId_sp;

Line: 152

END updatePOLineId;

Line: 307

PROCEDURE updateR12UpgradeJob
(       p_api_version           IN              NUMBER                                  ,
        p_commit                IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_init_msg_list         IN              VARCHAR2 := FND_API.G_FALSE             ,
        p_validation_level      IN              VARCHAR2 := FND_API.G_VALID_LEVEL_FULL  ,
        x_return_status         OUT NOCOPY      VARCHAR2                                ,
        p_job_status            IN              VARCHAR2
)
IS

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

Line: 327

  SAVEPOINT updateR12UpgradeJob_sp;

Line: 360

  ICX_CAT_R12_UPGRADE_PVT.updateR12UpgradeJob(p_job_status);

Line: 384

      ROLLBACK TO updateR12UpgradeJob_sp;

Line: 397

END updateR12UpgradeJob;