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.JTF_TASK_DATES_PVT SQL Statements

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

Line: 44


            SELECT 1
              FROM jtf_task_dates
             WHERE ROWID = l_rowid;

Line: 67


        SELECT jtf_task_dates_s.nextval
          INTO l_task_date_id
          FROM dual;

Line: 72


        jtf_task_dates_pkg.insert_row (
            x_rowid => l_rowid,
            x_task_date_id => l_task_date_id,
            x_task_id => p_task_id,
            x_date_type_id => p_date_type_id,
            x_date_value => p_date_value,
            x_attribute1 => p_attribute1 ,
            x_attribute2 => p_attribute2 ,
            x_attribute3 => p_attribute3 ,
            x_attribute4 => p_attribute4 ,
            x_attribute5 => p_attribute5 ,
            x_attribute6 => p_attribute6 ,
            x_attribute7 => p_attribute7 ,
            x_attribute8 => p_attribute8 ,
            x_attribute9 => p_attribute9 ,
            x_attribute10 => p_attribute10 ,
            x_attribute11 => p_attribute11 ,
            x_attribute12 => p_attribute12 ,
            x_attribute13 => p_attribute13 ,
            x_attribute14 => p_attribute14 ,
            x_attribute15 => p_attribute15,
            x_attribute_category => p_attribute_category ,
            x_creation_date => SYSDATE,
            x_created_by => jtf_task_utl.created_by,
            x_last_update_date => SYSDATE,
            x_last_updated_by => jtf_task_utl.updated_by,
            x_last_update_login => jtf_task_utl.login_id
        );

Line: 136


    PROCEDURE update_task_dates (
        p_api_version             IN       NUMBER,
        p_init_msg_list           IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_commit                  IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_object_version_number   IN   OUT NOCOPY NUMBER,
        p_task_date_id            IN       NUMBER,
--        p_task_id                 IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_date_type_id            IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_date_value              IN       DATE DEFAULT fnd_api.g_miss_date,
        x_return_status           OUT NOCOPY      VARCHAR2,
        x_msg_count               OUT NOCOPY      NUMBER,
        x_msg_data                OUT NOCOPY      VARCHAR2,
        p_attribute1              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute2              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute3              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute4              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute5              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute6              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute7              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute8              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute9              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute10             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute11             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute12             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute13             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute14             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute15             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute_category      IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
    )
    IS
        l_api_version         CONSTANT NUMBER                                   := 1.0;

Line: 167


        l_api_name            CONSTANT VARCHAR2(30)                             := 'UPDATE_TASK_DATES';

Line: 173


        CURSOR c_update_task_dates
        IS
            SELECT task_id,
                   DECODE (p_date_type_id, fnd_api.g_miss_num, date_type_id, p_date_type_id) date_type_id,
                   DECODE (p_date_value, fnd_api.g_miss_date, date_value, p_date_value) date_value,
decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 )  attribute1  ,
decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 )  attribute2  ,
decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 )  attribute3  ,
decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 )  attribute4  ,
decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 )  attribute5  ,
decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 )  attribute6  ,
decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 )  attribute7  ,
decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 )  attribute8  ,
decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 )  attribute9  ,
decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 )  attribute10  ,
decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 )  attribute11  ,
decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 )  attribute12  ,
decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 )  attribute13  ,
decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 )  attribute14  ,
decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 )  attribute15 ,
decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
              FROM jtf_task_dates
             WHERE task_date_id = p_task_date_id;

Line: 197


        task_dates        c_update_task_dates%ROWTYPE;

Line: 200


        SAVEPOINT update_task_dates_pvt;

Line: 214


        OPEN c_update_task_dates;

Line: 215


        FETCH c_update_task_dates INTO task_dates;

Line: 217


        IF c_update_task_dates%NOTFOUND
        THEN
            fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE');

Line: 226


        CLOSE  c_update_task_dates;

Line: 263


        jtf_task_dates_pkg.update_row (
            x_task_date_id => l_task_date_id,
            x_object_version_number => p_object_version_number + 1,
            x_task_id => l_task_id,
            x_date_type_id => l_date_type_id,
            x_attribute1 => task_dates.attribute1 ,
            x_attribute2 => task_dates.attribute2 ,
            x_attribute3 => task_dates.attribute3 ,
            x_attribute4 => task_dates.attribute4 ,
            x_attribute5 => task_dates.attribute5 ,
            x_attribute6 => task_dates.attribute6 ,
            x_attribute7 => task_dates.attribute7 ,
            x_attribute8 => task_dates.attribute8 ,
            x_attribute9 => task_dates.attribute9 ,
            x_attribute10 => task_dates.attribute10 ,
            x_attribute11 => task_dates.attribute11 ,
            x_attribute12 => task_dates.attribute12 ,
            x_attribute13 => task_dates.attribute13 ,
            x_attribute14 => task_dates.attribute14 ,
            x_attribute15 => task_dates.attribute15 ,
            x_attribute_category => task_dates.attribute_category,
            x_date_value => l_date_value,
            x_last_update_date => SYSDATE,
            x_last_updated_by => jtf_task_utl.updated_by,
            x_last_update_login => jtf_task_utl.login_id
        );

Line: 308


            ROLLBACK TO update_task_dates_pvt;

Line: 313


            ROLLBACK TO update_task_dates_pvt;

Line: 321


    PROCEDURE delete_task_dates (
        p_api_version             IN       NUMBER,
        p_init_msg_list           IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_commit                  IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_object_version_number   IN  NUMBER,
        p_task_date_id            IN       NUMBER,
        x_return_status           OUT NOCOPY      VARCHAR2,
        x_msg_count               OUT NOCOPY      NUMBER,
        x_msg_data                OUT NOCOPY      VARCHAR2
    )
    IS
        l_api_version    CONSTANT NUMBER       := 1.0;

Line: 333


        l_api_name       CONSTANT VARCHAR2(30) := 'DELETE_TASK_DATES';

Line: 339


        SAVEPOINT delete_task_dates_pvt;

Line: 374


        jtf_task_dates_pkg.delete_row (x_task_date_id => p_task_date_id);

Line: 385


            ROLLBACK TO delete_task_dates_pvt;

Line: 390


            ROLLBACK TO delete_task_dates_pvt;