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

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

Line: 19


        select scheduled_start_date ssd, scheduled_end_date sed
        from   jtf_tasks_b
        where  task_id = l_task_id;

Line: 155


        select 1
        from   jtf_task_depends
        where  task_id = l_task_id
          and dependent_on_task_id = l_dependent_on_task_id
          and dependency_id <> l_dependency_id
          and template_flag = 'Y';

Line: 167


        select 1
        from   jtf_task_depends
        where  task_id = l_task_id
	  and  dependent_on_task_id = l_dependent_on_task_id
	  and  dependency_id <> l_dependency_id
	  and (template_flag = 'N' or template_flag is null);

Line: 177


        select 1
        from   jtf_task_depends
        where  task_id = p_dependent_on_task_id
          and  dependency_id <> l_dependency_id
          connect by prior task_id = dependent_on_task_id
          start with dependent_on_task_id = p_task_id
          and  template_flag = 'Y';

Line: 188


        select 1
        from   jtf_task_depends
        where  task_id = p_dependent_on_task_id
          and  dependency_id <> l_dependency_id
          connect by prior task_id = dependent_on_task_id
          start with dependent_on_task_id = p_task_id
          and  (template_flag = 'N' or template_flag is null);

Line: 324


          select dependency_id,
            task_id,
            dependency_type_code,
            adjustment_time,
            adjustment_time_uom,
            object_version_number
          from   jtf_task_depends
          where  dependent_on_task_id = p_task_id and
            (template_flag is null or template_flag = 'N');

Line: 337


          select dependency_id,
            task_id,
            dependency_type_code,
            adjustment_time,
            adjustment_time_uom,
            object_version_number
          from   jtf_task_depends
          where  dependent_on_task_id = p_task_id and template_flag = 'Y';

Line: 349


          select dependency_id,
            dependent_on_task_id,
            dependency_type_code,
            adjustment_time,
            adjustment_time_uom,
            object_version_number
          from   jtf_task_depends
          where  task_id = p_task_id and
            (template_flag is null or template_flag = 'N');

Line: 363


          select dependency_id,
            dependent_on_task_id,
            dependency_type_code,
            adjustment_time,
            adjustment_time_uom,
            object_version_number
          from   jtf_task_depends
          where  task_id = p_task_id and template_flag = 'Y';

Line: 610


        SELECT jtf_task_depends_s.nextval
          INTO l_dependency_id
          FROM dual;

Line: 614


        jtf_task_depends_pkg.insert_row (
            x_rowid => l_rowid,
            x_dependency_id => l_dependency_id,
            x_task_id => p_task_id,
            x_dependent_on_task_id => p_dependent_on_task_id,
            x_adjustment_time => p_adjustment_time,
            x_adjustment_time_uom => p_adjustment_time_uom,
            x_template_flag => p_template_flag,
            x_validated_flag => p_validated_flag,
            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_dependency_type_code => p_dependency_type_code,
            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: 689


    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_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,
        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,
        p_validated_flag          in       varchar2 default 'N'
    )
    IS
        l_api_name            CONSTANT VARCHAR2(30)                               := 'UPDATE_TASK_DEPENDENCY';

Line: 742


            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 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,
                   created_by,
                   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 = l_dependency_id;

Line: 774


        SAVEPOINT update_task_dependency_pvt;

Line: 917


        jtf_task_depends_pkg.update_row (
            x_dependency_id => l_dependency_id,
            x_object_version_number => p_object_version_number + 1,
            x_task_id => l_task_id,
            x_dependent_on_task_id => l_dependent_on_task_id,
            x_dependency_type_code => l_dependency_type_code,
            x_adjustment_time_uom => l_adjustment_time_uom,
            x_template_flag => l_template_flag,
            x_adjustment_time => l_adjustment_time,
            x_validated_flag => p_validated_flag,
            x_attribute1 => task_depends.attribute1 ,
            x_attribute2 => task_depends.attribute2 ,
            x_attribute3 => task_depends.attribute3 ,
            x_attribute4 => task_depends.attribute4 ,
            x_attribute5 => task_depends.attribute5 ,
            x_attribute6 => task_depends.attribute6 ,
            x_attribute7 => task_depends.attribute7 ,
            x_attribute8 => task_depends.attribute8 ,
            x_attribute9 => task_depends.attribute9 ,
            x_attribute10 => task_depends.attribute10 ,
            x_attribute11 => task_depends.attribute11 ,
            x_attribute12 => task_depends.attribute12 ,
            x_attribute13 => task_depends.attribute13 ,
            x_attribute14 => task_depends.attribute14 ,
            x_attribute15 => task_depends.attribute15 ,
            x_attribute_category => task_depends.attribute_category ,
            x_last_update_date => SYSDATE,
            x_last_updated_by => jtf_task_utl.updated_by,
            x_last_update_login => -1
        );

Line: 968


            ROLLBACK TO update_task_dependency_pvt;

Line: 977


            ROLLBACK TO update_task_dependency_pvt;

Line: 1000


            ROLLBACK TO update_task_dependency_pvt;

Line: 1013


    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
        x                char;

Line: 1032


            SELECT 1
              FROM jtf_task_depends
             WHERE dependency_id = l_dependency_id;

Line: 1039


        SAVEPOINT delete_task_dependency_pvt;

Line: 1047


        jtf_task_depends_pkg.delete_row (x_dependency_id => l_dependency_id);

Line: 1080


            ROLLBACK TO delete_task_dependency_pvt;

Line: 1085


            ROLLBACK TO delete_task_dependency_pvt;

Line: 1096


            ROLLBACK TO delete_task_dependency_pvt;