APPS.AHL_PC_APPROVAL_PVT SQL Statements

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

Line: 32

                select PC_HEADER_ID, name
                from AHL_pc_headers_b
                where PC_HEADER_ID = c_pc_header_id;

Line: 326

                select PC_HEADER_ID,Name
                from AHL_PC_headers_b
                where PC_HEADER_ID=c_pc_header_id;

Line: 456

                select PC_HEADER_ID,Name
                from AHL_PC_headers_b
                where PC_HEADER_ID=c_pc_header_id;

Line: 583

                select PC_HEADER_ID,Name
                from AHL_PC_headers_b
                where PC_HEADER_ID=c_pc_header_id;

Line: 704

                select PC_HEADER_ID,Name
                from AHL_PC_headers_b
                where PC_HEADER_ID=c_pc_header_id;

Line: 834

                select PC_HEADER_ID,Name
                from AHL_PC_headers_b
                where PC_HEADER_ID=c_pc_header_id;

Line: 973

                select PC_HEADER_ID,Name
                from AHL_PC_headers_b
                where PC_HEADER_ID=c_pc_header_id;

Line: 1108

                select PC_HEADER_ID,Name
                from AHL_PC_headers_b
                where PC_HEADER_ID=c_pc_header_id;

Line: 1154

                UPDATE AHL_PC_HEADERS_B
                SET STATUS='INVALID'
                WHERE PC_HEADER_ID=l_object_id;

Line: 1222

        PROCEDURE UPDATE_STATUS
        (
                 itemtype    IN       VARCHAR2
                ,itemkey     IN       VARCHAR2
                ,actid       IN       NUMBER
                ,funcmode    IN       VARCHAR2
                ,resultout   OUT    NOCOPY  VARCHAR2
        )
        IS

        l_error_msg                     VARCHAR2(4000);

Line: 1261

                SELECT *
                FROM AHL_PC_HEADERS_VL
                WHERE PC_HEADER_ID = c_pc_header_id;

Line: 1282

                                ,aname    => 'UPDATE_GEN_STATUS'
                        );

Line: 1285

                          AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_approval_status='||l_approval_status);

Line: 1306

                  AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status='||l_next_status);

Line: 1320

                         AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number='||l_object_version_number);

Line: 1345

                         AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id='||l_object_id);

Line: 1346

                         AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_msg='||l_bue_msg);

Line: 1347

                         AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_flag='||l_bue_flag);

Line: 1394

                                AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
                                (
                                        p_api_version           => 1.0,
                                        p_init_msg_list         => FND_API.G_FALSE,
                                        p_commit                => FND_API.G_TRUE,
                                        p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
                                        p_x_pc_header_rec       => l_pc_header_rec,
                                        x_return_status         => x_return_status,
                                        x_msg_count             => x_msg_count,
                                        x_msg_data              => x_msg_data,
                                        x_warning_msg_data      => x_warning_msg_data
                                );

Line: 1407

                                 AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed AHL_PC_HEADER_PVT.UPDATE_PC_HEADER');

Line: 1462

                                'UPDATE_STATUS',
                                itemtype,
                                itemkey,
                                actid,
                                funcmode,
                                l_error_msg
                        );

Line: 1474

                                'UPDATE_STATUS',
                                itemtype,
                                itemkey,
                                actid,
                                funcmode,
                                l_error_msg
                        );

Line: 1483

        END UPDATE_STATUS;

Line: 1507

                select PC_HEADER_ID,Name
                from AHL_PC_headers_b
                where PC_HEADER_ID=c_pc_header_id;

Line: 1532

                         AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status'||l_next_status);

Line: 1542

                                AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number'||l_object_version_number);

Line: 1552

                         AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id'||l_object_id);

Line: 1557

                        UPDATE AHL_PC_HEADERS_B
                        SET STATUS = 'DRAFT',
                            OBJECT_VERSION_NUMBER = l_object_version_number + 1
                        WHERE PC_HEADER_ID = l_object_id AND
                              OBJECT_VERSION_NUMBER = l_object_version_number;

Line: 1564

                         AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed reset of status');