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

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

Line: 37


          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a4(indx));

Line: 38


          t(ddindx).last_updated_by := a5(indx);

Line: 41


          t(ddindx).last_update_login := a8(indx);

Line: 100


          a4(indx) := t(ddindx).last_update_date;

Line: 101


          a5(indx) := t(ddindx).last_updated_by;

Line: 104


          a8(indx) := t(ddindx).last_update_login;

Line: 133


    , p_last_update_date  date
    , p_last_updated_by  NUMBER
    , p_creation_date  date
    , p_created_by  NUMBER
    , p_last_update_login  NUMBER
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
    , p_context  VARCHAR2
    , p_note_type  VARCHAR2
    , p40_a0 JTF_NUMBER_TABLE
    , p40_a1 JTF_NUMBER_TABLE
    , p40_a2 JTF_VARCHAR2_TABLE_300
    , p40_a3 JTF_NUMBER_TABLE
    , p40_a4 JTF_DATE_TABLE
    , p40_a5 JTF_NUMBER_TABLE
    , p40_a6 JTF_DATE_TABLE
    , p40_a7 JTF_NUMBER_TABLE
    , p40_a8 JTF_NUMBER_TABLE
  )

  as
    ddp_entered_date date;

Line: 168


    ddp_last_update_date date;

Line: 194


    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 248


      ddp_last_update_date,
      p_last_updated_by,
      ddp_creation_date,
      p_created_by,
      p_last_update_login,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      p_context,
      p_note_type,
      ddp_jtf_note_contexts_tab);

Line: 315


  procedure update_note(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p_jtf_note_id  NUMBER
    , p_entered_by  NUMBER
    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER
    , p_notes  VARCHAR2
    , p_notes_detail  VARCHAR2
    , p_append_flag  VARCHAR2
    , p_note_status  VARCHAR2
    , p_note_type  VARCHAR2
    , p17_a0 JTF_NUMBER_TABLE
    , p17_a1 JTF_NUMBER_TABLE
    , p17_a2 JTF_VARCHAR2_TABLE_300
    , p17_a3 JTF_NUMBER_TABLE
    , p17_a4 JTF_DATE_TABLE
    , p17_a5 JTF_NUMBER_TABLE
    , p17_a6 JTF_DATE_TABLE
    , p17_a7 JTF_NUMBER_TABLE
    , p17_a8 JTF_NUMBER_TABLE
  )

  as
    ddp_last_update_date date;

Line: 360


    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 380


    jtf_notes_pub.update_note(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_jtf_note_id,
      p_entered_by,
      p_last_updated_by,
      ddp_last_update_date,
      p_last_update_login,
      p_notes,
      p_notes_detail,
      p_append_flag,
      p_note_status,
      p_note_type,
      ddp_jtf_note_contexts_tab);

Line: 422


    , p_last_update_date  date
    , p_last_updated_by  NUMBER
    , p_creation_date  date
    , p_created_by  NUMBER
    , p_last_update_login  NUMBER
    , p_note_context_type_id  NUMBER
    , p_note_context_type  VARCHAR2
    , x_note_context_id out nocopy  NUMBER
  )

  as
    ddp_last_update_date date;

Line: 442


    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 456


      ddp_last_update_date,
      p_last_updated_by,
      ddp_creation_date,
      p_created_by,
      p_last_update_login,
      p_note_context_type_id,
      p_note_context_type,
      x_note_context_id);

Line: 478


  procedure update_note_context(p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , p_note_context_id  NUMBER
    , p_jtf_note_id  NUMBER
    , p_note_context_type_id  NUMBER
    , p_note_context_type  VARCHAR2
    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER
  )

  as
    ddp_last_update_date date;

Line: 502


    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 506


    jtf_notes_pub.update_note_context(p_validation_level,
      x_return_status,
      p_note_context_id,
      p_jtf_note_id,
      p_note_context_type_id,
      p_note_context_type,
      p_last_updated_by,
      ddp_last_update_date,
      p_last_update_login);

Line: 545


    , p_last_update_date  date
    , p_last_updated_by  NUMBER
    , p_creation_date  date
    , p_created_by  NUMBER
    , p_last_update_login  NUMBER
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
    , p_context  VARCHAR2
    , p_note_type  VARCHAR2
    , p40_a0 JTF_NUMBER_TABLE
    , p40_a1 JTF_NUMBER_TABLE
    , p40_a2 JTF_VARCHAR2_TABLE_300
    , p40_a3 JTF_NUMBER_TABLE
    , p40_a4 JTF_DATE_TABLE
    , p40_a5 JTF_NUMBER_TABLE
    , p40_a6 JTF_DATE_TABLE
    , p40_a7 JTF_NUMBER_TABLE
    , p40_a8 JTF_NUMBER_TABLE
    , p_use_aol_security  VARCHAR2
  )

  as
    ddp_entered_date date;

Line: 581


    ddp_last_update_date date;

Line: 607


    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 662


      ddp_last_update_date,
      p_last_updated_by,
      ddp_creation_date,
      p_created_by,
      p_last_update_login,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      p_context,
      p_note_type,
      ddp_jtf_note_contexts_tab,
      p_use_aol_security);

Line: 731


  procedure secure_update_note(p_api_version  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_validation_level  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p_jtf_note_id  NUMBER
    , p_entered_by  NUMBER
    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER
    , p_notes  VARCHAR2
    , p_notes_detail  VARCHAR2
    , p_append_flag  VARCHAR2
    , p_note_status  VARCHAR2
    , p_note_type  VARCHAR2
    , p17_a0 JTF_NUMBER_TABLE
    , p17_a1 JTF_NUMBER_TABLE
    , p17_a2 JTF_VARCHAR2_TABLE_300
    , p17_a3 JTF_NUMBER_TABLE
    , p17_a4 JTF_DATE_TABLE
    , p17_a5 JTF_NUMBER_TABLE
    , p17_a6 JTF_DATE_TABLE
    , p17_a7 JTF_NUMBER_TABLE
    , p17_a8 JTF_NUMBER_TABLE
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
    , p_context  VARCHAR2
    , p_use_aol_security  VARCHAR2
  )

  as
    ddp_last_update_date date;

Line: 793


    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 830


    jtf_notes_pub.secure_update_note(p_api_version,
      p_init_msg_list,
      p_commit,
      p_validation_level,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_jtf_note_id,
      p_entered_by,
      p_last_updated_by,
      ddp_last_update_date,
      p_last_update_login,
      p_notes,
      p_notes_detail,
      p_append_flag,
      p_note_status,
      p_note_type,
      ddp_jtf_note_contexts_tab,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      p_context,
      p_use_aol_security);