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_PARAMETERS_SV dependencies on VEA_PARAMETERS

Line 1: PACKAGE BODY VEA_PARAMETERS_SV as

1: PACKAGE BODY VEA_PARAMETERS_SV as
2: /* $Header: VEAVAPAB.pls 115.12 2004/07/27 02:42:20 rvishnuv ship $ */
3: --{
4: /*====================== vea_parameters_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_parameters_sv =========================/

1: PACKAGE BODY VEA_PARAMETERS_SV as
2: /* $Header: VEAVAPAB.pls 115.12 2004/07/27 02:42:20 rvishnuv ship $ */
3: --{
4: /*====================== vea_parameters_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_PARAMETERS
7:
8: NOTES: To run the script:

Line 6: PURPOSE: Table handler package for table VEA_PARAMETERS

2: /* $Header: VEAVAPAB.pls 115.12 2004/07/27 02:42:20 rvishnuv ship $ */
3: --{
4: /*====================== vea_parameters_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_PARAMETERS
7:
8: NOTES: To run the script:
9:
10: sql> start VEAVAPKB.pls

Line 17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_PARAMETERS_SV';

13: Created N PARIKH 09/09/99 10:00 AM
14:
15: =========================================================================*/
16:
17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_PARAMETERS_SV';
18: --
19: --
20: /*========================================================================
21:

Line 24: PURPOSE: Inserts a record into VEA_PARAMETERS table

20: /*========================================================================
21:
22: PROCEDURE NAME: insert_row
23:
24: PURPOSE: Inserts a record into VEA_PARAMETERS table
25:
26: ========================================================================*/
27: PROCEDURE
28: insert_row

Line 30: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
31: p_parameter_id IN vea_parameters.parameter_id%TYPE,
32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
33: p_parameter_type IN vea_parameters.parameter_type%TYPE,
34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,

Line 31: p_parameter_id IN vea_parameters.parameter_id%TYPE,

27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
31: p_parameter_id IN vea_parameters.parameter_id%TYPE,
32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
33: p_parameter_type IN vea_parameters.parameter_type%TYPE,
34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
35: p_name IN vea_parameters.name%TYPE,

Line 32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,

28: insert_row
29: (
30: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
31: p_parameter_id IN vea_parameters.parameter_id%TYPE,
32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
33: p_parameter_type IN vea_parameters.parameter_type%TYPE,
34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
35: p_name IN vea_parameters.name%TYPE,
36: p_datatype IN vea_parameters.datatype%TYPE,

Line 33: p_parameter_type IN vea_parameters.parameter_type%TYPE,

29: (
30: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
31: p_parameter_id IN vea_parameters.parameter_id%TYPE,
32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
33: p_parameter_type IN vea_parameters.parameter_type%TYPE,
34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
35: p_name IN vea_parameters.name%TYPE,
36: p_datatype IN vea_parameters.datatype%TYPE,
37: p_default_value IN vea_parameters.default_value%TYPE,

Line 34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,

30: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
31: p_parameter_id IN vea_parameters.parameter_id%TYPE,
32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
33: p_parameter_type IN vea_parameters.parameter_type%TYPE,
34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
35: p_name IN vea_parameters.name%TYPE,
36: p_datatype IN vea_parameters.datatype%TYPE,
37: p_default_value IN vea_parameters.default_value%TYPE,
38: p_description IN vea_parameters.description%TYPE

Line 35: p_name IN vea_parameters.name%TYPE,

31: p_parameter_id IN vea_parameters.parameter_id%TYPE,
32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
33: p_parameter_type IN vea_parameters.parameter_type%TYPE,
34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
35: p_name IN vea_parameters.name%TYPE,
36: p_datatype IN vea_parameters.datatype%TYPE,
37: p_default_value IN vea_parameters.default_value%TYPE,
38: p_description IN vea_parameters.description%TYPE
39: )

Line 36: p_datatype IN vea_parameters.datatype%TYPE,

32: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
33: p_parameter_type IN vea_parameters.parameter_type%TYPE,
34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
35: p_name IN vea_parameters.name%TYPE,
36: p_datatype IN vea_parameters.datatype%TYPE,
37: p_default_value IN vea_parameters.default_value%TYPE,
38: p_description IN vea_parameters.description%TYPE
39: )
40: IS

Line 37: p_default_value IN vea_parameters.default_value%TYPE,

33: p_parameter_type IN vea_parameters.parameter_type%TYPE,
34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
35: p_name IN vea_parameters.name%TYPE,
36: p_datatype IN vea_parameters.datatype%TYPE,
37: p_default_value IN vea_parameters.default_value%TYPE,
38: p_description IN vea_parameters.description%TYPE
39: )
40: IS
41: --{

Line 38: p_description IN vea_parameters.description%TYPE

34: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
35: p_name IN vea_parameters.name%TYPE,
36: p_datatype IN vea_parameters.datatype%TYPE,
37: p_default_value IN vea_parameters.default_value%TYPE,
38: p_description IN vea_parameters.description%TYPE
39: )
40: IS
41: --{
42: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 53: INSERT INTO vea_parameters

49: BEGIN
50: --{
51: l_location := '0010';
52: --
53: INSERT INTO vea_parameters
54: (
55: layer_provider_code, parameter_id,
56: program_unit_id, parameter_type,
57: name, parameter_seq,

Line 96: PURPOSE: Updates a record into VEA_PARAMETERS table

92: /*========================================================================
93:
94: PROCEDURE NAME: update_row
95:
96: PURPOSE: Updates a record into VEA_PARAMETERS table
97:
98: ========================================================================*/
99: PROCEDURE
100: update_row

Line 102: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

98: ========================================================================*/
99: PROCEDURE
100: update_row
101: (
102: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
103: p_parameter_id IN vea_parameters.parameter_id%TYPE,
104: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
105: p_parameter_type IN vea_parameters.parameter_type%TYPE,
106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,

Line 103: p_parameter_id IN vea_parameters.parameter_id%TYPE,

99: PROCEDURE
100: update_row
101: (
102: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
103: p_parameter_id IN vea_parameters.parameter_id%TYPE,
104: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
105: p_parameter_type IN vea_parameters.parameter_type%TYPE,
106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
107: p_name IN vea_parameters.name%TYPE,

Line 104: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,

100: update_row
101: (
102: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
103: p_parameter_id IN vea_parameters.parameter_id%TYPE,
104: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
105: p_parameter_type IN vea_parameters.parameter_type%TYPE,
106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
107: p_name IN vea_parameters.name%TYPE,
108: p_datatype IN vea_parameters.datatype%TYPE,

Line 105: p_parameter_type IN vea_parameters.parameter_type%TYPE,

101: (
102: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
103: p_parameter_id IN vea_parameters.parameter_id%TYPE,
104: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
105: p_parameter_type IN vea_parameters.parameter_type%TYPE,
106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
107: p_name IN vea_parameters.name%TYPE,
108: p_datatype IN vea_parameters.datatype%TYPE,
109: p_default_value IN vea_parameters.default_value%TYPE,

Line 106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,

102: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
103: p_parameter_id IN vea_parameters.parameter_id%TYPE,
104: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
105: p_parameter_type IN vea_parameters.parameter_type%TYPE,
106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
107: p_name IN vea_parameters.name%TYPE,
108: p_datatype IN vea_parameters.datatype%TYPE,
109: p_default_value IN vea_parameters.default_value%TYPE,
110: p_description IN vea_parameters.description%TYPE

Line 107: p_name IN vea_parameters.name%TYPE,

103: p_parameter_id IN vea_parameters.parameter_id%TYPE,
104: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
105: p_parameter_type IN vea_parameters.parameter_type%TYPE,
106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
107: p_name IN vea_parameters.name%TYPE,
108: p_datatype IN vea_parameters.datatype%TYPE,
109: p_default_value IN vea_parameters.default_value%TYPE,
110: p_description IN vea_parameters.description%TYPE
111: )

Line 108: p_datatype IN vea_parameters.datatype%TYPE,

104: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
105: p_parameter_type IN vea_parameters.parameter_type%TYPE,
106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
107: p_name IN vea_parameters.name%TYPE,
108: p_datatype IN vea_parameters.datatype%TYPE,
109: p_default_value IN vea_parameters.default_value%TYPE,
110: p_description IN vea_parameters.description%TYPE
111: )
112: IS

Line 109: p_default_value IN vea_parameters.default_value%TYPE,

105: p_parameter_type IN vea_parameters.parameter_type%TYPE,
106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
107: p_name IN vea_parameters.name%TYPE,
108: p_datatype IN vea_parameters.datatype%TYPE,
109: p_default_value IN vea_parameters.default_value%TYPE,
110: p_description IN vea_parameters.description%TYPE
111: )
112: IS
113: --{

Line 110: p_description IN vea_parameters.description%TYPE

106: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
107: p_name IN vea_parameters.name%TYPE,
108: p_datatype IN vea_parameters.datatype%TYPE,
109: p_default_value IN vea_parameters.default_value%TYPE,
110: p_description IN vea_parameters.description%TYPE
111: )
112: IS
113: --{
114: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 125: UPDATE vea_parameters

121: BEGIN
122: --{
123: l_location := '0010';
124: --
125: UPDATE vea_parameters
126: SET program_unit_id = p_program_unit_id,
127: parameter_type = p_parameter_type,
128: parameter_seq = p_parameter_seq,
129: name = p_name,

Line 165: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

161: ========================================================================*/
162: PROCEDURE
163: delete_rows
164: (
165: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
166: p_program_unit_id IN vea_parameters.program_unit_id%TYPE
167: )
168: IS
169: --{

Line 166: p_program_unit_id IN vea_parameters.program_unit_id%TYPE

162: PROCEDURE
163: delete_rows
164: (
165: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
166: p_program_unit_id IN vea_parameters.program_unit_id%TYPE
167: )
168: IS
169: --{
170: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';

Line 179: DELETE vea_parameters

175: BEGIN
176: --{
177: l_location := '0010';
178: --
179: DELETE vea_parameters
180: WHERE layer_provider_code = p_layer_provider_code
181: AND program_unit_id = p_program_unit_id;
182: --}
183: EXCEPTION

Line 210: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

206: ========================================================================*/
207: FUNCTION
208: getId
209: (
210: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
211: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
212: p_name IN vea_parameters.name%TYPE
213: )
214: RETURN NUMBER

Line 211: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,

207: FUNCTION
208: getId
209: (
210: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
211: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
212: p_name IN vea_parameters.name%TYPE
213: )
214: RETURN NUMBER
215: IS

Line 212: p_name IN vea_parameters.name%TYPE

208: getId
209: (
210: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
211: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
212: p_name IN vea_parameters.name%TYPE
213: )
214: RETURN NUMBER
215: IS
216: --{

Line 223: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

219: --
220: --
221: CURSOR parameter_cur
222: (
223: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
224: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
225: p_name IN vea_parameters.name%TYPE
226: )
227: IS

Line 224: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,

220: --
221: CURSOR parameter_cur
222: (
223: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
224: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
225: p_name IN vea_parameters.name%TYPE
226: )
227: IS
228: SELECT parameter_id

Line 225: p_name IN vea_parameters.name%TYPE

221: CURSOR parameter_cur
222: (
223: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
224: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
225: p_name IN vea_parameters.name%TYPE
226: )
227: IS
228: SELECT parameter_id
229: FROM vea_parameters

Line 229: FROM vea_parameters

225: p_name IN vea_parameters.name%TYPE
226: )
227: IS
228: SELECT parameter_id
229: FROM vea_parameters
230: WHERE layer_provider_code = p_layer_provider_code
231: AND program_unit_id = p_program_unit_id
232: AND upper(name) = upper(p_name);
233: --}

Line 270: PURPOSE: Table hadndler API for VEA_PARAMETERS table.

266: /*========================================================================
267:
268: PROCEDURE NAME: process
269:
270: PURPOSE: Table hadndler API for VEA_PARAMETERS table.
271:
272: It inserts/updates a record in VEA_PARAMETERS table.
273:
274: ========================================================================*/

Line 272: It inserts/updates a record in VEA_PARAMETERS table.

268: PROCEDURE NAME: process
269:
270: PURPOSE: Table hadndler API for VEA_PARAMETERS table.
271:
272: It inserts/updates a record in VEA_PARAMETERS table.
273:
274: ========================================================================*/
275: PROCEDURE
276: process

Line 285: x_id OUT NOCOPY vea_parameters.parameter_id%TYPE,

281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: x_id OUT NOCOPY vea_parameters.parameter_id%TYPE,
286: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
287: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
288: p_parameter_type IN vea_parameters.parameter_type%TYPE,
289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,

Line 286: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: x_id OUT NOCOPY vea_parameters.parameter_id%TYPE,
286: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
287: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
288: p_parameter_type IN vea_parameters.parameter_type%TYPE,
289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
290: p_name IN vea_parameters.name%TYPE,

Line 287: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,

283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: x_id OUT NOCOPY vea_parameters.parameter_id%TYPE,
286: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
287: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
288: p_parameter_type IN vea_parameters.parameter_type%TYPE,
289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
290: p_name IN vea_parameters.name%TYPE,
291: p_datatype IN vea_parameters.datatype%TYPE,

Line 288: p_parameter_type IN vea_parameters.parameter_type%TYPE,

284: x_msg_data OUT NOCOPY VARCHAR2,
285: x_id OUT NOCOPY vea_parameters.parameter_id%TYPE,
286: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
287: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
288: p_parameter_type IN vea_parameters.parameter_type%TYPE,
289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
290: p_name IN vea_parameters.name%TYPE,
291: p_datatype IN vea_parameters.datatype%TYPE,
292: p_default_value IN vea_parameters.default_value%TYPE,

Line 289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,

285: x_id OUT NOCOPY vea_parameters.parameter_id%TYPE,
286: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
287: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
288: p_parameter_type IN vea_parameters.parameter_type%TYPE,
289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
290: p_name IN vea_parameters.name%TYPE,
291: p_datatype IN vea_parameters.datatype%TYPE,
292: p_default_value IN vea_parameters.default_value%TYPE,
293: p_description IN vea_parameters.description%TYPE,

Line 290: p_name IN vea_parameters.name%TYPE,

286: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
287: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
288: p_parameter_type IN vea_parameters.parameter_type%TYPE,
289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
290: p_name IN vea_parameters.name%TYPE,
291: p_datatype IN vea_parameters.datatype%TYPE,
292: p_default_value IN vea_parameters.default_value%TYPE,
293: p_description IN vea_parameters.description%TYPE,
294: p_id IN vea_parameters.parameter_id%TYPE := NULL,

Line 291: p_datatype IN vea_parameters.datatype%TYPE,

287: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
288: p_parameter_type IN vea_parameters.parameter_type%TYPE,
289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
290: p_name IN vea_parameters.name%TYPE,
291: p_datatype IN vea_parameters.datatype%TYPE,
292: p_default_value IN vea_parameters.default_value%TYPE,
293: p_description IN vea_parameters.description%TYPE,
294: p_id IN vea_parameters.parameter_id%TYPE := NULL,
295: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL

Line 292: p_default_value IN vea_parameters.default_value%TYPE,

288: p_parameter_type IN vea_parameters.parameter_type%TYPE,
289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
290: p_name IN vea_parameters.name%TYPE,
291: p_datatype IN vea_parameters.datatype%TYPE,
292: p_default_value IN vea_parameters.default_value%TYPE,
293: p_description IN vea_parameters.description%TYPE,
294: p_id IN vea_parameters.parameter_id%TYPE := NULL,
295: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
296: )

Line 293: p_description IN vea_parameters.description%TYPE,

289: p_parameter_seq IN vea_parameters.parameter_seq%TYPE,
290: p_name IN vea_parameters.name%TYPE,
291: p_datatype IN vea_parameters.datatype%TYPE,
292: p_default_value IN vea_parameters.default_value%TYPE,
293: p_description IN vea_parameters.description%TYPE,
294: p_id IN vea_parameters.parameter_id%TYPE := NULL,
295: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
296: )
297: IS

Line 294: p_id IN vea_parameters.parameter_id%TYPE := NULL,

290: p_name IN vea_parameters.name%TYPE,
291: p_datatype IN vea_parameters.datatype%TYPE,
292: p_default_value IN vea_parameters.default_value%TYPE,
293: p_description IN vea_parameters.description%TYPE,
294: p_id IN vea_parameters.parameter_id%TYPE := NULL,
295: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
296: )
297: IS
298: --{

Line 306: l_parameter_id vea_parameters.parameter_id%TYPE;

302: --
303: --
304: l_location VARCHAR2(32767);
305: l_savepoint_name VARCHAR2(30);
306: l_parameter_id vea_parameters.parameter_id%TYPE;
307: l_program_unit_id vea_program_units.program_unit_id%TYPE;
308: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
309: --
310: --

Line 313: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,

309: --
310: --
311: CURSOR parameter_cur
312: (
313: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
314: p_parameter_id IN vea_parameters.parameter_id%TYPE,
315: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
316: p_name IN vea_parameters.name%TYPE
317: )

Line 314: p_parameter_id IN vea_parameters.parameter_id%TYPE,

310: --
311: CURSOR parameter_cur
312: (
313: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
314: p_parameter_id IN vea_parameters.parameter_id%TYPE,
315: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
316: p_name IN vea_parameters.name%TYPE
317: )
318: IS

Line 315: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,

311: CURSOR parameter_cur
312: (
313: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
314: p_parameter_id IN vea_parameters.parameter_id%TYPE,
315: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
316: p_name IN vea_parameters.name%TYPE
317: )
318: IS
319: SELECT parameter_id

Line 316: p_name IN vea_parameters.name%TYPE

312: (
313: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
314: p_parameter_id IN vea_parameters.parameter_id%TYPE,
315: p_program_unit_id IN vea_parameters.program_unit_id%TYPE,
316: p_name IN vea_parameters.name%TYPE
317: )
318: IS
319: SELECT parameter_id
320: FROM vea_parameters

Line 320: FROM vea_parameters

316: p_name IN vea_parameters.name%TYPE
317: )
318: IS
319: SELECT parameter_id
320: FROM vea_parameters
321: WHERE layer_provider_code = p_layer_provider_code
322: AND program_unit_id = p_program_unit_id
323: AND name = p_name;
324: -- Commented out this code because we no longer base our processing on the ids

Line 433: SELECT NVL( p_id, vea_parameters_s.NEXTVAL )

429: --
430: --
431: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
432: THEN
433: SELECT NVL( p_id, vea_parameters_s.NEXTVAL )
434: INTO l_parameter_id
435: FROM DUAL;
436: ELSE
437: SELECT vea_parameters_s.NEXTVAL

Line 437: SELECT vea_parameters_s.NEXTVAL

433: SELECT NVL( p_id, vea_parameters_s.NEXTVAL )
434: INTO l_parameter_id
435: FROM DUAL;
436: ELSE
437: SELECT vea_parameters_s.NEXTVAL
438: INTO l_parameter_id
439: FROM DUAL;
440: END IF;
441: --

Line 562: END VEA_PARAMETERS_SV;

558: --}
559: --}
560: END process;
561: --}
562: END VEA_PARAMETERS_SV;