eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.VEA_LAYERS_SV dependencies on VEA_LAYERS

Line 1: PACKAGE BODY VEA_LAYERS_SV as

1: PACKAGE BODY VEA_LAYERS_SV as
2: /* $Header: VEAVALAB.pls 115.15 2004/07/27 00:09:55 rvishnuv ship $ */
3: --{
4: /*====================== vea_layers_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_layers_sv =========================/

1: PACKAGE BODY VEA_LAYERS_SV as
2: /* $Header: VEAVALAB.pls 115.15 2004/07/27 00:09:55 rvishnuv ship $ */
3: --{
4: /*====================== vea_layers_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_LAYERS
7:
8: NOTES: To run the script:

Line 6: PURPOSE: Table handler package for table VEA_LAYERS

2: /* $Header: VEAVALAB.pls 115.15 2004/07/27 00:09:55 rvishnuv ship $ */
3: --{
4: /*====================== vea_layers_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_LAYERS
7:
8: NOTES: To run the script:
9:
10: sql> start VEAVALAB.pls

Line 33: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_LAYERS_SV';

29: processConflictingLayers
30:
31: =========================================================================*/
32:
33: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_LAYERS_SV';
34: --
35: --
36: /*========================================================================
37:

Line 46: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

42: ========================================================================*/
43: PROCEDURE
44: getParameterIntValue
45: (
46: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
47: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
48: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
49: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE,
50: p_tps_parameter_int_value IN OUT NOCOPY ece_xref_data.xref_int_value%TYPE,

Line 47: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

43: PROCEDURE
44: getParameterIntValue
45: (
46: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
47: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
48: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
49: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE,
50: p_tps_parameter_int_value IN OUT NOCOPY ece_xref_data.xref_int_value%TYPE,
51: p_tps_parameter_name IN OUT NOCOPY vea_parameters.name%TYPE

Line 48: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,

44: getParameterIntValue
45: (
46: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
47: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
48: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
49: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE,
50: p_tps_parameter_int_value IN OUT NOCOPY ece_xref_data.xref_int_value%TYPE,
51: p_tps_parameter_name IN OUT NOCOPY vea_parameters.name%TYPE
52: )

Line 49: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE,

45: (
46: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
47: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
48: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
49: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE,
50: p_tps_parameter_int_value IN OUT NOCOPY ece_xref_data.xref_int_value%TYPE,
51: p_tps_parameter_name IN OUT NOCOPY vea_parameters.name%TYPE
52: )
53: IS

Line 60: ( p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

56: l_location VARCHAR2(32767);
57: --
58: --
59: CURSOR parameter_cur
60: ( p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
61: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
62: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE)
63: IS
64: SELECT PA.name

Line 61: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

57: --
58: --
59: CURSOR parameter_cur
60: ( p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
61: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
62: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE)
63: IS
64: SELECT PA.name
65: FROM vea_parameters PA,

Line 62: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE)

58: --
59: CURSOR parameter_cur
60: ( p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
61: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
62: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE)
63: IS
64: SELECT PA.name
65: FROM vea_parameters PA,
66: vea_program_units PU,

Line 143: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

139: ========================================================================*/
140: PROCEDURE
141: saveBranchToGlobal(
142: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
143: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
144: p_layer_id IN vea_layers.layer_id%TYPE,
145: p_sequence_number IN vea_layers.sequence_number%TYPE,
146: p_tps_parameter1_name IN vea_parameters.name%TYPE,
147: p_tps_parameter1_int_value IN ece_xref_data.xref_int_value%TYPE,

Line 144: p_layer_id IN vea_layers.layer_id%TYPE,

140: PROCEDURE
141: saveBranchToGlobal(
142: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
143: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
144: p_layer_id IN vea_layers.layer_id%TYPE,
145: p_sequence_number IN vea_layers.sequence_number%TYPE,
146: p_tps_parameter1_name IN vea_parameters.name%TYPE,
147: p_tps_parameter1_int_value IN ece_xref_data.xref_int_value%TYPE,
148: p_tps_parameter2_name IN vea_parameters.name%TYPE,

Line 145: p_sequence_number IN vea_layers.sequence_number%TYPE,

141: saveBranchToGlobal(
142: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
143: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
144: p_layer_id IN vea_layers.layer_id%TYPE,
145: p_sequence_number IN vea_layers.sequence_number%TYPE,
146: p_tps_parameter1_name IN vea_parameters.name%TYPE,
147: p_tps_parameter1_int_value IN ece_xref_data.xref_int_value%TYPE,
148: p_tps_parameter2_name IN vea_parameters.name%TYPE,
149: p_tps_parameter2_int_value IN ece_xref_data.xref_int_value%TYPE,

Line 304: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

300:
301: ========================================================================*/
302: PROCEDURE
303: saveBranchCriteria (
304: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
305: p_layer_id IN vea_layers.layer_id%TYPE,
306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,

Line 305: p_layer_id IN vea_layers.layer_id%TYPE,

301: ========================================================================*/
302: PROCEDURE
303: saveBranchCriteria (
304: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
305: p_layer_id IN vea_layers.layer_id%TYPE,
306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

Line 306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

302: PROCEDURE
303: saveBranchCriteria (
304: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
305: p_layer_id IN vea_layers.layer_id%TYPE,
306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

Line 307: p_sequence_number IN vea_layers.sequence_number%TYPE,

303: saveBranchCriteria (
304: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
305: p_layer_id IN vea_layers.layer_id%TYPE,
306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

Line 308: p_active_flag IN vea_layers.active_flag%TYPE,

304: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
305: p_layer_id IN vea_layers.layer_id%TYPE,
306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

Line 309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

305: p_layer_id IN vea_layers.layer_id%TYPE,
306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

Line 310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

Line 311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

Line 312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

Line 313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

Line 314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

Line 315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

Line 316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

312: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

Line 317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

313: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

Line 318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

314: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

Line 319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

315: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

Line 320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

316: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

Line 321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

317: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

Line 322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

318: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
326: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

Line 323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

319: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
326: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
327: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

Line 324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

320: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
326: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
327: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
328: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

Line 325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

321: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
326: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
327: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
328: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
329: )

Line 326: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

322: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
326: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
327: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
328: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
329: )
330: IS

Line 327: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

323: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
326: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
327: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
328: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
329: )
330: IS
331: --{

Line 328: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

324: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
325: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
326: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
327: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
328: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
329: )
330: IS
331: --{
332: l_api_name CONSTANT VARCHAR2(30) := 'saveBranchCriteria';

Line 1314: l_layer_id vea_layers.layer_id%TYPE ;

1310: --
1311: l_curr_index BINARY_INTEGER;
1312: l_cmpr_index BINARY_INTEGER;
1313: l_layer_count NUMBER := 0;
1314: l_layer_id vea_layers.layer_id%TYPE ;
1315: --
1316: --
1317: --
1318: --

Line 1333: UPDATE VEA_LAYERS

1329: l_layer_id := g_layer_branch_tbl(l_curr_index).layer_id;
1330:
1331: IF ( p_chkMultipleLayerProviders ) THEN
1332:
1333: UPDATE VEA_LAYERS
1334: SET execution_sequence = g_layer_branch_tbl(l_curr_index).execution_sequence,
1335: active_flag = nvl(g_layer_branch_tbl(l_curr_index).active_flag, active_flag)
1336: WHERE layer_id = l_layer_id
1337: AND layer_provider_code = g_layer_branch_tbl(l_curr_index).layer_provider_code;

Line 1341: UPDATE VEA_LAYERS

1337: AND layer_provider_code = g_layer_branch_tbl(l_curr_index).layer_provider_code;
1338: --
1339: --
1340: ELSE
1341: UPDATE VEA_LAYERS
1342: SET execution_sequence = g_layer_branch_tbl(l_curr_index).sequence_number
1343: WHERE layer_id = l_layer_id
1344: AND layer_provider_code = g_layer_branch_tbl(l_curr_index).layer_provider_code;
1345: --

Line 1375: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE

1371: PROCEDURE
1372: processConflictingLayers
1373: (
1374: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE ,
1375: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE
1376: )
1377: IS
1378: --{
1379: l_api_name CONSTANT VARCHAR2(30) := 'processConflictingLayers';

Line 1408: vea_layers_v LV

1404: PK.layer_provider_code
1405: FROM vea_program_units PU,
1406: vea_packages PK,
1407: vea_layer_headers LH,
1408: vea_layers_v LV
1409: WHERE PU.tps_flag = 'N'
1410: AND PU.layer_provider_code = PK.layer_provider_code
1411: AND PU.package_id = PK.package_id
1412: AND PU.layer_provider_code = LH.program_unit_lp_code

Line 1454: FROM vea_layers LA,

1450: LA.tps_parameter9_id,
1451: LA.tps_parameter9_value,
1452: LA.tps_parameter10_id,
1453: LA.tps_parameter10_value
1454: FROM vea_layers LA,
1455: vea_layer_headers LH,
1456: vea_program_units PU,
1457: vea_packages PK
1458: WHERE PK.package_id = p_package_id

Line 1491: FROM vea_layers LA,

1487: l_chkMultipleLayerProviders := FALSE;
1488:
1489: SELECT count(distinct LA.layer_provider_code)
1490: INTO l_lp_count
1491: FROM vea_layers LA,
1492: vea_layer_headers LH,
1493: vea_program_units PU,
1494: vea_packages PK
1495: WHERE PK.package_id = l_package_id

Line 1595: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

1591: ========================================================================*/
1592: PROCEDURE
1593: validateUniqueBranchSequence
1594: (
1595: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1596: p_layer_id IN vea_layers.layer_id%TYPE,
1597: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1598: p_sequence_number IN vea_layers.sequence_number%TYPE
1599: )

Line 1596: p_layer_id IN vea_layers.layer_id%TYPE,

1592: PROCEDURE
1593: validateUniqueBranchSequence
1594: (
1595: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1596: p_layer_id IN vea_layers.layer_id%TYPE,
1597: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1598: p_sequence_number IN vea_layers.sequence_number%TYPE
1599: )
1600: IS

Line 1597: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

1593: validateUniqueBranchSequence
1594: (
1595: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1596: p_layer_id IN vea_layers.layer_id%TYPE,
1597: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1598: p_sequence_number IN vea_layers.sequence_number%TYPE
1599: )
1600: IS
1601: --{

Line 1598: p_sequence_number IN vea_layers.sequence_number%TYPE

1594: (
1595: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1596: p_layer_id IN vea_layers.layer_id%TYPE,
1597: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1598: p_sequence_number IN vea_layers.sequence_number%TYPE
1599: )
1600: IS
1601: --{
1602: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueBranchSequence';

Line 1620: vea_layers LA,

1616: FROM vea_layer_headers LH,
1617: vea_program_units TPA,
1618: vea_packages PK,
1619: vea_program_units PU,
1620: vea_layers LA,
1621: vea_layer_headers LH1
1622: WHERE LH.layer_provider_code = p_layer_provider_code
1623: AND LH.layer_header_id = p_layer_header_id
1624: AND TPA.layer_provider_code = LH.program_unit_lp_code

Line 1689: PURPOSE: Validates a record in VEA_LAYERS table

1685: /*========================================================================
1686:
1687: PROCEDURE NAME: validate
1688:
1689: PURPOSE: Validates a record in VEA_LAYERS table
1690:
1691: ========================================================================*/
1692: PROCEDURE
1693: validate

Line 1695: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

1691: ========================================================================*/
1692: PROCEDURE
1693: validate
1694: (
1695: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1696: p_layer_id IN vea_layers.layer_id%TYPE,
1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,

Line 1696: p_layer_id IN vea_layers.layer_id%TYPE,

1692: PROCEDURE
1693: validate
1694: (
1695: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1696: p_layer_id IN vea_layers.layer_id%TYPE,
1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,

Line 1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

1693: validate
1694: (
1695: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1696: p_layer_id IN vea_layers.layer_id%TYPE,
1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,

Line 1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,

1694: (
1695: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1696: p_layer_id IN vea_layers.layer_id%TYPE,
1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,

Line 1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,

1695: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1696: p_layer_id IN vea_layers.layer_id%TYPE,
1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

Line 1700: p_sequence_number IN vea_layers.sequence_number%TYPE,

1696: p_layer_id IN vea_layers.layer_id%TYPE,
1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

Line 1701: p_description IN vea_layers.description%TYPE,

1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

Line 1702: p_active_flag IN vea_layers.active_flag%TYPE,

1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

Line 1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

Line 1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

Line 1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

Line 1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

Line 1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

Line 1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

Line 1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

1705: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

Line 1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

1706: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

Line 1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

1707: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

Line 1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

1708: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

Line 1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

1709: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

Line 1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

1710: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

Line 1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

1711: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

Line 1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

1712: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1720: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

Line 1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

1713: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1720: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1721: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

Line 1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

1714: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1720: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1721: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1722: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

Line 1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

1715: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1720: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1721: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1722: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1723: )

Line 1720: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

1716: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1720: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1721: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1722: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1723: )
1724: IS

Line 1721: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

1717: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1720: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1721: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1722: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1723: )
1724: IS
1725: --{

Line 1722: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

1718: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1719: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1720: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1721: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1722: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1723: )
1724: IS
1725: --{
1726: l_api_name CONSTANT VARCHAR2(30) := 'validate';

Line 1779: PURPOSE: Inserts a record into VEA_LAYERS table

1775: /*========================================================================
1776:
1777: PROCEDURE NAME: insert_row
1778:
1779: PURPOSE: Inserts a record into VEA_LAYERS table
1780:
1781: ========================================================================*/
1782: PROCEDURE
1783: insert_row

Line 1785: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

1781: ========================================================================*/
1782: PROCEDURE
1783: insert_row
1784: (
1785: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1786: p_layer_id IN vea_layers.layer_id%TYPE,
1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,

Line 1786: p_layer_id IN vea_layers.layer_id%TYPE,

1782: PROCEDURE
1783: insert_row
1784: (
1785: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1786: p_layer_id IN vea_layers.layer_id%TYPE,
1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,

Line 1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

1783: insert_row
1784: (
1785: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1786: p_layer_id IN vea_layers.layer_id%TYPE,
1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,

Line 1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,

1784: (
1785: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1786: p_layer_id IN vea_layers.layer_id%TYPE,
1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,

Line 1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,

1785: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1786: p_layer_id IN vea_layers.layer_id%TYPE,
1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

Line 1790: p_sequence_number IN vea_layers.sequence_number%TYPE,

1786: p_layer_id IN vea_layers.layer_id%TYPE,
1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

Line 1791: p_description IN vea_layers.description%TYPE,

1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

Line 1792: p_active_flag IN vea_layers.active_flag%TYPE,

1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

Line 1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

Line 1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

Line 1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

Line 1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

Line 1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

Line 1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

Line 1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

1795: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

Line 1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

1796: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

Line 1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

1797: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

Line 1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

1798: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

Line 1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

1799: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

Line 1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

1800: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

Line 1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

1801: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

Line 1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

1802: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1810: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

Line 1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

1803: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1810: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1811: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

Line 1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

1804: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1810: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1811: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1812: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

Line 1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

1805: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1810: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1811: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1812: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1813: )

Line 1810: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

1806: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1810: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1811: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1812: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1813: )
1814: IS

Line 1811: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

1807: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1810: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1811: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1812: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1813: )
1814: IS
1815: --{

Line 1812: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

1808: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1809: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1810: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1811: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1812: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1813: )
1814: IS
1815: --{
1816: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 1827: INSERT INTO vea_layers

1823: BEGIN
1824: --{
1825: l_location := '0010';
1826: --
1827: INSERT INTO vea_layers
1828: (
1829: layer_provider_code, layer_id,
1830: layer_header_id,
1831: new_program_unit_id, program_unit_lp_code,

Line 1892: PURPOSE: Updates a record into VEA_LAYERS table

1888: /*========================================================================
1889:
1890: PROCEDURE NAME: update_row
1891:
1892: PURPOSE: Updates a record into VEA_LAYERS table
1893:
1894: ========================================================================*/
1895: PROCEDURE
1896: update_row

Line 1898: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

1894: ========================================================================*/
1895: PROCEDURE
1896: update_row
1897: (
1898: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1899: p_layer_id IN vea_layers.layer_id%TYPE,
1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,

Line 1899: p_layer_id IN vea_layers.layer_id%TYPE,

1895: PROCEDURE
1896: update_row
1897: (
1898: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1899: p_layer_id IN vea_layers.layer_id%TYPE,
1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,

Line 1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

1896: update_row
1897: (
1898: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1899: p_layer_id IN vea_layers.layer_id%TYPE,
1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,

Line 1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,

1897: (
1898: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1899: p_layer_id IN vea_layers.layer_id%TYPE,
1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,

Line 1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,

1898: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1899: p_layer_id IN vea_layers.layer_id%TYPE,
1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

Line 1903: p_sequence_number IN vea_layers.sequence_number%TYPE,

1899: p_layer_id IN vea_layers.layer_id%TYPE,
1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

Line 1904: p_description IN vea_layers.description%TYPE,

1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

Line 1905: p_active_flag IN vea_layers.active_flag%TYPE,

1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

Line 1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

Line 1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

Line 1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

Line 1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

Line 1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

Line 1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

Line 1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

1908: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

Line 1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

1909: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

Line 1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

1910: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

Line 1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

1911: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

Line 1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

1912: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

Line 1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

1913: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

Line 1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

1914: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

Line 1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

1915: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1923: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

Line 1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

1916: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1923: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1924: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

Line 1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

1917: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1923: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1924: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1925: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

Line 1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

1918: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1923: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1924: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1925: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1926: )

Line 1923: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

1919: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1923: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1924: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1925: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1926: )
1927: IS

Line 1924: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

1920: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1923: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1924: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1925: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1926: )
1927: IS
1928: --{

Line 1925: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

1921: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
1922: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
1923: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
1924: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
1925: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
1926: )
1927: IS
1928: --{
1929: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 1940: UPDATE vea_layers

1936: BEGIN
1937: --{
1938: l_location := '0010';
1939: --
1940: UPDATE vea_layers
1941: SET new_program_unit_id = p_new_program_unit_id,
1942: program_unit_lp_code = p_program_unit_lp_code,
1943: layer_header_id = p_layer_header_id,
1944: sequence_number = p_sequence_number,

Line 2000: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

1996: ========================================================================*/
1997: PROCEDURE
1998: delete_row
1999: (
2000: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2001: p_layer_id IN vea_layers.layer_id%TYPE
2002: )
2003: IS
2004: --{

Line 2001: p_layer_id IN vea_layers.layer_id%TYPE

1997: PROCEDURE
1998: delete_row
1999: (
2000: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2001: p_layer_id IN vea_layers.layer_id%TYPE
2002: )
2003: IS
2004: --{
2005: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';

Line 2014: DELETE vea_layers

2010: BEGIN
2011: --{
2012: l_location := '0010';
2013: --
2014: DELETE vea_layers
2015: WHERE layer_provider_code = p_layer_provider_code
2016: AND layer_id = p_layer_id;
2017: --}
2018: EXCEPTION

Line 2045: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

2041: ========================================================================*/
2042: PROCEDURE
2043: delete_rows
2044: (
2045: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2046: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2047: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
2048: x_layer_count OUT NOCOPY NUMBER
2049: )

Line 2046: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

2042: PROCEDURE
2043: delete_rows
2044: (
2045: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2046: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2047: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
2048: x_layer_count OUT NOCOPY NUMBER
2049: )
2050: IS

Line 2058: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

2054: --
2055: --
2056: CURSOR layer_cur
2057: (
2058: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2059: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2060: )
2061: IS
2062: SELECT layer_id, tp_layer_id

Line 2059: p_layer_header_id IN vea_layers.layer_header_id%TYPE

2055: --
2056: CURSOR layer_cur
2057: (
2058: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2059: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2060: )
2061: IS
2062: SELECT layer_id, tp_layer_id
2063: FROM vea_layers_v

Line 2063: FROM vea_layers_v

2059: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2060: )
2061: IS
2062: SELECT layer_id, tp_layer_id
2063: FROM vea_layers_v
2064: WHERE layer_provider_code = p_layer_provider_code
2065: AND layer_header_id = p_layer_header_id;
2066: --
2067: --

Line 2148: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE

2144: ========================================================================*/
2145: PROCEDURE
2146: populateLayerActiveTable
2147: (
2148: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE
2149: )
2150: IS
2151: --{
2152: l_api_name CONSTANT VARCHAR2(30) := 'populateLayerActiveTable';

Line 2164: FROM vea_layers_v LA,

2160: PU.layer_provider_code,
2161: LA.tp_layer_id,
2162: LA.tp_layer_name,
2163: LA.active_flag
2164: FROM vea_layers_v LA,
2165: vea_layer_headers LH,
2166: vea_program_units PU
2167: WHERE LA.layer_provider_code = p_layer_provider_code
2168: AND LH.layer_provider_code = LA.layer_provider_code

Line 2222: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

2218: ========================================================================*/
2219: FUNCTION
2220: isLayerActive
2221: (
2222: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2223: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
2224: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2225: )
2226: RETURN VARCHAR2

Line 2224: p_layer_header_id IN vea_layers.layer_header_id%TYPE

2220: isLayerActive
2221: (
2222: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2223: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
2224: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2225: )
2226: RETURN VARCHAR2
2227: IS
2228: --{

Line 2266: l_index := vea_layers_sv.g_layer_active_tbl.FIRST;

2262: LOOP
2263: --{
2264: l_location := '0020';
2265: --
2266: l_index := vea_layers_sv.g_layer_active_tbl.FIRST;
2267: --
2268: --
2269: l_location := '0030';
2270: --

Line 2276: l_layer_active_rec := vea_layers_sv.g_layer_active_tbl(l_index);

2272: LOOP
2273: --{
2274: l_location := '0040';
2275: --
2276: l_layer_active_rec := vea_layers_sv.g_layer_active_tbl(l_index);
2277: --
2278: --
2279: l_location := '0050';
2280: --

Line 2299: l_index := vea_layers_sv.g_layer_active_tbl.NEXT(l_index);

2295: --
2296: --
2297: l_location := '0060';
2298: --
2299: l_index := vea_layers_sv.g_layer_active_tbl.NEXT(l_index);
2300: --}
2301: END LOOP;
2302: --}
2303: END LOOP;

Line 2342: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

2338: ========================================================================*/
2339: PROCEDURE
2340: process_code_conversion
2341: (
2342: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2343: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2344: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

Line 2343: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

2339: PROCEDURE
2340: process_code_conversion
2341: (
2342: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2343: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2344: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

Line 2344: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

2340: process_code_conversion
2341: (
2342: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2343: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2344: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

Line 2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

2341: (
2342: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2343: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2344: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

Line 2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

2342: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2343: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2344: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

Line 2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,

2343: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2344: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

Line 2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,

2344: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

Line 2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,

2345: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

Line 2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,

2346: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,
2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

Line 2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,

2347: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE,
2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

Line 2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,

2348: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE,
2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

Line 2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,

2349: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE,
2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

Line 2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,

2350: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE,
2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

Line 2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,

2351: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE,
2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

Line 2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,

2352: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE,
2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

Line 2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,

2353: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE,
2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
2361: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

Line 2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,

2354: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE,
2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
2361: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
2362: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

Line 2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,

2355: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE,
2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
2361: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
2362: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
2363: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

Line 2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,

2356: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE,
2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
2361: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
2362: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
2363: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
2364: )

Line 2361: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,

2357: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE,
2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
2361: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
2362: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
2363: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
2364: )
2365: IS

Line 2362: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,

2358: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE,
2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
2361: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
2362: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
2363: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
2364: )
2365: IS
2366: --{

Line 2363: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE

2359: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE,
2360: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE,
2361: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE,
2362: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE,
2363: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE
2364: )
2365: IS
2366: --{
2367: l_api_name CONSTANT VARCHAR2(30) := 'process_code_conversion';

Line 2505: PURPOSE: Table hadndler API for VEA_LAYERS table.

2501: /*========================================================================
2502:
2503: PROCEDURE NAME: process
2504:
2505: PURPOSE: Table hadndler API for VEA_LAYERS table.
2506:
2507: It inserts/updates a record in VEA_LAYERS table.
2508:
2509: ========================================================================*/

Line 2507: It inserts/updates a record in VEA_LAYERS table.

2503: PROCEDURE NAME: process
2504:
2505: PURPOSE: Table hadndler API for VEA_LAYERS table.
2506:
2507: It inserts/updates a record in VEA_LAYERS table.
2508:
2509: ========================================================================*/
2510: PROCEDURE
2511: process

Line 2520: x_id OUT NOCOPY vea_layers.layer_id%TYPE,

2516: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2517: x_return_status OUT NOCOPY VARCHAR2,
2518: x_msg_count OUT NOCOPY NUMBER,
2519: x_msg_data OUT NOCOPY VARCHAR2,
2520: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
2521: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,

Line 2521: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

2517: x_return_status OUT NOCOPY VARCHAR2,
2518: x_msg_count OUT NOCOPY NUMBER,
2519: x_msg_data OUT NOCOPY VARCHAR2,
2520: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
2521: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,

Line 2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

2518: x_msg_count OUT NOCOPY NUMBER,
2519: x_msg_data OUT NOCOPY VARCHAR2,
2520: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
2521: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,

Line 2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,

2519: x_msg_data OUT NOCOPY VARCHAR2,
2520: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
2521: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

Line 2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,

2520: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
2521: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

Line 2525: p_sequence_number IN vea_layers.sequence_number%TYPE,

2521: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,

Line 2526: p_description IN vea_layers.description%TYPE,

2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,

Line 2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,

2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,

Line 2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,

Line 2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,

2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,

Line 2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,

2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,

Line 2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,

2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,

Line 2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,

2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,

Line 2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,

2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,
2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,

Line 2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,

2530: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE ,
2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,

Line 2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,

2531: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE ,
2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,

Line 2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,

2532: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE ,
2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,

Line 2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,

2533: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE ,
2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,

Line 2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,

2534: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE ,
2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,

Line 2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,

2535: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE ,
2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,

Line 2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,

2536: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE ,
2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,

Line 2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,

2537: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE ,
2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,
2545: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,

Line 2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,

2538: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE ,
2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,
2545: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,
2546: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,

Line 2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,

2539: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE ,
2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,
2545: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,
2546: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,
2547: p_id IN vea_layers.layer_id%TYPE := NULL,

Line 2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,

2540: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE ,
2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,
2545: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,
2546: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,
2547: p_id IN vea_layers.layer_id%TYPE := NULL,
2548: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,

Line 2545: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,

2541: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE ,
2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,
2545: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,
2546: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,
2547: p_id IN vea_layers.layer_id%TYPE := NULL,
2548: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
2549: p_tp_layer_name IN vea_tp_layers.name%TYPE,

Line 2546: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,

2542: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE ,
2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,
2545: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,
2546: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,
2547: p_id IN vea_layers.layer_id%TYPE := NULL,
2548: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
2549: p_tp_layer_name IN vea_tp_layers.name%TYPE,
2550: p_tps_parameter1_name IN vea_parameters.name%TYPE,

Line 2547: p_id IN vea_layers.layer_id%TYPE := NULL,

2543: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE ,
2544: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE ,
2545: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE ,
2546: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,
2547: p_id IN vea_layers.layer_id%TYPE := NULL,
2548: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
2549: p_tp_layer_name IN vea_tp_layers.name%TYPE,
2550: p_tps_parameter1_name IN vea_parameters.name%TYPE,
2551: p_tps_parameter2_name IN vea_parameters.name%TYPE,

Line 2570: l_layer_id vea_layers.layer_id%TYPE;

2566: --
2567: --
2568: l_location VARCHAR2(32767);
2569: l_savepoint_name VARCHAR2(30);
2570: l_layer_id vea_layers.layer_id%TYPE;
2571: l_active_flag vea_layers.active_flag%TYPE;
2572: l_layer_header_id vea_layers.layer_header_id%TYPE;
2573: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;

Line 2571: l_active_flag vea_layers.active_flag%TYPE;

2567: --
2568: l_location VARCHAR2(32767);
2569: l_savepoint_name VARCHAR2(30);
2570: l_layer_id vea_layers.layer_id%TYPE;
2571: l_active_flag vea_layers.active_flag%TYPE;
2572: l_layer_header_id vea_layers.layer_header_id%TYPE;
2573: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;
2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;

Line 2572: l_layer_header_id vea_layers.layer_header_id%TYPE;

2568: l_location VARCHAR2(32767);
2569: l_savepoint_name VARCHAR2(30);
2570: l_layer_id vea_layers.layer_id%TYPE;
2571: l_active_flag vea_layers.active_flag%TYPE;
2572: l_layer_header_id vea_layers.layer_header_id%TYPE;
2573: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;
2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;
2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;

Line 2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;

2571: l_active_flag vea_layers.active_flag%TYPE;
2572: l_layer_header_id vea_layers.layer_header_id%TYPE;
2573: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;
2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;
2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;
2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;
2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;
2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;

Line 2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;

2572: l_layer_header_id vea_layers.layer_header_id%TYPE;
2573: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;
2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;
2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;
2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;
2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;
2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;
2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;

Line 2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;

2573: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;
2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;
2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;
2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;
2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;
2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;
2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;
2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;

Line 2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;

2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;
2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;
2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;
2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;
2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;
2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;
2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;
2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;
2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;

Line 2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;

2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;
2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;
2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;
2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;
2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;
2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;
2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;
2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;
2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;

Line 2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;

2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;
2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;
2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;
2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;
2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;
2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;
2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;
2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;
2584: l_tps_parameter10_id vea_layers.tps_parameter10_id%TYPE;

Line 2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;

2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;
2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;
2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;
2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;
2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;
2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;
2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;
2584: l_tps_parameter10_id vea_layers.tps_parameter10_id%TYPE;
2585: l_tps_program_unit_id vea_layer_headers.tps_program_unit_id%TYPE;

Line 2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;

2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;
2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;
2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;
2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;
2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;
2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;
2584: l_tps_parameter10_id vea_layers.tps_parameter10_id%TYPE;
2585: l_tps_program_unit_id vea_layer_headers.tps_program_unit_id%TYPE;
2586: l_tps_program_unit_lp_code vea_layer_headers.tps_program_unit_lp_code%TYPE;

Line 2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;

2579: l_tps_parameter5_id vea_layers.tps_parameter5_id%TYPE;
2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;
2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;
2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;
2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;
2584: l_tps_parameter10_id vea_layers.tps_parameter10_id%TYPE;
2585: l_tps_program_unit_id vea_layer_headers.tps_program_unit_id%TYPE;
2586: l_tps_program_unit_lp_code vea_layer_headers.tps_program_unit_lp_code%TYPE;
2587: --

Line 2584: l_tps_parameter10_id vea_layers.tps_parameter10_id%TYPE;

2580: l_tps_parameter6_id vea_layers.tps_parameter6_id%TYPE;
2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;
2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;
2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;
2584: l_tps_parameter10_id vea_layers.tps_parameter10_id%TYPE;
2585: l_tps_program_unit_id vea_layer_headers.tps_program_unit_id%TYPE;
2586: l_tps_program_unit_lp_code vea_layer_headers.tps_program_unit_lp_code%TYPE;
2587: --
2588: --

Line 2591: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

2587: --
2588: --
2589: CURSOR layer_cur
2590: (
2591: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2592: p_tp_layer_id IN vea_tp_layers.name%TYPE,
2593: p_new_program_unit_id IN vea_program_units.name%TYPE
2594: )
2595: IS

Line 2597: FROM vea_layers LA,

2593: p_new_program_unit_id IN vea_program_units.name%TYPE
2594: )
2595: IS
2596: SELECT LA.LAYER_ID LAYER_ID
2597: FROM vea_layers LA,
2598: VEA_TP_LAYERS TL,
2599: VEA_PROGRAM_UNITS PU,
2600: VEA_PACKAGES PK
2601: WHERE TL.TP_LAYER_ID = p_tp_layer_id

Line 2614: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

2610:
2611: /*
2612: CURSOR layer_cur
2613: (
2614: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2615: p_layer_id IN vea_layers.layer_id%TYPE,
2616: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2617: )
2618: IS

Line 2615: p_layer_id IN vea_layers.layer_id%TYPE,

2611: /*
2612: CURSOR layer_cur
2613: (
2614: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2615: p_layer_id IN vea_layers.layer_id%TYPE,
2616: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2617: )
2618: IS
2619: SELECT layer_id

Line 2616: p_layer_header_id IN vea_layers.layer_header_id%TYPE

2612: CURSOR layer_cur
2613: (
2614: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2615: p_layer_id IN vea_layers.layer_id%TYPE,
2616: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2617: )
2618: IS
2619: SELECT layer_id
2620: FROM vea_layers

Line 2620: FROM vea_layers

2616: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2617: )
2618: IS
2619: SELECT layer_id
2620: FROM vea_layers
2621: WHERE layer_provider_code = p_layer_provider_code
2622: AND layer_id = p_layer_id;
2623: */
2624: --AND layer_header_id = p_layer_header_id;

Line 3098: SELECT NVL( p_id, vea_layers_s.NEXTVAL )

3094: --
3095: --
3096: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
3097: THEN
3098: SELECT NVL( p_id, vea_layers_s.NEXTVAL )
3099: INTO l_layer_id
3100: FROM DUAL;
3101: ELSE
3102: SELECT vea_layers_s.NEXTVAL

Line 3102: SELECT vea_layers_s.NEXTVAL

3098: SELECT NVL( p_id, vea_layers_s.NEXTVAL )
3099: INTO l_layer_id
3100: FROM DUAL;
3101: ELSE
3102: SELECT vea_layers_s.NEXTVAL
3103: INTO l_layer_id
3104: FROM DUAL;
3105: END IF;
3106: --

Line 3327: END VEA_LAYERS_SV;

3323: --}
3324: --}
3325: END process;
3326: --}
3327: END VEA_LAYERS_SV;