APPS.VEA_PROGRAM_UNITS_SV dependencies on VEA_LAYERS

Line 179: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

175: ========================================================================*/
176: PROCEDURE
177: delete_row
178: (
179: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
180: p_program_unit_id IN vea_program_units.program_unit_id%TYPE
181: )
182: IS
183: --{

Line 246: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

242: ========================================================================*/
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,

Line 261: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

257: --
258: --
259: CURSOR program_unit_cur
260: (
261: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
262: p_package_id IN vea_packages.package_id%TYPE
263: )
264: IS
265: SELECT program_unit_id,

Line 275: p_tps_program_unit_lp_code IN vea_layers.layer_provider_code%TYPE,

271: --
272: --
273: CURSOR tps_cur
274: (
275: p_tps_program_unit_lp_code IN vea_layers.layer_provider_code%TYPE,
276: p_tps_program_unit_id IN vea_program_units.program_unit_id%TYPE
277: )
278: IS
279: SELECT 'x'

Line 287: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

283: --
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: )

Line 298: vea_layers_v LA

294: FROM vea_program_units LPU,
295: vea_layer_headers LH,
296: vea_packages PK,
297: vea_program_units PU,
298: vea_layers_v LA
299: WHERE LA.layer_provider_code = p_layer_provider_code
300: AND LA.tp_layer_id = p_tp_layer_id
301: AND LH.layer_provider_code = LA.layer_provider_code
302: AND LH.layer_header_id = LA.layer_header_id