DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT_W SQL Statements

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

Line: 40

          t(ddindx).mlast_updated_date := a4(indx);
Line: 88

          a4(indx) := t(ddindx).mlast_updated_date;
Line: 128

    ddp_one_choice.mlast_updated_date := p3_a4;
Line: 267

  procedure update_choices(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR
    , p3_a0 JTF_NUMBER_TABLE
    , p3_a1 JTF_VARCHAR2_TABLE_1000
    , p3_a2 JTF_NUMBER_TABLE
    , p3_a3 JTF_NUMBER_TABLE
    , p3_a4 JTF_VARCHAR2_TABLE_100
    , p3_a5 JTF_VARCHAR2_TABLE_100
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
  )

  as
    ddp_choices cs_tp_choices_pvt.choice_list;
Line: 302

    cs_tp_choices_pvt.update_choices(p_api_version_number,
      p_init_msg_list,
      p_commit,
      ddp_choices,
      x_msg_count,
      x_msg_data,
      x_return_status);
Line: 346

    ddp_one_freetext.mlast_updated_date := p3_a4;
Line: 422

    p7_a4 := ddx_freetext.mlast_updated_date;