APPS.HZ_GEO_STRUCT_MAP_PUB_W SQL Statements

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

Line: 112

  procedure delete_geo_struct_mapping(p_map_id  NUMBER
    , p_location_table_name  VARCHAR2
    , p_country  VARCHAR2
    , p_address_style  VARCHAR2
    , p4_a0 JTF_NUMBER_TABLE
    , p4_a1 JTF_VARCHAR2_TABLE_100
    , p4_a2 JTF_VARCHAR2_TABLE_100
    , p_init_msg_list  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;

Line: 145

    hz_geo_struct_map_pub.delete_geo_struct_mapping(p_map_id,
      p_location_table_name,
      p_country,
      p_address_style,
      ddp_geo_struct_map_dtl_tbl,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 208

  procedure update_geo_struct_map_dtls(p_map_id  NUMBER
    , p1_a0 JTF_NUMBER_TABLE
    , p1_a1 JTF_VARCHAR2_TABLE_100
    , p1_a2 JTF_VARCHAR2_TABLE_100
    , p_init_msg_list  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;

Line: 235

    hz_geo_struct_map_pub.update_geo_struct_map_dtls(p_map_id,
      ddp_geo_struct_map_dtl_tbl,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data);