APPS.HZ_GEOGRAPHY_PUB_UIW_JW SQL Statements

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

Line: 266

  procedure update_geo_identifier(p_init_msg_list  VARCHAR2
    , p_object_version_number in out nocopy  NUMBER
    , x_cp_request_id out nocopy  NUMBER
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
    , p1_a0  NUMBER := null
    , p1_a1  VARCHAR2 := null
    , p1_a2  VARCHAR2 := null
    , p1_a3  VARCHAR2 := null
    , p1_a4  VARCHAR2 := null
    , p1_a5  VARCHAR2 := null
    , p1_a6  VARCHAR2 := userenv('LANG')
    , p1_a7  VARCHAR2 := null
    , p1_a8  NUMBER := null
    , p1_a9  VARCHAR2 := null
    , p1_a10  VARCHAR2 := null
  )
  as
    ddp_geo_identifier_rec hz_geography_pub_uiw.geo_identifier_rec_type;

Line: 309

    hz_geography_pub_uiw.update_geo_identifier(p_init_msg_list,
      ddp_geo_identifier_rec,
      p_object_version_number,
      x_cp_request_id,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 388

  procedure update_geography(p_init_msg_list  VARCHAR2
    , p_geography_id  NUMBER
    , p_end_date  date
    , p_timezone_code  VARCHAR2
    , p_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
  )
  as
    ddp_end_date date;

Line: 413

    hz_geography_pub_uiw.update_geography(p_init_msg_list,
      p_geography_id,
      ddp_end_date,
      p_timezone_code,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 482

  procedure update_geography_range(p_init_msg_list  VARCHAR2
    , p_geography_id  NUMBER
    , p_geography_from  VARCHAR2
    , p_start_date  date
    , p_end_date  date
    , p_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
  )
  as
    ddp_start_date date;

Line: 511

    hz_geography_pub_uiw.update_geography_range(p_init_msg_list,
      p_geography_id,
      p_geography_from,
      ddp_start_date,
      ddp_end_date,
      p_object_version_number,
      x_return_status,
      x_msg_count,
      x_msg_data);