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.JTM_NOTES_VUHK SQL Statements

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

Line: 5


     Select HOOK_PACKAGE, HOOK_API , EXECUTE_FLAG, PRODUCT_CODE
	 from JTF_HOOKS_DATA
	 Where package_name = 'JTM_NOTES_PUB' and
	 upper(api_name) = upper(p_api_name) and
	 processing_type = p_processing_type and
         execute_flag = 'Y' and
	 hook_type = 'V';

Line: 32


, 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
, p_attribute2              IN     VARCHAR2
, p_attribute3              IN     VARCHAR2
, p_attribute4              IN     VARCHAR2
, p_attribute5              IN     VARCHAR2
, p_attribute6              IN     VARCHAR2
, p_attribute7              IN     VARCHAR2
, p_attribute8              IN     VARCHAR2
, p_attribute9              IN     VARCHAR2
, p_attribute10             IN     VARCHAR2
, p_attribute11             IN     VARCHAR2
, p_attribute12             IN     VARCHAR2
, p_attribute13             IN     VARCHAR2
, p_attribute14             IN     VARCHAR2
, p_attribute15             IN     VARCHAR2
, p_context                 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
begin
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 81


, 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
, p_attribute2              IN     VARCHAR2
, p_attribute3              IN     VARCHAR2
, p_attribute4              IN     VARCHAR2
, p_attribute5              IN     VARCHAR2
, p_attribute6              IN     VARCHAR2
, p_attribute7              IN     VARCHAR2
, p_attribute8              IN     VARCHAR2
, p_attribute9              IN     VARCHAR2
, p_attribute10             IN     VARCHAR2
, p_attribute11             IN     VARCHAR2
, p_attribute12             IN     VARCHAR2
, p_attribute13             IN     VARCHAR2
, p_attribute14             IN     VARCHAR2
, p_attribute15             IN     VARCHAR2
, p_context                 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
, p_jtf_note_id             IN     NUMBER
) is
  l_enable_flag varchar2(20);

Line: 172


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

Line: 173


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

Line: 176


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

Line: 215


/* 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
, 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_enable_flag varchar2(20);

Line: 245


   FOR Csr1 in Get_hook_info('B', 'UPDATE_NOTE') LOOP

      /* user execute flag */
      l_enable_flag := Csr1.EXECUTE_FLAG;

Line: 291


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

Line: 292


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

Line: 293


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

Line: 314


end update_note_pre;

Line: 317


/* 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_enable_flag varchar2(20);

Line: 348


   FOR Csr1 in Get_hook_info('A', 'UPDATE_NOTE') LOOP

      /* user execute flag */
      l_enable_flag := Csr1.EXECUTE_FLAG;

Line: 394


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

Line: 395


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

Line: 396


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

Line: 437


, 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
, p_attribute2            IN     VARCHAR2
, p_attribute3            IN     VARCHAR2
, p_attribute4            IN     VARCHAR2
, p_attribute5            IN     VARCHAR2
, p_attribute6            IN     VARCHAR2
, p_attribute7            IN     VARCHAR2
, p_attribute8            IN     VARCHAR2
, p_attribute9            IN     VARCHAR2
, p_attribute10           IN     VARCHAR2
, p_attribute11           IN     VARCHAR2
, p_attribute12           IN     VARCHAR2
, p_attribute13           IN     VARCHAR2
, p_attribute14           IN     VARCHAR2
, p_attribute15           IN     VARCHAR2
, p_context               IN     VARCHAR2
, p_note_type             IN     VARCHAR2
, p_jtf_note_contexts_tab IN     jtf_notes_pub.jtf_note_contexts_tbl_type
)RETURN BOOLEAN
IS
BEGIN
 RETURN TRUE;