DBA Data[Home] [Help]

APPS.CSF_LOCATIONS_PKG dependencies on CSF_EXT_LOCATIONS

Line 27: FROM csf_ext_locations

23: IS
24: CURSOR c
25: IS
26: SELECT csf_ext_location_id
27: FROM csf_ext_locations
28: WHERE location_id = p_location_id;
29: BEGIN
30: INSERT INTO csf_ext_locations
31: (csf_ext_location_id ,

Line 30: INSERT INTO csf_ext_locations

26: SELECT csf_ext_location_id
27: FROM csf_ext_locations
28: WHERE location_id = p_location_id;
29: BEGIN
30: INSERT INTO csf_ext_locations
31: (csf_ext_location_id ,
32: last_update_date ,
33: last_updated_by ,
34: creation_date ,

Line 121: FROM csf_ext_locations

117: override_flag ,
118: log_detail_short ,
119:
120: log_detail_long
121: FROM csf_ext_locations
122: WHERE location_id = p_location_id
123: FOR UPDATE OF location_id NOWAIT;
124: BEGIN
125: FOR tlinfo IN c1

Line 230: UPDATE csf_ext_locations

226: p_log_detail_long IN VARCHAR2
227: )
228: IS
229: BEGIN
230: UPDATE csf_ext_locations
231: SET csf_ext_location_id = p_csf_ext_location_id,
232: last_update_date = p_last_update_date,
233: last_updated_by = p_last_updated_by,
234: last_update_login = p_last_update_login,

Line 348: DELETE FROM csf_ext_locations

344:
345: PROCEDURE delete_row_ext (p_location_id IN NUMBER)
346: IS
347: BEGIN
348: DELETE FROM csf_ext_locations
349: WHERE location_id = p_location_id;
350:
351: IF (SQL%NOTFOUND)
352: THEN