DBA Data[Home] [Help]

APPS.VEA_LAYER_HEADERS_SV dependencies on VEA_LAYERS

Line 141: UPDATE vea_layers

137: THEN
138: --{
139: l_location := '0020';
140: --
141: UPDATE vea_layers
142: SET layer_header_id = p_layer_header_id
143: WHERE p_layer_provider_code = p_layer_provider_code
144: AND p_layer_header_id = p_old_layer_header_id;
145: --}

Line 150: vea_layers_sv.delete_rows

146: END IF;
147: --
148: --
149: /*
150: vea_layers_sv.delete_rows
151: (
152: p_layer_provider_code => p_layer_provider_code,
153: p_layer_header_id => p_layer_header_id
154: );

Line 249: FROM vea_layers_v

245: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
246: )
247: IS
248: SELECT distinct layer_header_id
249: FROM vea_layers_v
250: WHERE layer_provider_code = p_layer_provider_code
251: AND tp_layer_id = p_tp_layer_id;
252: --
253: --

Line 333: vea_layers_sv.delete_rows

329: ELSE
330: --{
331: l_location := '0080';
332: --
333: vea_layers_sv.delete_rows
334: (
335: p_layer_provider_code => p_layer_provider_code,
336: p_layer_header_id => layer_header_rec.layer_header_id,
337: p_tp_layer_id => p_tp_layer_id,