APPS.AHL_UC_ACL_WF_APPR_PVT SQL Statements

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

Line: 9

        SELECT unit_config_header_id
              ,name
              ,object_version_number
              ,unit_config_status_code
              ,active_uc_status_code
        FROM ahl_unit_config_headers
        WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
          AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
          AND unit_config_header_id = c_uc_header_id;

Line: 1283

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


        CURSOR check_uc_ovn(c_uc_header_id in number, c_object_version_number in number)
        IS
        SELECT unit_config_header_id,
               name,
               unit_config_status_code,
               active_uc_status_code
        FROM ahl_unit_config_headers
        WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
            AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
            AND unit_config_header_id = c_uc_header_id
            AND object_version_number = c_object_version_number;

Line: 1324

               AHL_DEBUG_PUB.debug( 'UC-ACL:Start Update Status API');

Line: 1336

                         aname    => 'UPDATE_GEN_STATUS'
                );

Line: 1341

                   AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS -- l_approval_status='||l_approval_status);

Line: 1352

                   AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS --> l_object_version_number='||l_object_version_number);

Line: 1363

                   AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS --> l_object_id='||l_object_id);

Line: 1383

                          AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );

Line: 1400

                   AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);

Line: 1401

                   AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);

Line: 1402

                   AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);

Line: 1403

                   AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_quarantine_approval ');

Line: 1425

                    AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');

Line: 1429

                   AHL_DEBUG_PUB.debug( 'UC-ACL:End Update Status API, l_object_id =' || l_object_id );

Line: 1473

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

Line: 1485

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

Line: 1494

        END UPDATE_STATUS;

Line: 1521

        SELECT unit_config_header_id,
               name,
               unit_config_status_code,
               active_uc_status_code
         FROM ahl_unit_config_headers
        WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
          AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
          AND unit_config_header_id = c_uc_header_id
          AND object_version_number = c_object_version_number;

Line: 1602

                        UPDATE ahl_unit_config_headers
                           SET active_uc_status_code = l_next_status,
                               object_version_number = l_object_version_number + 1,
                               last_update_date = sysdate,
                               last_updated_by = to_number(fnd_global.login_id),
                               last_update_login = to_number(fnd_global.login_id)
                         WHERE unit_config_header_id = l_object_id;