APPS.VEA_RELEASE_DETAILS_SV dependencies on VEA_TP_LAYERS

Line 198: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;

194: --
195: l_location VARCHAR2(32767);
196: l_savepoint_name VARCHAR2(30);
197: l_layer_id vea_layers.layer_id%TYPE;
198: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
199: l_release_id vea_release_details.release_id%TYPE;
200: --
201: --
202: CURSOR layer_cur

Line 208: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE

204: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
205: p_release_id IN vea_release_details.release_id%TYPE,
206: p_file_name IN vea_release_details.file_name%TYPE,
207: p_application_short_name IN vea_release_details.application_short_name%TYPE,
208: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
209: )
210: IS
211: SELECT 1 layer_id,
212: release_id

Line 260: l_tp_layer_id := nvl(vea_tp_layers_sv.g_tp_layer_id,p_tp_layer_id);

256: g_release_id := p_release_id;
257: --
258: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN
259: --{
260: l_tp_layer_id := nvl(vea_tp_layers_sv.g_tp_layer_id,p_tp_layer_id);
261: --}
262: ELSE
263: --{
264: l_tp_layer_id := p_tp_layer_id;