APPS.IEX_NOTES_PVT SQL Statements

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

Line: 79

         l_jtf_note_contexts_table(i).last_update_date  := sysdate;

Line: 81

         l_jtf_note_contexts_table(i).last_updated_by   := FND_GLOBAL.USER_ID;

Line: 83

         l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;

Line: 109

          p_last_update_date           => sysdate,
          p_last_updated_by            => FND_GLOBAL.USER_ID,
          p_creation_date              => sysdate,
          p_created_by                 => FND_GLOBAL.USER_ID,
          p_last_update_login          => FND_GLOBAL.USER_ID,
          x_jtf_note_id         => x_note_id,
          X_Return_Status              => l_Return_Status,
          X_Msg_Count                  => l_Msg_Count,
          X_Msg_Data                   => l_Msg_Data,
          p_jtf_note_contexts_tab      => l_jtf_note_contexts_table,
          p_note_type         => p_note_type);

Line: 215

  l_select_id    VARCHAR2(200);

Line: 216

  l_select_name  VARCHAR2(200);

Line: 217

  l_select_details  VARCHAR2(2000);

Line: 328

  l_sql_stmt := 'SELECT a.notes, a.created_by_name, a.creation_date, ' ||
                ' a.note_type_meaning, a.note_status_meaning, ' ||
                ' a.source_object_id, a.source_object_code, ' ||
                ' b.select_id, b.select_name, b.select_details, ' ||
                ' b.from_table, b.where_clause, tl.name, a.notes_detail_size ' ||
                'FROM iex_notes_bali_vl a, ' ||
                ' jtf_objects_b b, jtf_objects_tl tl ' ||
                'WHERE (a.note_status <> ''P'' or a.created_by = ' || l_fnd_user_id || ') ' ||
                'AND a.source_object_code = b.object_code ' ||
                'AND b.object_code = tl.object_code ' ||
                'AND tl.language = userenv(''LANG'') ' ||
                'AND a.jtf_note_id IN (SELECT jtf_note_id FROM jtf_note_contexts WHERE ' ;

Line: 370

          l_select_id,
          l_select_name,
          l_select_details,
          l_from_table,
          l_where_clause,
          l_source_name,
          l_notes_detail_size;

Line: 382

            l_select_id, l_select_name, l_select_details,
            l_from_table, l_where_clause, l_source_id) ||
          ' (ID:' || l_source_id || ')' ||
          l_new_line_chr || l_notes;

Line: 443

    SELECT ps.trx_number
    FROM jtf_note_contexts notes, ar_payment_schedules ps
    WHERE jtf_note_id = x_jtf_note_id
    AND note_context_type = 'IEX_INVOICES'
    AND ps.payment_schedule_id = note_context_type_id;

Line: 450

    SELECT p.party_name
    FROM jtf_note_contexts notes, hz_parties p
    WHERE jtf_note_id = x_jtf_note_id
    AND note_context_type = 'PARTY'
    AND note_context_type_id = p.party_id
    AND p.party_type = 'ORGANIZATION';