eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_ATTR_MAP_PVT SQL Statements

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

Line: 48


    ELSIF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
    OR    l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE
    THEN

        l_PTE_rec.db_flag := FND_API.G_TRUE;

Line: 148


        IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

            QP_Validate_Pte.Entity_Delete
            (   x_return_status               => l_return_status
            ,   p_PTE_rec                     => l_PTE_rec
            );

Line: 177


        IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

            QP_Pte_Util.Delete_Row
            (   p_lookup_code                 => l_PTE_rec.lookup_code
            );

Line: 191


            IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                QP_Pte_Util.Update_Row (l_PTE_rec);

Line: 200


                QP_Pte_Util.Insert_Row (l_PTE_rec);

Line: 308


        ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_RQT_rec.db_flag := FND_API.G_TRUE;

Line: 409


            IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Rqt.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_RQT_rec                     => l_RQT_rec
                );

Line: 438


            IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Rqt_Util.Delete_Row
                (   p_request_type_code           => l_RQT_rec.request_type_code
                );

Line: 448


                l_RQT_rec.last_update_date     := SYSDATE;

Line: 449


                l_RQT_rec.last_updated_by      := FND_GLOBAL.USER_ID;

Line: 450


                l_RQT_rec.last_update_login    := FND_GLOBAL.LOGIN_ID;

Line: 452


                IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Rqt_Util.Update_Row (l_RQT_rec);

Line: 461


                    QP_Rqt_Util.Insert_Row (l_RQT_rec);

Line: 602


        ELSIF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_SSC_rec.db_flag := FND_API.G_TRUE;

Line: 702


            IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Ssc.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_SSC_rec                     => l_SSC_rec
                );

Line: 731


            IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Ssc_Util.Delete_Row
                (   p_pte_source_system_id        => l_SSC_rec.pte_source_system_id
                );

Line: 741


                l_SSC_rec.last_update_date     := SYSDATE;

Line: 742


                l_SSC_rec.last_updated_by      := FND_GLOBAL.USER_ID;

Line: 743


                l_SSC_rec.last_update_login    := FND_GLOBAL.LOGIN_ID;

Line: 745


                IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Ssc_Util.Update_Row (l_SSC_rec);

Line: 754


                    QP_Ssc_Util.Insert_Row (l_SSC_rec);

Line: 895


        ELSIF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_PSG_rec.db_flag := FND_API.G_TRUE;

Line: 995


            IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Psg.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_PSG_rec                     => l_PSG_rec
                );

Line: 1024


            IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Psg_Util.Delete_Row
                (   p_segment_pte_id              => l_PSG_rec.segment_pte_id
                );

Line: 1034


                l_PSG_rec.last_update_date     := SYSDATE;

Line: 1035


                l_PSG_rec.last_updated_by      := FND_GLOBAL.USER_ID;

Line: 1036


                l_PSG_rec.last_update_login    := FND_GLOBAL.LOGIN_ID;

Line: 1038


                IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Psg_Util.Update_Row (l_PSG_rec);

Line: 1047


                    QP_Psg_Util.Insert_Row (l_PSG_rec);

Line: 1188


        ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_SOU_rec.db_flag := FND_API.G_TRUE;

Line: 1289


            IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Sou.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_SOU_rec                     => l_SOU_rec
                );

Line: 1318


            IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Sou_Util.Delete_Row
                (   p_attribute_sourcing_id       => l_SOU_rec.attribute_sourcing_id
                );

Line: 1328


                l_SOU_rec.last_update_date     := SYSDATE;

Line: 1329


                l_SOU_rec.last_updated_by      := FND_GLOBAL.USER_ID;

Line: 1330


                l_SOU_rec.last_update_login    := FND_GLOBAL.LOGIN_ID;

Line: 1332


                IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Sou_Util.Update_Row (l_SOU_rec);

Line: 1341


                    QP_Sou_Util.Insert_Row (l_SOU_rec);

Line: 1482


        ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_FNA_rec.db_flag := FND_API.G_TRUE;

Line: 1581


            IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Fna.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_FNA_rec                     => l_FNA_rec
                );

Line: 1610


            IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Fna_Util.Delete_Row
                (   p_pte_sourcesystem_fnarea_id  => l_FNA_rec.pte_sourcesystem_fnarea_id
                );

Line: 1625


                  QP_Fna_Util.Warn_Disable_Delete_Fna
                    ( p_action             => 'DELETE'
                    , p_called_from_ui     => l_control_rec.called_from_ui
                    , p_functional_area_id => l_FNA_rec.functional_area_id
                    , p_pte_ss_id          => l_FNA_rec.pte_source_system_id
                    );

Line: 1637


                l_FNA_rec.last_update_date     := SYSDATE;

Line: 1638


                l_FNA_rec.last_updated_by      := FND_GLOBAL.USER_ID;

Line: 1639


                l_FNA_rec.last_update_login    := FND_GLOBAL.LOGIN_ID;

Line: 1641


                IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Fna_Util.Update_Row (l_FNA_rec);

Line: 1650


                    QP_Fna_Util.Insert_Row (l_FNA_rec);

Line: 1709


	   qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
	      p_entity_id => l_FNA_rec.pte_source_system_id,
	      x_return_status => l_return_status );

Line: 1721


	   qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
	      p_entity_id => l_FNA_rec.pte_source_system_id,
	      x_return_status => l_return_status );

Line: 1741


	   qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
	      p_entity_id => l_FNA_rec.pte_source_system_id,
	      x_return_status => l_return_status );

Line: 2817


        ,p_delete        => FND_API.G_TRUE
        ,x_return_status => x_return_status
        );