DBA Data[Home] [Help]

APPS.CS_TP_QUESTIONS_PVT_W SQL Statements

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

Line: 45

          t(ddindx).mlast_updated_date := a6(indx);
Line: 108

          a6(indx) := t(ddindx).mlast_updated_date;
Line: 155

    ddp_one_question.mlast_updated_date := p3_a6;
Line: 186

  procedure update_question(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , p3_a0  NUMBER := 0-1962.0724
    , p3_a1  VARCHAR2 := fnd_api.g_miss_char
    , p3_a2  VARCHAR2 := fnd_api.g_miss_char
    , p3_a3  VARCHAR2 := fnd_api.g_miss_char
    , p3_a4  VARCHAR2 := fnd_api.g_miss_char
    , p3_a5  NUMBER := 0-1962.0724
    , p3_a6  VARCHAR2 := fnd_api.g_miss_char
    , p3_a7  VARCHAR2 := fnd_api.g_miss_char
    , p3_a8  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_one_question cs_tp_questions_pvt.question;
Line: 218

    ddp_one_question.mlast_updated_date := p3_a6;
Line: 226

    cs_tp_questions_pvt.update_question(p_api_version_number,
      p_init_msg_list,
      p_commit,
      ddp_one_question,
      x_msg_count,
      x_msg_data,
      x_return_status);
Line: 443

    p7_a6 := ddx_question_to_show.mlast_updated_date;