DBA Data[Home] [Help]

APPS.VEA_PACKAGES_SV dependencies on VEA_TP_LAYERS

Line 759: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,

755: PROCEDURE
756: delete_rows
757: (
758: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
759: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
760: p_application_short_name IN vea_packages.application_short_name%TYPE,
761: x_package_count OUT NOCOPY NUMBER
762: )
763: IS

Line 776: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE

772: --
773: CURSOR package_cur
774: (
775: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
776: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
777: )
778: IS
779: SELECT package_id
780: FROM vea_packages

Line 1426: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;

1422: --
1423: l_location VARCHAR2(32767);
1424: l_savepoint_name VARCHAR2(30);
1425: l_package_id vea_packages.package_id%TYPE;
1426: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
1427: --
1428: --
1429: CURSOR package_cur
1430: (