APPS.HZ_DSS_GROUPS_PUB_W SQL Statements

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

Line: 65

  procedure update_group_2(p_init_msg_list  VARCHAR2
    , x_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  VARCHAR2 := fnd_api.g_miss_char
    , p1_a1  VARCHAR2 := fnd_api.g_miss_char
    , p1_a2  VARCHAR2 := fnd_api.g_miss_char
    , p1_a3  VARCHAR2 := fnd_api.g_miss_char
    , p1_a4  VARCHAR2 := fnd_api.g_miss_char
    , p1_a5  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_dss_group hz_dss_groups_pub.dss_group_rec_type;

Line: 97

    hz_dss_groups_pub.update_group(p_init_msg_list,
      ddp_dss_group,
      x_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 208

  procedure update_secured_module_5(p_init_msg_list  VARCHAR2
    , x_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := 0-1962.0724
    , p1_a1  VARCHAR2 := fnd_api.g_miss_char
    , p1_a2  VARCHAR2 := fnd_api.g_miss_char
    , p1_a3  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_dss_secured_module hz_dss_groups_pub.dss_secured_module_type;

Line: 236

    hz_dss_groups_pub.update_secured_module(p_init_msg_list,
      ddp_dss_secured_module,
      x_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 296

  procedure update_secured_criterion_7(p_init_msg_list  VARCHAR2
    , x_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := 0-1962.0724
    , p1_a1  VARCHAR2 := fnd_api.g_miss_char
    , p1_a2  VARCHAR2 := fnd_api.g_miss_char
    , p1_a3  VARCHAR2 := fnd_api.g_miss_char
    , p1_a4  VARCHAR2 := fnd_api.g_miss_char
    , p1_a5  VARCHAR2 := fnd_api.g_miss_char
    , p1_a6  VARCHAR2 := fnd_api.g_miss_char
    , p1_a7  VARCHAR2 := fnd_api.g_miss_char
    , p1_a8  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_dss_secured_criterion hz_dss_groups_pub.dss_secured_criterion_type;

Line: 334

    hz_dss_groups_pub.update_secured_criterion(p_init_msg_list,
      ddp_dss_secured_criterion,
      x_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 349

  procedure update_secured_classificati_8(p_init_msg_list  VARCHAR2
    , x_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := 0-1962.0724
    , p1_a1  VARCHAR2 := fnd_api.g_miss_char
    , p1_a2  VARCHAR2 := fnd_api.g_miss_char
    , p1_a3  VARCHAR2 := fnd_api.g_miss_char
    , p1_a4  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_dss_secured_class hz_dss_groups_pub.dss_secured_class_type;

Line: 379

    hz_dss_groups_pub.update_secured_classification(p_init_msg_list,
      ddp_dss_secured_class,
      x_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 437

  procedure update_secured_rel_type_10(p_init_msg_list  VARCHAR2
    , x_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := 0-1962.0724
    , p1_a1  VARCHAR2 := fnd_api.g_miss_char
    , p1_a2  NUMBER := 0-1962.0724
    , p1_a3  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_dss_secured_rel_type hz_dss_groups_pub.dss_secured_rel_type;

Line: 465

    hz_dss_groups_pub.update_secured_rel_type(p_init_msg_list,
      ddp_dss_secured_rel_type,
      x_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 574

  procedure update_secured_entity_13(p_init_msg_list  VARCHAR2
    , x_object_version_number in out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  VARCHAR2 := fnd_api.g_miss_char
    , p1_a1  NUMBER := 0-1962.0724
    , p1_a2  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_dss_secured_entity hz_dss_groups_pub.dss_secured_entity_type;

Line: 600

    hz_dss_groups_pub.update_secured_entity(p_init_msg_list,
      ddp_dss_secured_entity,
      x_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);