APPS.VEA_TP_LAYERS_SV dependencies on VEA_PACKAGES

Line 322: p_application_short_name IN vea_packages.application_short_name%TYPE

318: delete_rows
319: (
320: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
321: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
322: p_application_short_name IN vea_packages.application_short_name%TYPE
323: )
324: IS
325: --{
326: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';

Line 365: vea_packages_sv.delete_rows

361: --
362: --
363: l_location := '0040';
364: --
365: vea_packages_sv.delete_rows
366: (
367: p_layer_provider_code => p_layer_provider_code,
368: p_tp_layer_id => l_tp_layer_id,
369: p_application_short_name => p_application_short_name,

Line 431: p_application_short_name IN vea_packages.application_short_name%TYPE

427: (
428: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
429: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
430: p_tp_layer_name IN vea_tp_layers.name%TYPE,
431: p_application_short_name IN vea_packages.application_short_name%TYPE
432: )
433: IS
434: --{
435: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';

Line 592: FROM vea_packages

588: DELETE vea_tp_layers
589: WHERE layer_provider_code = p_layer_provider_code
590: AND tp_layer_id NOT IN (
591: SELECT tp_layer_id
592: FROM vea_packages
593: WHERE layer_provider_code = p_layer_provider_code
594: )
595: AND tp_layer_id NOT IN (
596: SELECT tp_layer_id