APPS.CS_TP_TEMPLATES_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: 144

          t(ddindx).mlast_updated_date := a7(indx);

Line: 202

          a7(indx) := t(ddindx).mlast_updated_date;

Line: 236

          t(ddindx).mlast_updated_date := a7(indx);

Line: 294

          a7(indx) := t(ddindx).mlast_updated_date;

Line: 445

    ddp_one_template.mlast_updated_date := p3_a6;

Line: 473

  procedure update_template(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  VARCHAR2 := fnd_api.g_miss_char
    , 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_template cs_tp_templates_pvt.template;

Line: 505

    ddp_one_template.mlast_updated_date := p3_a6;

Line: 513

    cs_tp_templates_pvt.update_template(p_api_version_number,
      p_init_msg_list,
      p_commit,
      ddp_one_template,
      x_msg_count,
      x_msg_data,
      x_return_status);

Line: 530

  procedure update_template_attributes(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR
    , p_template_id  NUMBER
    , p4_a0 JTF_NUMBER_TABLE
    , p4_a1 JTF_VARCHAR2_TABLE_1000
    , p4_a2 JTF_NUMBER_TABLE
    , p4_a3 JTF_NUMBER_TABLE
    , p4_a4 JTF_VARCHAR2_TABLE_200
    , p4_a5 JTF_NUMBER_TABLE
    , p4_a6 JTF_VARCHAR2_TABLE_200
    , p4_a7 JTF_VARCHAR2_TABLE_200
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
  )

  as
    ddp_template_attributes cs_tp_templates_pvt.template_attribute_list;

Line: 571

    cs_tp_templates_pvt.update_template_attributes(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_template_id,
      ddp_template_attributes,
      x_msg_count,
      x_msg_data,
      x_return_status);

Line: 590

  procedure update_template_links(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR
    , p_template_id  NUMBER
    , p_jtf_object_code  VARCHAR2
    , p5_a0 JTF_NUMBER_TABLE
    , p5_a1 JTF_VARCHAR2_TABLE_1000
    , p5_a2 JTF_VARCHAR2_TABLE_1000
    , p5_a3 JTF_VARCHAR2_TABLE_200
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_VARCHAR2_TABLE_100
    , p5_a6 JTF_VARCHAR2_TABLE_100
    , p5_a7 JTF_VARCHAR2_TABLE_200
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
  )

  as
    ddp_template_links cs_tp_templates_pvt.template_link_list;

Line: 633

    cs_tp_templates_pvt.update_template_links(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_template_id,
      p_jtf_object_code,
      ddp_template_links,
      x_msg_count,
      x_msg_data,
      x_return_status);

Line: 792

    p7_a6 := ddx_template_to_show.mlast_updated_date;

Line: 1202

    p6_a6 := ddx_default_template.mlast_updated_date;

Line: 1371

  procedure delete_template_links(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR
    , p_template_id  NUMBER
    , p_jtf_object_code  VARCHAR2
    , p5_a0 JTF_NUMBER_TABLE
    , p5_a1 JTF_VARCHAR2_TABLE_1000
    , p5_a2 JTF_VARCHAR2_TABLE_1000
    , p5_a3 JTF_VARCHAR2_TABLE_200
    , p5_a4 JTF_NUMBER_TABLE
    , p5_a5 JTF_VARCHAR2_TABLE_100
    , p5_a6 JTF_VARCHAR2_TABLE_100
    , p5_a7 JTF_VARCHAR2_TABLE_200
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
  )

  as
    ddp_template_links cs_tp_templates_pvt.template_link_list;

Line: 1414

    cs_tp_templates_pvt.delete_template_links(p_api_version_number,
      p_init_msg_list,
      p_commit,
      p_template_id,
      p_jtf_object_code,
      ddp_template_links,
      x_msg_count,
      x_msg_data,
      x_return_status);