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

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

Line: 41


        l_id_column            jtf_objects_b.select_id%TYPE;

Line: 42


        l_name_column          jtf_objects_b.select_name%TYPE;

Line: 57


            SELECT select_id,
                   select_name,
                   from_table,
                   where_clause
              FROM jtf_objects_vl
             WHERE object_code = l_object_type_code;

Line: 66


            SELECT 1
              FROM fnd_lookups
             WHERE lookup_type = 'JTF_TASK_REFERENCE_CODES'
               AND lookup_code = p_reference_code;

Line: 195


/*        SELECT DECODE (l_where_clause, NULL, '  ', l_where_clause || ' AND ')
          INTO l_where_clause
          FROM dual;

Line: 198


        sql_stmt := ' SELECT ' ||
                    l_name_column ||
                    ' , ' ||
                    l_id_column ||
                    ' from ' ||
                    l_from_clause ||
                    '  where ' ||
                    l_where_clause ||
                    l_name_column ||
				' = ' ||
                    ''''||
                    p_object_name||
                    '''';

Line: 411


            SELECT select_id,
                   select_name,
                   from_table,
                   where_clause
              FROM jtf_objects_vl
             WHERE object_code = p_object_type_code;

Line: 421


        l_id_column           jtf_objects_b.select_id%TYPE;

Line: 422


        l_name_column         jtf_objects_b.select_name%TYPE;

Line: 448


        SELECT DECODE (l_where_clause, NULL, '  ', l_where_clause || ' AND ')
          INTO l_where_clause
          FROM dual;

Line: 451


        sql_stmt := ' SELECT ' ||
                    l_name_column ||
                    ' , ' ||
                    l_id_column ||
                    ' from ' ||
                    l_from_clause ||
                    '  where ' ||
                    l_where_clause ||
                    l_name_column ||
                    ' = ' ||
                    p_object_name;

Line: 495


    PROCEDURE update_references (
        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_reference_id       IN       NUMBER,
        p_object_type_code    IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_object_name         IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_object_id           IN       NUMBER DEFAULT  fnd_api.g_miss_num,
        p_object_details      IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_reference_code      IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_usage               IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        x_return_status           OUT NOCOPY VARCHAR2,
        x_msg_data                OUT NOCOPY VARCHAR2,
        x_msg_count               OUT NOCOPY NUMBER,
        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: 529


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

Line: 541


            SELECT task_id,
                   DECODE (p_object_type_code, fnd_api.g_miss_char, object_type_code, p_object_type_code) object_type_code,
                   DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,
                   DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
                   DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
                   DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
                   DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
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_references_vl
             WHERE task_reference_id = p_task_reference_id;

Line: 572


        savepoint update_task_reference_pub ;

Line: 697


        jtf_task_references_pvt.update_references (
            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_reference_id => l_task_reference_id,
            p_object_type_code => task_references.object_type_code,
            p_object_name => task_references.object_name,
            p_object_id => task_references.object_id,
            p_object_details => p_object_details,
            p_reference_code => l_reference_code,
            p_usage => l_usage,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count ,
            x_msg_data => x_msg_data,
            p_attribute1 => task_references.attribute1 ,
            p_attribute2 => task_references.attribute2 ,
            p_attribute3 => task_references.attribute3 ,
            p_attribute4 => task_references.attribute4 ,
            p_attribute5 => task_references.attribute5 ,
            p_attribute6 => task_references.attribute6 ,
            p_attribute7 => task_references.attribute7 ,
            p_attribute8 => task_references.attribute8 ,
            p_attribute9 => task_references.attribute9 ,
            p_attribute10 => task_references.attribute10 ,
            p_attribute11 => task_references.attribute11 ,
            p_attribute12 => task_references.attribute12 ,
            p_attribute13 => task_references.attribute13 ,
            p_attribute14 => task_references.attribute14 ,
            p_attribute15 => task_references.attribute15 ,
            p_attribute_category => task_references.attribute_category
        );

Line: 750


            ROLLBACK TO update_task_reference_pub;

Line: 759


            ROLLBACK TO update_task_reference_pub;

Line: 770


    END;   ----- Update Task

Line: 778


    PROCEDURE delete_references (
        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_reference_id       IN       NUMBER ,
        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: 790


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

Line: 792


        SAVEPOINT delete_task_reference_pub;

Line: 822


        jtf_task_references_pvt.delete_references (
            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_reference_id => p_task_reference_id,
            x_return_status => x_return_status,
            x_msg_data => x_msg_data,
            x_msg_count => x_msg_count
        );

Line: 847


            ROLLBACK TO delete_task_reference_pub;

Line: 852


            ROLLBACK TO delete_task_reference_pub;