DBA Data[Home] [Help]

APPS.WSM_WIP_LOT_TXN_PVT SQL Statements

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

Line: 81

                l_message_tbl.delete;
Line: 158

                        l_message_tbl.delete;
Line: 273

                        l_message_tbl.delete;
Line: 309

                        l_message_tbl(l_message_tbl.count+1) := 'Split has update assy ['        || p_resulting_jobs_tbl(l_index).split_has_update_assy           || '] ' ;
Line: 386

                        l_message_tbl.delete;
Line: 553

                l_msg_tokens.delete;
Line: 589

                        l_msg_tokens.delete;
Line: 605

                                l_msg_tokens.delete;
Line: 624

                                l_msg_tokens.delete;
Line: 641

                        l_msg_tokens.delete;
Line: 669

                        l_msg_tokens.delete;
Line: 698

                                l_msg_tokens.delete;
Line: 716

                                l_msg_tokens.delete;
Line: 754

                                l_msg_tokens.delete;
Line: 776

        /* Is it Update Assembly ?? If yes, go ahead */
        elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_ASSEMBLY then

                if l_starting_jobs_tbl.count <> 1 then
                        /* error out... */
                        IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

                                l_msg_tokens.delete;
Line: 801

                                l_msg_tokens.delete;
Line: 815

                UPDATE_ASSEMBLY_TXN (   p_api_version                           => 1.0,
                                        p_commit                                => FND_API.G_FALSE,
                                        p_init_msg_list                         => FND_API.G_TRUE,
                                        p_validation_level                      => 0,
                                        p_calling_mode                          => p_calling_mode,
                                        p_wltx_header                           => l_txn_header_rec,
                                        p_wltx_starting_job_rec                 => l_starting_jobs_tbl(l_starting_jobs_tbl.first),
                                        p_wltx_resulting_job_rec                => l_resulting_jobs_tbl(l_resulting_jobs_tbl.first),
                                        p_wltx_secondary_qty_tbl                => l_secondary_qty_tbl,
                                        x_return_status                         => x_return_status,
                                        x_msg_count                             => x_msg_count,
                                        x_msg_data                              => x_error_msg
                                        );
Line: 837

                                                l_msg_tokens.delete;
Line: 839

                                                                       p_msg_text           => 'Update Assembly Txn procedure failed.'          ,
                                                                       p_stmt_num           => l_stmt_num               ,
                                                                       p_msg_tokens         => l_msg_tokens,
                                                                       p_fnd_msg_level      => G_MSG_LVL_ERROR          ,
                                                                       p_fnd_log_level      => G_LOG_LEVEL_ERROR        ,
                                                                       p_run_log_level      => l_log_level
                                                                      );
Line: 858

        /* Is it Update Routing ?? If yes, go ahead */
        elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_ROUTING then

                if l_starting_jobs_tbl.count <> 1 then
                        /* error out... */
                        IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

                                l_msg_tokens.delete;
Line: 883

                                l_msg_tokens.delete;
Line: 897

                UPDATE_ROUTING_TXN(     p_api_version                           => 1.0,
                                        p_commit                                => FND_API.G_FALSE,
                                        p_init_msg_list                         => FND_API.G_TRUE,
                                        p_validation_level                      => 0,
                                         p_calling_mode                         => p_calling_mode,
                                        p_wltx_header                           => l_txn_header_rec,
                                        p_wltx_starting_job_rec                 => l_starting_jobs_tbl(l_starting_jobs_tbl.first),
                                        p_wltx_resulting_job_rec                => l_resulting_jobs_tbl(l_resulting_jobs_tbl.first),
                                        p_wltx_secondary_qty_tbl                => l_secondary_qty_tbl,
                                        x_return_status                         => x_return_status,
                                        x_msg_count                             => x_msg_count,
                                        x_msg_data                              => x_error_msg
                                  );
Line: 916

                                                l_msg_tokens.delete;
Line: 918

                                                                       p_msg_text           => 'Update Routing Txn procedure failed.',
                                                                       p_stmt_num           => l_stmt_num               ,
                                                                       p_msg_tokens         => l_msg_tokens,
                                                                       p_fnd_msg_level      => G_MSG_LVL_ERROR          ,
                                                                       p_fnd_log_level      => G_LOG_LEVEL_ERROR        ,
                                                                       p_run_log_level      => l_log_level
                                                                      );
Line: 938

        /* Is it Update Qty ?? If yes, go ahead */
        elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_QUANTITY then

                if l_starting_jobs_tbl.count <> 1 then
                        /* error out... */
                        IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

                                l_msg_tokens.delete;
Line: 963

                                l_msg_tokens.delete;
Line: 977

                UPDATE_QUANTITY_TXN(    p_api_version                           => 1.0,
                                        p_commit                                => FND_API.G_FALSE,
                                        p_init_msg_list                         => FND_API.G_TRUE,
                                        p_validation_level                      => 0,
                                        p_calling_mode                          => p_calling_mode,
                                        p_wltx_header                           => l_txn_header_rec,
                                        p_wltx_starting_job_rec                 => l_starting_jobs_tbl(l_starting_jobs_tbl.first),
                                        p_wltx_resulting_job_rec                => l_resulting_jobs_tbl(l_resulting_jobs_tbl.first),
                                        p_wltx_secondary_qty_tbl                => l_secondary_qty_tbl,
                                        x_return_status                         => x_return_status,
                                        x_msg_count                             => x_msg_count,
                                        x_msg_data                              => x_error_msg
                                                       );
Line: 997

                                                l_msg_tokens.delete;
Line: 1000

                                                                       p_msg_text           => 'Update Quantity Txn procedure failed.',
                                                                       p_stmt_num           => l_stmt_num               ,
                                                                       p_msg_tokens         => l_msg_tokens,
                                                                       p_fnd_msg_level      => G_MSG_LVL_ERROR          ,
                                                                       p_fnd_log_level      => G_LOG_LEVEL_STATEMENT        ,
                                                                       p_run_log_level      => l_log_level
                                                                      );
Line: 1019

        /* Is it Update Lot Name ?? If yes, go ahead */
        elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_LOT_NAME then

                if l_starting_jobs_tbl.count <> 1 then
                        /* error out... */
                        IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

                                l_msg_tokens.delete;
Line: 1044

                                l_msg_tokens.delete;
Line: 1058

                UPDATE_LOTNAME_TXN(  p_api_version                      => 1.0,
                                 p_commit                               => FND_API.G_FALSE,
                                 p_init_msg_list                        => FND_API.G_TRUE,
                                 p_validation_level                     => 0,
                                 p_calling_mode                         => p_calling_mode,
                                 p_wltx_header                          => l_txn_header_rec,
                                 p_wltx_starting_job_rec                => l_starting_jobs_tbl(l_starting_jobs_tbl.first),
                                 p_wltx_resulting_job_rec               => l_resulting_jobs_tbl(l_resulting_jobs_tbl.first),
                                 p_wltx_secondary_qty_tbl               => l_secondary_qty_tbl,
                                 x_return_status                        => x_return_status,
                                 x_msg_count                            => x_msg_count,
                                 x_msg_data                             => x_error_msg
                              );
Line: 1078

                                                l_msg_tokens.delete;
Line: 1080

                                                                       p_msg_text           => 'Update Lot Name Txn procedure failed.',
                                                                       p_stmt_num           => l_stmt_num               ,
                                                                       p_msg_tokens         => l_msg_tokens,
                                                                       p_fnd_msg_level      => G_MSG_LVL_ERROR          ,
                                                                       p_fnd_log_level      => G_LOG_LEVEL_ERROR        ,
                                                                       p_run_log_level      => l_log_level
                                                                      );
Line: 1107

                                l_msg_tokens.delete;
Line: 1140

                                                l_msg_tokens.delete;
Line: 1171

                WSM_WLT_VALIDATE_PVT.insert_txn_data (   p_transaction_id               => l_txn_header_rec.transaction_id,
                                                         p_wltx_header                  => l_txn_header_rec,
                                                         p_wltx_starting_jobs_tbl       => l_starting_jobs_tbl,
                                                         p_wltx_resulting_jobs_tbl      => l_resulting_jobs_tbl,
                                                         x_return_status                => x_return_status,
                                                         x_msg_count                    => x_msg_count,
                                                         x_msg_data                     => x_error_msg
                                                      );
Line: 1184

                                l_msg_tokens.delete;
Line: 1186

                                                       p_msg_text           => 'WSM_WLT_VALIDATE_PVT.insert_txn_data failed',
                                                       p_stmt_num           => l_stmt_num               ,
                                                       p_msg_tokens         => l_msg_tokens,
                                                       p_fnd_msg_level      => G_MSG_LVL_ERROR          ,
                                                       p_fnd_log_level      => G_LOG_LEVEL_ERROR        ,
                                                       p_run_log_level      => l_log_level
                                                      );
Line: 1203

                        update wsm_sm_resulting_jobs
                        set    wip_entity_id = l_resulting_jobs_tbl(l_index).wip_entity_id,
                               job_operation_seq_num = l_resulting_jobs_tbl(l_index).job_operation_seq_num
                        where  transaction_id = l_txn_header_rec.transaction_id
                        and    wip_entity_name = l_resulting_jobs_tbl(l_index).wip_entity_name;
Line: 1236

                l_msg_tokens.delete;
Line: 1283

                l_msg_tokens.delete;
Line: 1381

                l_msg_tokens.delete;
Line: 1411

                                l_msg_tokens.delete;
Line: 1427

                l_msg_tokens.delete;
Line: 1445

                l_msg_tokens.delete;
Line: 1465

                l_msg_tokens.delete;
Line: 1479

                                        l_msg_tokens.delete;
Line: 1500

                l_msg_tokens.delete;
Line: 1516

                l_msg_tokens.delete;
Line: 1538

                l_msg_tokens.delete;
Line: 1553

                                        l_msg_tokens.delete;
Line: 1574

                l_msg_tokens.delete;
Line: 1588

                l_msg_tokens.delete;
Line: 1611

                l_msg_tokens.delete;
Line: 1625

                                        l_msg_tokens.delete;
Line: 1646

                l_msg_tokens.delete;
Line: 1663

                l_msg_tokens.delete;
Line: 1690

                l_msg_tokens.delete;
Line: 1704

                                        l_msg_tokens.delete;
Line: 1728

                l_msg_tokens.delete;
Line: 1747

                        l_msg_tokens.delete;
Line: 1864

                l_msg_tokens.delete;
Line: 1900

                                l_msg_tokens.delete;
Line: 1923

                l_msg_tokens.delete;
Line: 1941

                l_msg_tokens.delete;
Line: 1955

                                        l_msg_tokens.delete;
Line: 1976

                l_msg_tokens.delete;
Line: 1991

                l_msg_tokens.delete;
Line: 2018

                l_msg_tokens.delete;
Line: 2032

                                        l_msg_tokens.delete;
Line: 2053

                l_msg_tokens.delete;
Line: 2067

                l_msg_tokens.delete;
Line: 2096

                l_msg_tokens.delete;
Line: 2110

                                        l_msg_tokens.delete;
Line: 2131

                l_msg_tokens.delete;
Line: 2154

                l_msg_tokens.delete;
Line: 2180

                l_msg_tokens.delete;
Line: 2194

                                        l_msg_tokens.delete;
Line: 2218

                l_msg_tokens.delete;
Line: 2236

                        l_msg_tokens.delete;
Line: 2294

/* API for Update Assembly transaction.... */
Procedure UPDATE_ASSEMBLY_TXN (         p_api_version                           IN              NUMBER,
                                        p_commit                                IN              VARCHAR2        DEFAULT NULL,
                                        p_init_msg_list                         IN              VARCHAR2        DEFAULT NULL,
                                        p_validation_level                      IN              NUMBER          DEFAULT NULL,
                                        p_calling_mode                          IN              NUMBER,
                                        p_wltx_header                           IN OUT  NOCOPY  WLTX_TRANSACTIONS_REC_TYPE,
                                        p_wltx_starting_job_rec                 IN OUT  NOCOPY  WLTX_STARTING_JOBS_REC_TYPE,
                                        p_wltx_resulting_job_rec                IN OUT  NOCOPY  WLTX_RESULTING_JOBS_REC_TYPE,
                                        p_wltx_secondary_qty_tbl                IN OUT  NOCOPY  WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
                                        x_return_status                         OUT     NOCOPY  VARCHAR2,
                                        x_msg_count                             OUT     NOCOPY  NUMBER,
                                        x_msg_data                              OUT     NOCOPY  VARCHAR2
                                     )  IS

     /* API version stored locally */
     l_api_version    NUMBER := 1.0;
Line: 2311

     l_api_name       VARCHAR2(20) := 'UPDATE_ASSEMBLY_TXN';
Line: 2322

    l_module            VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.UPDATE_ASSEMBLY_TXN';
Line: 2383

                                l_msg_tokens.delete;
Line: 2412

                l_msg_tokens.delete;
Line: 2431

                l_msg_tokens.delete;
Line: 2445

                                        l_msg_tokens.delete;
Line: 2466

                l_msg_tokens.delete;
Line: 2481

                l_msg_tokens.delete;
Line: 2503

                l_msg_tokens.delete;
Line: 2517

                                        l_msg_tokens.delete;
Line: 2538

                l_msg_tokens.delete;
Line: 2552

                l_msg_tokens.delete;
Line: 2576

                l_msg_tokens.delete;
Line: 2590

                        l_msg_tokens.delete;
Line: 2611

                l_msg_tokens.delete;
Line: 2626

                l_msg_tokens.delete;
Line: 2654

                l_msg_tokens.delete;
Line: 2668

                                        l_msg_tokens.delete;
Line: 2693

                l_msg_tokens.delete;
Line: 2711

                        l_msg_tokens.delete;
Line: 2733

                fnd_file.put_line(fnd_file.log,' WSM_WIP_LOT_TXN_PVT.update_assembly_txn : ' || l_stmt_num ||  ' Error : ');
Line: 2745

                fnd_file.put_line(fnd_file.log,' WSM_WIP_LOT_TXN_PVT.update_assembly_txn : ' || l_stmt_num ||  ' Un Exp Error : ');
Line: 2766

                fnd_file.put_line(fnd_file.log,' WSM_WIP_LOT_TXN_PVT.update_assembly_txn : ' || l_stmt_num ||  ' Other Error : ');
Line: 2769

/* API for Update Routing transaction.... */
Procedure UPDATE_ROUTING_TXN (  p_api_version                           IN              NUMBER,
                                p_commit                                IN              VARCHAR2        DEFAULT NULL,
                                p_init_msg_list                         IN              VARCHAR2        DEFAULT NULL,
                                p_validation_level                      IN              NUMBER          DEFAULT NULL,
                                p_calling_mode                          IN              NUMBER,
                                p_wltx_header                           IN OUT  NOCOPY  WLTX_TRANSACTIONS_REC_TYPE,
                                p_wltx_starting_job_rec                 IN OUT  NOCOPY  WLTX_STARTING_JOBS_REC_TYPE,
                                p_wltx_resulting_job_rec                IN OUT  NOCOPY  WLTX_RESULTING_JOBS_REC_TYPE,
                                p_wltx_secondary_qty_tbl                IN OUT  NOCOPY  WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
                                x_return_status                         OUT     NOCOPY  VARCHAR2,
                                x_msg_count                             OUT     NOCOPY  NUMBER,
                                x_msg_data                              OUT     NOCOPY  VARCHAR2
                                ) IS


     /* API version stored locally */
     l_api_version    NUMBER := 1.0;
Line: 2787

     l_api_name       VARCHAR2(20) := 'UPDATE_ROUTING_TXN';
Line: 2798

    l_module            VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.UPDATE_ROUTING_TXN';
Line: 2860

                l_msg_tokens.delete;
Line: 2888

                l_msg_tokens.delete;
Line: 2907

                l_msg_tokens.delete;
Line: 2921

                                        l_msg_tokens.delete;
Line: 2942

                l_msg_tokens.delete;
Line: 2957

                l_msg_tokens.delete;
Line: 2979

                l_msg_tokens.delete;
Line: 2993

                        l_msg_tokens.delete;
Line: 3014

                l_msg_tokens.delete;
Line: 3028

                l_msg_tokens.delete;
Line: 3052

                l_msg_tokens.delete;
Line: 3068

                                        l_msg_tokens.delete;
Line: 3089

                l_msg_tokens.delete;
Line: 3105

                l_msg_tokens.delete;
Line: 3133

                l_msg_tokens.delete;
Line: 3147

                                l_msg_tokens.delete;
Line: 3172

                l_msg_tokens.delete;
Line: 3189

                        l_msg_tokens.delete;
Line: 3243

/* API for Update Quantity transaction.... */
Procedure UPDATE_QUANTITY_TXN ( p_api_version                           IN              NUMBER,
                                p_commit                                IN              VARCHAR2        DEFAULT NULL,
                                p_init_msg_list                         IN              VARCHAR2        DEFAULT NULL,
                                p_validation_level                      IN              NUMBER          DEFAULT NULL,
                                p_calling_mode                          IN              NUMBER,
                                p_wltx_header                           IN OUT  NOCOPY  WLTX_TRANSACTIONS_REC_TYPE,
                                p_wltx_starting_job_rec                 IN OUT  NOCOPY  WLTX_STARTING_JOBS_REC_TYPE,
                                p_wltx_resulting_job_rec                IN OUT  NOCOPY  WLTX_RESULTING_JOBS_REC_TYPE,
                                p_wltx_secondary_qty_tbl                IN OUT  NOCOPY  WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
                                x_return_status                         OUT     NOCOPY  VARCHAR2,
                                x_msg_count                             OUT     NOCOPY  NUMBER,
                                x_msg_data                              OUT     NOCOPY  VARCHAR2
                                )  IS
/* API version stored locally */
     l_api_version    NUMBER := 1.0;
Line: 3259

     l_api_name       VARCHAR2(20) := 'UPDATE_QUANTITY_TXN';
Line: 3271

    l_module            VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.UPDATE_QUANTITY_TXN';
Line: 3332

                                l_msg_tokens.delete;
Line: 3362

                l_msg_tokens.delete;
Line: 3381

                l_msg_tokens.delete;
Line: 3395

                                        l_msg_tokens.delete;
Line: 3416

                l_msg_tokens.delete;
Line: 3431

                l_msg_tokens.delete;
Line: 3453

                l_msg_tokens.delete;
Line: 3467

                                        l_msg_tokens.delete;
Line: 3488

                l_msg_tokens.delete;
Line: 3502

                l_msg_tokens.delete;
Line: 3526

                l_msg_tokens.delete;
Line: 3540

                                        l_msg_tokens.delete;
Line: 3562

                l_msg_tokens.delete;
Line: 3580

                l_msg_tokens.delete;
Line: 3608

                l_msg_tokens.delete;
Line: 3622

                                l_msg_tokens.delete;
Line: 3647

                l_msg_tokens.delete;
Line: 3664

                        l_msg_tokens.delete;
Line: 3720

/* API for Update Lot name transaction.... */
Procedure UPDATE_LOTNAME_TXN (  p_api_version                           IN              NUMBER,
                                p_commit                                IN              VARCHAR2        DEFAULT NULL,
                                p_init_msg_list                         IN              VARCHAR2        DEFAULT NULL,
                                p_validation_level                      IN              NUMBER          DEFAULT NULL,
                                p_calling_mode                          IN              NUMBER,
                                p_wltx_header                           IN OUT  NOCOPY  WLTX_TRANSACTIONS_REC_TYPE,
                                p_wltx_starting_job_rec                 IN OUT  NOCOPY  WLTX_STARTING_JOBS_REC_TYPE,
                                p_wltx_resulting_job_rec                IN OUT  NOCOPY  WLTX_RESULTING_JOBS_REC_TYPE,
                                p_wltx_secondary_qty_tbl                IN OUT  NOCOPY  WSM_JOB_SECONDARY_QTY_TBL_TYPE ,
                                x_return_status                         OUT     NOCOPY  VARCHAR2,
                                x_msg_count                             OUT     NOCOPY  NUMBER,
                                x_msg_data                              OUT     NOCOPY  VARCHAR2
                            )  IS
     /* API version stored locally */
     l_api_version    NUMBER := 1.0;
Line: 3736

     l_api_name       VARCHAR2(20) := 'UPDATE_LOTNAME_TXN';
Line: 3747

    l_module            VARCHAR2(100) :='wsm.plsql.WSM_WIP_LOT_TXN_PVT.UPDATE_LOTNAME_TXN';
Line: 3767

                l_msg_tokens.delete;
Line: 3769

                                       p_msg_text           =>  'Entering the Update Lotname Txn API',
                                       p_stmt_num           => l_stmt_num               ,
                                        p_msg_tokens        => l_msg_tokens,
                                       p_fnd_log_level      => g_log_level_statement,
                                       p_run_log_level      => l_log_level
                                      );
Line: 3786

                l_msg_tokens.delete;
Line: 3809

                                l_msg_tokens.delete;
Line: 3832

                l_msg_tokens.delete;
Line: 3851

                l_msg_tokens.delete;
Line: 3865

                                        l_msg_tokens.delete;
Line: 3886

                l_msg_tokens.delete;
Line: 3901

                l_msg_tokens.delete;
Line: 3923

                l_msg_tokens.delete;
Line: 3937

                                        l_msg_tokens.delete;
Line: 3958

                l_msg_tokens.delete;
Line: 3972

                l_msg_tokens.delete;
Line: 3996

                l_msg_tokens.delete;
Line: 4010

                                        l_msg_tokens.delete;
Line: 4031

                l_msg_tokens.delete;
Line: 4051

                l_msg_tokens.delete;
Line: 4079

                l_msg_tokens.delete;
Line: 4093

                                        l_msg_tokens.delete;
Line: 4118

                l_msg_tokens.delete;
Line: 4135

                        l_msg_tokens.delete;
Line: 4238

                l_msg_tokens.delete;
Line: 4269

                                l_msg_tokens.delete;
Line: 4292

                l_msg_tokens.delete;
Line: 4311

                l_msg_tokens.delete;
Line: 4325

                                        l_msg_tokens.delete;
Line: 4346

                l_msg_tokens.delete;
Line: 4360

                l_msg_tokens.delete;
Line: 4383

                l_msg_tokens.delete;
Line: 4397

                                        l_msg_tokens.delete;
Line: 4418

                l_msg_tokens.delete;
Line: 4437

                l_msg_tokens.delete;
Line: 4464

                l_msg_tokens.delete;
Line: 4478

                                        l_msg_tokens.delete;
Line: 4503

                l_msg_tokens.delete;
Line: 4520

                        l_msg_tokens.delete;
Line: 4575

PROCEDURE UPDATE_BOM     (      p_api_version                           IN              VARCHAR2,
                                p_commit                                IN              VARCHAR2        DEFAULT NULL,
                                p_init_msg_list                         IN              VARCHAR2        DEFAULT NULL,
                                p_validation_level                      IN              NUMBER          DEFAULT NULL,
                                p_wltx_header                           IN OUT  NOCOPY  WLTX_TRANSACTIONS_REC_TYPE,
                                p_wltx_starting_job_rec                 IN OUT  NOCOPY  WLTX_STARTING_JOBS_REC_TYPE,
                                p_wltx_resulting_job_rec                IN OUT  NOCOPY  WLTX_RESULTING_JOBS_REC_TYPE,
                                x_return_status                         OUT     NOCOPY  VARCHAR2,
                                x_msg_count                             OUT     NOCOPY  NUMBER,
                                x_msg_data                              OUT     NOCOPY  VARCHAR2
                               )  IS

BEGIN

  null;
Line: 4593

PROCEDURE UPDATE_STATUS     (   p_api_version                           IN              VARCHAR2,
                                p_commit                                IN              VARCHAR2        DEFAULT NULL,
                                p_init_msg_list                         IN              VARCHAR2        DEFAULT NULL,
                                p_validation_level                      IN              NUMBER          DEFAULT NULL,
                                p_wltx_header                           IN OUT  NOCOPY  WLTX_TRANSACTIONS_REC_TYPE,
                                p_wltx_starting_job_rec                 IN OUT  NOCOPY  WLTX_STARTING_JOBS_REC_TYPE,
                                p_wltx_resulting_job_rec                IN OUT  NOCOPY  WLTX_RESULTING_JOBS_REC_TYPE,
                                x_return_status                         OUT     NOCOPY  VARCHAR2,
                                x_msg_count                             OUT     NOCOPY  NUMBER,
                                x_msg_data                              OUT     NOCOPY  VARCHAR2
                               )  IS

BEGIN

  null;
Line: 4612

PROCEDURE UPDATE_COMP_SUBINV_LOC(       p_api_version                           IN              VARCHAR2,
                                        p_commit                                IN              VARCHAR2        DEFAULT NULL,
                                        p_init_msg_list                         IN              VARCHAR2        DEFAULT NULL,
                                        p_validation_level                      IN              NUMBER          DEFAULT NULL,
                                        p_wltx_header                           IN OUT  NOCOPY  WLTX_TRANSACTIONS_REC_TYPE,
                                        p_wltx_starting_job_rec                 IN OUT  NOCOPY  WLTX_STARTING_JOBS_REC_TYPE,
                                        p_wltx_resulting_job_rec                IN OUT  NOCOPY  WLTX_RESULTING_JOBS_REC_TYPE,
                                        x_return_status                         OUT     NOCOPY  VARCHAR2,
                                        x_msg_count                             OUT     NOCOPY  NUMBER,
                                        x_msg_data                              OUT     NOCOPY  VARCHAR2
                                )   IS

BEGIN

  null;