1: PACKAGE VEA_LAYERS_SV AUTHID CURRENT_USER as
2: /* $Header: VEAVALAS.pls 115.9 2004/07/27 00:06:34 rvishnuv ship $ */
3: --{
4: /*====================== vea_layers_sv =========================*/
5: /*========================================================================
1: PACKAGE VEA_LAYERS_SV AUTHID CURRENT_USER as
2: /* $Header: VEAVALAS.pls 115.9 2004/07/27 00:06:34 rvishnuv ship $ */
3: --{
4: /*====================== vea_layers_sv =========================*/
5: /*========================================================================
6: PURPOSE:
7:
8: NOTES: To run the script:
47: IS RECORD
48: (
49: program_unit_id vea_program_units.program_unit_id%TYPE,
50: program_unit_name vea_program_units.name%TYPE,
51: layer_provider_code vea_layers.layer_provider_code%TYPE,
52: layer_header_id vea_layers.layer_header_id%TYPE,
53: layer_id vea_layers.layer_id%TYPE,
54: sequence_number vea_layers.sequence_number%TYPE,
55: execution_sequence vea_layers.execution_sequence%TYPE,
48: (
49: program_unit_id vea_program_units.program_unit_id%TYPE,
50: program_unit_name vea_program_units.name%TYPE,
51: layer_provider_code vea_layers.layer_provider_code%TYPE,
52: layer_header_id vea_layers.layer_header_id%TYPE,
53: layer_id vea_layers.layer_id%TYPE,
54: sequence_number vea_layers.sequence_number%TYPE,
55: execution_sequence vea_layers.execution_sequence%TYPE,
56: active_flag vea_layers.active_flag%TYPE,
49: program_unit_id vea_program_units.program_unit_id%TYPE,
50: program_unit_name vea_program_units.name%TYPE,
51: layer_provider_code vea_layers.layer_provider_code%TYPE,
52: layer_header_id vea_layers.layer_header_id%TYPE,
53: layer_id vea_layers.layer_id%TYPE,
54: sequence_number vea_layers.sequence_number%TYPE,
55: execution_sequence vea_layers.execution_sequence%TYPE,
56: active_flag vea_layers.active_flag%TYPE,
57: tps_parameter1_name vea_parameters.name%TYPE,
50: program_unit_name vea_program_units.name%TYPE,
51: layer_provider_code vea_layers.layer_provider_code%TYPE,
52: layer_header_id vea_layers.layer_header_id%TYPE,
53: layer_id vea_layers.layer_id%TYPE,
54: sequence_number vea_layers.sequence_number%TYPE,
55: execution_sequence vea_layers.execution_sequence%TYPE,
56: active_flag vea_layers.active_flag%TYPE,
57: tps_parameter1_name vea_parameters.name%TYPE,
58: tps_parameter1_value ece_xref_data.xref_int_value%TYPE,
51: layer_provider_code vea_layers.layer_provider_code%TYPE,
52: layer_header_id vea_layers.layer_header_id%TYPE,
53: layer_id vea_layers.layer_id%TYPE,
54: sequence_number vea_layers.sequence_number%TYPE,
55: execution_sequence vea_layers.execution_sequence%TYPE,
56: active_flag vea_layers.active_flag%TYPE,
57: tps_parameter1_name vea_parameters.name%TYPE,
58: tps_parameter1_value ece_xref_data.xref_int_value%TYPE,
59: tps_parameter2_name vea_parameters.name%TYPE,
52: layer_header_id vea_layers.layer_header_id%TYPE,
53: layer_id vea_layers.layer_id%TYPE,
54: sequence_number vea_layers.sequence_number%TYPE,
55: execution_sequence vea_layers.execution_sequence%TYPE,
56: active_flag vea_layers.active_flag%TYPE,
57: tps_parameter1_name vea_parameters.name%TYPE,
58: tps_parameter1_value ece_xref_data.xref_int_value%TYPE,
59: tps_parameter2_name vea_parameters.name%TYPE,
60: tps_parameter2_value ece_xref_data.xref_int_value%TYPE,
91: program_unit_id vea_program_units.program_unit_id%TYPE,
92: program_unit_lp_code vea_program_units.layer_provider_code%TYPE,
93: tp_layer_id vea_tp_layers.tp_layer_id%TYPE,
94: tp_layer_name vea_tp_layers.name%TYPE,
95: active_flag vea_layers.active_flag%TYPE
96: );
97: --
98: --
99: TYPE g_layer_active_tbl_type
120: --
121: PROCEDURE
122: delete_rows
123: (
124: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
125: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
126: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
127: x_layer_count OUT NOCOPY NUMBER
128: );
121: PROCEDURE
122: delete_rows
123: (
124: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
125: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
126: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
127: x_layer_count OUT NOCOPY NUMBER
128: );
129: --
131: PROCEDURE
132: processConflictingLayers
133: (
134: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE DEFAULT NULL,
135: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE DEFAULT NULL
136: );
137: --
138: --
139: PROCEDURE
138: --
139: PROCEDURE
140: populateLayerActiveTable
141: (
142: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE
143: );
144: --
145: --
146: PROCEDURE
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
157: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
158: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
159: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
157: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
158: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
159: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
157: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
158: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
159: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
162: p_description IN vea_layers.description%TYPE,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
157: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
158: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
159: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
162: p_description IN vea_layers.description%TYPE,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
156: x_id OUT NOCOPY vea_layers.layer_id%TYPE,
157: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
158: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
159: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
162: p_description IN vea_layers.description%TYPE,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
157: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
158: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
159: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
162: p_description IN vea_layers.description%TYPE,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
158: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
159: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
162: p_description IN vea_layers.description%TYPE,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
159: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
162: p_description IN vea_layers.description%TYPE,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
162: p_description IN vea_layers.description%TYPE,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
161: p_sequence_number IN vea_layers.sequence_number%TYPE,
162: p_description IN vea_layers.description%TYPE,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
162: p_description IN vea_layers.description%TYPE,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
163: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
181: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE DEFAULT NULL,
174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
181: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE DEFAULT NULL,
182: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE DEFAULT NULL,
175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
181: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE DEFAULT NULL,
182: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE DEFAULT NULL,
183: p_id IN vea_layers.layer_id%TYPE := NULL,
176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
181: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE DEFAULT NULL,
182: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE DEFAULT NULL,
183: p_id IN vea_layers.layer_id%TYPE := NULL,
184: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
181: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE DEFAULT NULL,
182: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE DEFAULT NULL,
183: p_id IN vea_layers.layer_id%TYPE := NULL,
184: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
185: p_tp_layer_name IN vea_tp_layers.name%TYPE DEFAULT NULL,
178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
181: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE DEFAULT NULL,
182: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE DEFAULT NULL,
183: p_id IN vea_layers.layer_id%TYPE := NULL,
184: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
185: p_tp_layer_name IN vea_tp_layers.name%TYPE DEFAULT NULL,
186: p_tps_parameter1_name IN vea_parameters.name%TYPE DEFAULT NULL,
179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
181: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE DEFAULT NULL,
182: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE DEFAULT NULL,
183: p_id IN vea_layers.layer_id%TYPE := NULL,
184: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
185: p_tp_layer_name IN vea_tp_layers.name%TYPE DEFAULT NULL,
186: p_tps_parameter1_name IN vea_parameters.name%TYPE DEFAULT NULL,
187: p_tps_parameter2_name IN vea_parameters.name%TYPE DEFAULT NULL,
202:
203: --
204: --
205: --}
206: END VEA_LAYERS_SV;