5: * Returns the address components like country, state, city,street
6: *and building after doing reverse geo coding.
7: */
8: PROCEDURE insert_geo_batch_address(
9: p_task_rec csf_task_address_pvt.task_rec_type
10: )
11: IS
12: BEGIN
13: INSERT INTO csf_geo_batch_address(
35: );
36: END;
37:
38: PROCEDURE update_geo_batch_address(
39: p_task_rec csf_task_address_pvt.task_rec_type
40: )
41: IS
42: BEGIN
43: UPDATE csf_geo_batch_address SET
65: commit;
66: END;
67:
68: PROCEDURE move_invalid_to_geo_batch(
69: p_task_rec csf_task_address_pvt.task_rec_type
70: )
71: IS
72: l_location_id NUMBER;
73: BEGIN