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 VEA_LAYERS_SV AUTHID CURRENT_USER as

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

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

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:

Line 51: layer_provider_code vea_layers.layer_provider_code%TYPE,

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,

Line 52: layer_header_id vea_layers.layer_header_id%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,

Line 53: layer_id vea_layers.layer_id%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,

Line 54: sequence_number vea_layers.sequence_number%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,

Line 55: execution_sequence vea_layers.execution_sequence%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,

Line 56: active_flag vea_layers.active_flag%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,

Line 95: active_flag vea_layers.active_flag%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

Line 124: p_layer_provider_code IN vea_layers.layer_provider_code%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: );

Line 125: p_layer_header_id IN vea_layers.layer_header_id%TYPE,

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

Line 135: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE DEFAULT NULL

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

Line 142: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE

138: --
139: PROCEDURE
140: populateLayerActiveTable
141: (
142: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE
143: );
144: --
145: --
146: PROCEDURE

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

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,

Line 157: p_layer_provider_code IN vea_layers.layer_provider_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,

Line 158: p_layer_header_id IN vea_layers.layer_header_id%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,

Line 159: p_new_program_unit_id IN vea_layers.new_program_unit_id%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,

Line 160: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%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,

Line 161: p_sequence_number IN vea_layers.sequence_number%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,

Line 162: p_description IN vea_layers.description%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,
166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,

Line 163: p_tps_parameter1_id IN vea_layers.tps_parameter1_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,
167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,

Line 164: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%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,
168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,

Line 165: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%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,

Line 166: p_tps_parameter2_value IN vea_layers.tps_parameter2_value%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,

Line 167: p_tps_parameter3_id IN vea_layers.tps_parameter3_id%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,

Line 168: p_tps_parameter3_value IN vea_layers.tps_parameter3_value%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,

Line 169: p_tps_parameter4_id IN vea_layers.tps_parameter4_id%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,

Line 170: p_tps_parameter4_value IN vea_layers.tps_parameter4_value%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,

Line 171: p_tps_parameter5_id IN vea_layers.tps_parameter5_id%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,

Line 172: p_tps_parameter5_value IN vea_layers.tps_parameter5_value%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,

Line 173: p_tps_parameter6_id IN vea_layers.tps_parameter6_id%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,

Line 174: p_tps_parameter6_value IN vea_layers.tps_parameter6_value%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,

Line 175: p_tps_parameter7_id IN vea_layers.tps_parameter7_id%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,

Line 176: p_tps_parameter7_value IN vea_layers.tps_parameter7_value%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,

Line 177: p_tps_parameter8_id IN vea_layers.tps_parameter8_id%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,

Line 178: p_tps_parameter8_value IN vea_layers.tps_parameter8_value%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,

Line 179: p_tps_parameter9_id IN vea_layers.tps_parameter9_id%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,

Line 180: p_tps_parameter9_value IN vea_layers.tps_parameter9_value%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,
184: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,

Line 181: p_tps_parameter10_id IN vea_layers.tps_parameter10_id%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,
185: p_tp_layer_name IN vea_tp_layers.name%TYPE DEFAULT NULL,

Line 182: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%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,

Line 183: p_id IN vea_layers.layer_id%TYPE := 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,

Line 206: END VEA_LAYERS_SV;

202:
203: --
204: --
205: --}
206: END VEA_LAYERS_SV;