APPS.IGS_UC_RELEASE_TRANS_PKG SQL Statements

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

Line: 40

  l_last_update_date           DATE ;

Line: 41

  l_last_updated_by            NUMBER;

Line: 42

  l_last_update_login          NUMBER;

Line: 45

  l_update_stmt                VARCHAR2(2500);

Line: 46

  l_updated_rows               NUMBER;

Line: 86

    l_last_update_date := SYSDATE;

Line: 87

    l_last_updated_by := fnd_global.user_id;

Line: 88

    IF l_last_updated_by IS NULL THEN
        l_last_updated_by := -1;

Line: 91

    l_last_update_login := fnd_global.login_id;

Line: 92

    IF l_last_update_login IS NULL THEN
        l_last_update_login := -1;

Line: 103

    fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');

Line: 104

    fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');

Line: 105

    fnd_dsql.add_bind(l_last_update_date);

Line: 106

    fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');

Line: 107

    fnd_dsql.add_bind(l_last_updated_by);

Line: 108

    fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_LOGIN = ');

Line: 109

    fnd_dsql.add_bind(l_last_update_login);

Line: 118

        fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_PS_VER PSVER, IGS_UC_APP_CHOICES APPCH WHERE APPCH.APP_NO = UCTRANS.APP_NO AND ');

Line: 127

        fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND  UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

Line: 135

        fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND  UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

Line: 143

        fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND  UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

Line: 151

        fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND  UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

Line: 159

        fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND  UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

Line: 202

    l_update_stmt := fnd_dsql.get_text(FALSE);

Line: 206

        fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.update_dml', l_update_stmt);

Line: 212

    DBMS_SQL.parse(l_cursor_id, l_update_stmt, dbms_sql.native);

Line: 215

    l_updated_rows := dbms_sql.EXECUTE(l_cursor_id);

Line: 221

    IF (l_updated_rows > 0) THEN
        --show the number of records successfully processed
        fnd_message.set_name('IGS','IGS_UC_REC_CNT_SUCCESS_PROC');

Line: 224

        fnd_message.set_token('REC_CNT',l_updated_rows);

Line: 229

        fnd_message.set_token('REC_CNT',l_updated_rows);