APPS.CSF_LF_GEOPVT dependencies on CSF_GEO_BATCH_ADDRESS

Line 13: INSERT INTO csf_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(
14: ADDRESS1,
15: ADDRESS2,
16: ADDRESS3,
17: ADDRESS4,

Line 43: UPDATE csf_geo_batch_address SET

39: p_task_rec csf_task_address_pvt.task_rec_type
40: )
41: IS
42: BEGIN
43: UPDATE csf_geo_batch_address SET
44: ADDRESS1 = initcap(p_task_rec.address1),
45: ADDRESS2 = initcap(p_task_rec.address2),
46: ADDRESS3 = initcap(p_task_rec.address3),
47: ADDRESS4 = initcap(p_task_rec.address4),

Line 63: DELETE FROM csf_geo_batch_address

59:
60: PROCEDURE delete_valid_geo_batch_address
61: IS
62: BEGIN
63: DELETE FROM csf_geo_batch_address
64: WHERE ACCURACY >= fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
65: commit;
66: END;
67:

Line 75: SELECT count(*) into l_location_id FROM csf_geo_batch_address WHERE address_id = p_task_rec.location_id;

71: IS
72: l_location_id NUMBER;
73: BEGIN
74: l_location_id := 0;
75: SELECT count(*) into l_location_id FROM csf_geo_batch_address WHERE address_id = p_task_rec.location_id;
76: IF(l_location_id = 0)
77: THEN
78: insert_geo_batch_address(p_task_rec);
79: ELSIF(l_location_id = 1)