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_PUB SQL Statements

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

Line: 49


            SELECT 1
              FROM jtf_task_dates
             WHERE ROWID = l_rowid;

Line: 233


    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_date_type_name          IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        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: 264


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

Line: 271


        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: 295


        task_dates                c_update_task_dates%ROWTYPE;

Line: 298


        SAVEPOINT update_task_dates_pub;

Line: 313


        OPEN c_update_task_dates;

Line: 314


        FETCH c_update_task_dates INTO task_dates;

Line: 316


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

Line: 325


        CLOSE c_update_task_dates;

Line: 334


            SELECT DECODE (p_date_type_id, fnd_api.g_miss_num, NULL, p_date_type_id)
              INTO l_date_type_id
              FROM dual;

Line: 337


            SELECT DECODE (p_date_type_name, fnd_api.g_miss_char, NULL, p_date_type_name)
              INTO l_date_type_name
              FROM dual;

Line: 398


        jtf_task_dates_pvt.update_task_dates (
            p_api_version => 1.0,
            p_init_msg_list => fnd_api.g_false,
            p_commit => fnd_api.g_false,
            p_object_version_number => p_object_version_number ,
            p_task_date_id => l_task_date_id,
            p_date_type_id => l_date_type_id,
            p_date_value => l_date_value,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count,
            x_msg_data => x_msg_data,
            p_attribute1 => task_dates.attribute1 ,
            p_attribute2 => task_dates.attribute2 ,
            p_attribute3 => task_dates.attribute3 ,
            p_attribute4 => task_dates.attribute4 ,
            p_attribute5 => task_dates.attribute5 ,
            p_attribute6 => task_dates.attribute6 ,
            p_attribute7 => task_dates.attribute7 ,
            p_attribute8 => task_dates.attribute8 ,
            p_attribute9 => task_dates.attribute9 ,
            p_attribute10 => task_dates.attribute10 ,
            p_attribute11 => task_dates.attribute11 ,
            p_attribute12 => task_dates.attribute12 ,
            p_attribute13 => task_dates.attribute13 ,
            p_attribute14 => task_dates.attribute14 ,
            p_attribute15 => task_dates.attribute15 ,
            p_attribute_category => task_dates.attribute_category
        );

Line: 442


            rollback to update_task_dates_pub;

Line: 447


            rollback to update_task_dates_pub;

Line: 454


    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 DEFAULT NULL,
        x_return_status           OUT NOCOPY      VARCHAR2,
        x_msg_data                OUT NOCOPY      VARCHAR2,
        x_msg_count               OUT NOCOPY      NUMBER
    )
    IS
        l_api_version    CONSTANT NUMBER       := 1.0;

Line: 466


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

Line: 468


        SAVEPOINT delete_task_date_pub;

Line: 498


        jtf_task_dates_pvt.delete_task_dates (
            p_api_version => 1.0,
            p_init_msg_list => fnd_api.g_false,
            p_commit => fnd_api.g_false,
            p_object_version_number => p_object_version_number,
            p_task_date_id => p_task_date_id,
            x_return_status => x_return_status,
            x_msg_data => x_msg_data,
            x_msg_count => x_msg_count
        );

Line: 523


            ROLLBACK TO delete_task_date_pub;

Line: 528


            ROLLBACK TO delete_task_date_pub;

Line: 533


    END;   -- Delete Task Dates