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

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

Line: 325


    PROCEDURE update_task_dependency (
        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_dependency_id           IN       NUMBER,
        p_task_id                 IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_dependent_on_task_id    IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_dependent_on_task_number IN      VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_dependency_type_code    IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_adjustment_time         IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_adjustment_time_uom     IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_validated_flag          IN       VARCHAR2 DEFAULT jtf_task_utl.g_no,
        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: 360


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

Line: 373


            SELECT
                   DECODE (p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id,
                   DECODE (p_dependent_on_task_id, fnd_api.g_miss_num, dependent_on_task_id, p_dependent_on_task_id) dependent_on_task_id,
                   DECODE (p_dependency_type_code, fnd_api.g_miss_char, dependency_type_code, p_dependency_type_code) dependency_type_code,
                   template_flag,
                   DECODE (p_adjustment_time, fnd_api.g_miss_num, adjustment_time, p_adjustment_time) adjustment_time,
                   DECODE (p_adjustment_time_uom, fnd_api.g_miss_char, adjustment_time_uom, p_adjustment_time_uom) adjustment_time_uom,
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_depends
             WHERE dependency_id = p_dependency_id;

Line: 402


        SAVEPOINT update_task_dependency_pub;

Line: 445


            SELECT DECODE (p_dependent_on_task_id, fnd_api.g_miss_num, NULL, p_dependent_on_task_id)
              INTO l_dependent_on_task_id
              FROM dual;

Line: 448


            SELECT DECODE (p_dependent_on_task_number, fnd_api.g_miss_char, NULL, p_dependent_on_task_number)
              INTO l_dependent_on_task_number
              FROM dual;

Line: 505


        jtf_task_dependency_pvt.update_task_dependency (
            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_dependency_id => p_dependency_id,
            p_task_id => l_task_id,
            p_dependent_on_task_id => l_dependent_on_task_id,
            p_dependency_type_code => l_dependency_type_code,
            p_adjustment_time => l_adjustment_time,
            p_adjustment_time_uom => l_adjustment_time_uom,
            p_validated_flag => p_validated_flag,
            x_return_status => x_return_status,
            x_msg_data => x_msg_data,
            x_msg_count => x_msg_count,
            p_attribute1 => task_depends.attribute1 ,
            p_attribute2 => task_depends.attribute2 ,
            p_attribute3 => task_depends.attribute3 ,
            p_attribute4 => task_depends.attribute4 ,
            p_attribute5 => task_depends.attribute5 ,
            p_attribute6 => task_depends.attribute6 ,
            p_attribute7 => task_depends.attribute7 ,
            p_attribute8 => task_depends.attribute8 ,
            p_attribute9 => task_depends.attribute9 ,
            p_attribute10 => task_depends.attribute10 ,
            p_attribute11 => task_depends.attribute11 ,
            p_attribute12 => task_depends.attribute12 ,
            p_attribute13 => task_depends.attribute13 ,
            p_attribute14 => task_depends.attribute14 ,
            p_attribute15 => task_depends.attribute15 ,
            p_attribute_category => task_depends.attribute_category
        );

Line: 560


            ROLLBACK TO update_task_dependency_pub;

Line: 576


            ROLLBACK TO update_task_dependency_pub;

Line: 583


    PROCEDURE delete_task_dependency (
        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_dependency_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: 595


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

Line: 603


            SELECT 1
              FROM jtf_task_depends
             WHERE dependency_id = l_dependency_id;

Line: 610


        SAVEPOINT delete_task_dependency_pub;

Line: 647


            jtf_task_dependency_pvt.delete_task_dependency (
                p_api_version => l_api_version,
                p_init_msg_list => fnd_api.g_false,
                p_commit => fnd_api.g_false,
                p_object_version_number => p_object_version_number,
                p_dependency_id => l_dependency_id,
                x_return_status => l_return_status,
                x_msg_count => l_msg_count,
                x_msg_data => l_msg_data
            );

Line: 682


            ROLLBACK TO delete_task_dependency_pub;

Line: 695


            ROLLBACK TO delete_task_dependency_pub;

Line: 707


            ROLLBACK TO delete_task_dependency_pub;

Line: 718


    END;   -- Delete Task dependency