APPS.VEA_PROGRAM_UNITS_SV dependencies on VEA_TP_LAYERS

Line 247: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,

243: PROCEDURE
244: delete_rows
245: (
246: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
247: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
248: p_package_id IN vea_packages.package_id%TYPE,
249: p_application_short_name IN vea_packages.application_short_name%TYPE,
250: x_program_unit_count OUT NOCOPY NUMBER,
251: x_tps_program_unit_count OUT NOCOPY NUMBER

Line 288: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,

284: --
285: CURSOR application_cur
286: (
287: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
288: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
289: p_package_id IN vea_packages.package_id%TYPE,
290: p_program_unit_id IN vea_program_units.program_unit_id%TYPE
291: )
292: IS

Line 822: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL

818: p_return_type IN vea_program_units.return_type%TYPE,
819: p_tpa_program_unit_id IN vea_program_units.tpa_program_unit_id%TYPE,
820: p_description IN vea_program_units.description%TYPE,
821: p_id IN vea_program_units.program_unit_id%TYPE := NULL,
822: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
823: )
824: IS
825: --{
826: l_api_name CONSTANT VARCHAR2(30) := 'process';

Line 837: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;

833: l_program_unit_id vea_program_units.program_unit_id%TYPE;
834: l_db_tpa_program_unit_id vea_program_units.tpa_program_unit_id%TYPE;
835: l_tpa_program_unit_id vea_program_units.tpa_program_unit_id%TYPE;
836: l_package_id vea_packages.package_id%TYPE;
837: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
838: --
839: --
840: CURSOR program_unit_cur
841: (