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

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

Line: 28


, p_last_update_date        IN     DATE
, p_last_updated_by         IN     NUMBER
, p_creation_date           IN     DATE
, p_created_by              IN     NUMBER
, p_last_update_login       IN     NUMBER
, p_attribute1              IN     VARCHAR2  DEFAULT NULL
, p_attribute2              IN     VARCHAR2  DEFAULT NULL
, p_attribute3              IN     VARCHAR2  DEFAULT NULL
, p_attribute4              IN     VARCHAR2  DEFAULT NULL
, p_attribute5              IN     VARCHAR2  DEFAULT NULL
, p_attribute6              IN     VARCHAR2  DEFAULT NULL
, p_attribute7              IN     VARCHAR2  DEFAULT NULL
, p_attribute8              IN     VARCHAR2  DEFAULT NULL
, p_attribute9              IN     VARCHAR2  DEFAULT NULL
, p_attribute10             IN     VARCHAR2  DEFAULT NULL
, p_attribute11             IN     VARCHAR2  DEFAULT NULL
, p_attribute12             IN     VARCHAR2  DEFAULT NULL
, p_attribute13             IN     VARCHAR2  DEFAULT NULL
, p_attribute14             IN     VARCHAR2  DEFAULT NULL
, p_attribute15             IN     VARCHAR2  DEFAULT NULL
, p_context                 IN     VARCHAR2  DEFAULT NULL
, p_note_type               IN     VARCHAR2  DEFAULT NULL
, p_jtf_note_contexts_tab   IN     jtf_notes_pub.jtf_note_contexts_tbl_type
, x_return_status              OUT NOCOPY VARCHAR2
) is
begin
   /* NOT USED */
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 78


, p_last_update_date        IN     DATE
, p_last_updated_by         IN     NUMBER
, p_creation_date           IN     DATE
, p_created_by              IN     NUMBER
, p_last_update_login       IN     NUMBER
, p_attribute1              IN     VARCHAR2 DEFAULT NULL
, p_attribute2              IN     VARCHAR2 DEFAULT NULL
, p_attribute3              IN     VARCHAR2 DEFAULT NULL
, p_attribute4              IN     VARCHAR2 DEFAULT NULL
, p_attribute5              IN     VARCHAR2 DEFAULT NULL
, p_attribute6              IN     VARCHAR2 DEFAULT NULL
, p_attribute7              IN     VARCHAR2 DEFAULT NULL
, p_attribute8              IN     VARCHAR2 DEFAULT NULL
, p_attribute9              IN     VARCHAR2 DEFAULT NULL
, p_attribute10             IN     VARCHAR2 DEFAULT NULL
, p_attribute11             IN     VARCHAR2 DEFAULT NULL
, p_attribute12             IN     VARCHAR2 DEFAULT NULL
, p_attribute13             IN     VARCHAR2 DEFAULT NULL
, p_attribute14             IN     VARCHAR2 DEFAULT NULL
, p_attribute15             IN     VARCHAR2 DEFAULT NULL
, p_context                 IN     VARCHAR2 DEFAULT NULL
, p_note_type               IN     VARCHAR2 DEFAULT NULL
, p_jtf_note_contexts_tab   IN     jtf_notes_pub.jtf_note_contexts_tbl_type
, x_return_status              OUT NOCOPY VARCHAR2
, p_jtf_note_id             IN     NUMBER
) is
  l_JTM_enable_prof_value varchar2(255);

Line: 169


         DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);

Line: 170


         DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);

Line: 173


         DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);

Line: 216


/* Verticals Procedure for pre processing in case of update note */

PROCEDURE update_note_pre
( p_api_version           IN     NUMBER
, p_init_msg_list         IN     VARCHAR2
, p_commit                IN     VARCHAR2
, p_validation_level      IN     NUMBER
, x_msg_count                OUT NOCOPY NUMBER
, x_msg_data                 OUT NOCOPY VARCHAR2
, p_jtf_note_id           IN     NUMBER
, p_entered_by            IN     NUMBER
, p_last_updated_by       IN     NUMBER
, p_last_update_date      IN     DATE     DEFAULT SYSDATE
, p_last_update_login     IN     NUMBER   DEFAULT NULL
, p_notes                 IN     VARCHAR2
, p_notes_detail          IN     VARCHAR2
, p_append_flag           IN     VARCHAR2
, p_note_status           IN     VARCHAR2
, p_note_type             IN     VARCHAR2
, p_jtf_note_contexts_tab IN     jtf_notes_pub.jtf_note_contexts_tbl_type
, x_return_status            OUT NOCOPY VARCHAR2
) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 244


           ' ''UPDATE_NOTE_PRE'', ' ||
           ' ''JTF_NOTES_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.JTF_NOTES_VUHK.UPDATE_NOTE_PRE''); ' ||

Line: 259


           ' ''UPDATE_NOTE_PRE'', ' ||
           ' ''JTF_NOTES_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.JTF_NOTES_VUHK.UPDATE_NOTE_PRE''); ' ||

Line: 277


            ' begin ' || 'JTM_NOTES_VUHK' || '.' || 'update_note_pre' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,' ||
            ' :11,:12,:13,:14,:15,:16,:17); ' ||

Line: 293


         DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);

Line: 294


         DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);

Line: 295


         DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);

Line: 320


end update_note_pre;

Line: 323


/* Vertical Procedure for post processing in case of update note */

PROCEDURE update_note_post
( p_api_version           IN     NUMBER
, p_init_msg_list         IN     VARCHAR2
, p_commit                IN     VARCHAR2
, p_validation_level      IN     NUMBER
, x_msg_count                OUT NOCOPY NUMBER
, x_msg_data                 OUT NOCOPY VARCHAR2
, p_jtf_note_id           IN     NUMBER
, p_entered_by            IN     NUMBER
, p_last_updated_by       IN     NUMBER
, p_last_update_date      IN     DATE
, p_last_update_login     IN     NUMBER
, p_notes                 IN     VARCHAR2
, p_notes_detail          IN     VARCHAR2
, p_append_flag           IN     VARCHAR2
, p_note_status           IN     VARCHAR2
, p_note_type             IN     VARCHAR2
, p_jtf_note_contexts_tab IN     jtf_notes_pub.jtf_note_contexts_tbl_type
, x_return_status            OUT NOCOPY VARCHAR2
) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 351


           ' ''UPDATE_NOTE_POST'', ' ||
           ' ''JTF_NOTES_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.JTF_NOTES_VUHK.UPDATE_NOTE_POST''); ' ||

Line: 366


           ' ''UPDATE_NOTE_POST'', ' ||
           ' ''JTF_NOTES_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.JTF_NOTES_VUHK.UPDATE_NOTE_POST''); ' ||

Line: 384


            ' begin ' || 'JTM_NOTES_VUHK' || '.' || 'update_note_post' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,' ||
            ' :11,:12,:13,:14,:15,:16,:17); ' ||

Line: 400


         DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);

Line: 401


         DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);

Line: 402


         DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);

Line: 447


, p_last_update_date      IN     DATE
, p_last_updated_by       IN     NUMBER
, p_creation_date         IN     DATE
, p_created_by            IN     NUMBER
, p_last_update_login     IN     NUMBER
, p_attribute1            IN     VARCHAR2 DEFAULT NULL
, p_attribute2            IN     VARCHAR2 DEFAULT NULL
, p_attribute3            IN     VARCHAR2 DEFAULT NULL
, p_attribute4            IN     VARCHAR2 DEFAULT NULL
, p_attribute5            IN     VARCHAR2 DEFAULT NULL
, p_attribute6            IN     VARCHAR2 DEFAULT NULL
, p_attribute7            IN     VARCHAR2 DEFAULT NULL
, p_attribute8            IN     VARCHAR2 DEFAULT NULL
, p_attribute9            IN     VARCHAR2 DEFAULT NULL
, p_attribute10           IN     VARCHAR2 DEFAULT NULL
, p_attribute11           IN     VARCHAR2 DEFAULT NULL
, p_attribute12           IN     VARCHAR2 DEFAULT NULL
, p_attribute13           IN     VARCHAR2 DEFAULT NULL
, p_attribute14           IN     VARCHAR2 DEFAULT NULL
, p_attribute15           IN     VARCHAR2 DEFAULT NULL
, p_context               IN     VARCHAR2 DEFAULT NULL
, p_note_type             IN     VARCHAR2 DEFAULT NULL
, p_jtf_note_contexts_tab IN     jtf_notes_pub.jtf_note_contexts_tbl_type
)RETURN BOOLEAN
IS
BEGIN
 RETURN TRUE;

Line: 490


    p_last_updated_by           IN      NUMBER,
    p_last_update_date          IN      DATE,
    p_last_update_login         IN      NUMBER,
    p_notes                     IN      VARCHAR2,
    p_notes_detail              IN      VARCHAR2,
    p_append_flag             IN VARCHAR2 ,
    p_note_status       IN      VARCHAR2 ,
    p_note_type           IN   VARCHAR2 ,
    p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type ,
    x_return_status        OUT  NOCOPY VARCHAR2
    )RETURN BOOLEAN
IS
BEGIN
 RETURN TRUE;

Line: 524


                      p_last_update_date        IN DATE     ,
                 p_last_updated_by         IN NUMBER   ,
                 p_creation_date           IN DATE     ,
                 p_created_by              IN NUMBER,
                 p_last_update_login       IN NUMBER,
                      p_attribute1                IN VARCHAR2  DEFAULT NULL,
                      p_attribute2                IN VARCHAR2  DEFAULT NULL,
                      p_attribute3                IN VARCHAR2  DEFAULT NULL,
                      p_attribute4                IN VARCHAR2  DEFAULT NULL,
                      p_attribute5                IN VARCHAR2  DEFAULT NULL,
                      p_attribute6                IN VARCHAR2  DEFAULT NULL,
                      p_attribute7                IN VARCHAR2  DEFAULT NULL,
                      p_attribute8                IN VARCHAR2  DEFAULT NULL,
                      p_attribute9                IN VARCHAR2  DEFAULT NULL,
                      p_attribute10               IN VARCHAR2  DEFAULT NULL,
                      p_attribute11               IN VARCHAR2  DEFAULT NULL,
                      p_attribute12               IN VARCHAR2  DEFAULT NULL,
                      p_attribute13               IN VARCHAR2  DEFAULT NULL,
                      p_attribute14               IN VARCHAR2  DEFAULT NULL,
                      p_attribute15               IN VARCHAR2  DEFAULT NULL,
                      p_context           IN VARCHAR2  DEFAULT NULL,
                      p_note_type  IN VARCHAR2  DEFAULT NULL,
                      p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type ,
                      x_return_status        OUT  NOCOPY VARCHAR2
        )
IS
BEGIN
 x_return_status := FND_API.G_RET_STS_SUCCESS;