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_TP_LAYERS_SV dependencies on VEA_TP_LAYERS

Line 1: PACKAGE BODY VEA_TP_LAYERS_SV as

1: PACKAGE BODY VEA_TP_LAYERS_SV as
2: /* $Header: VEAVATLB.pls 115.5 2004/07/27 00:08:47 rvishnuv ship $ */
3: --{
4: /*====================== vea_tp_layers_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_tp_layers_sv =========================/

1: PACKAGE BODY VEA_TP_LAYERS_SV as
2: /* $Header: VEAVATLB.pls 115.5 2004/07/27 00:08:47 rvishnuv ship $ */
3: --{
4: /*====================== vea_tp_layers_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_TP_LAYERS
7:
8: NOTES: To run the script:

Line 6: PURPOSE: Table handler package for table VEA_TP_LAYERS

2: /* $Header: VEAVATLB.pls 115.5 2004/07/27 00:08:47 rvishnuv ship $ */
3: --{
4: /*====================== vea_tp_layers_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_TP_LAYERS
7:
8: NOTES: To run the script:
9:
10: sql> start VEAVATLB.pls

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

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

Line 24: PURPOSE: Inserts a record into VEA_TP_LAYERS table

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

Line 30: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
31: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
32: p_name IN vea_tp_layers.name%TYPE,
33: p_description IN vea_tp_layers.description%TYPE,
34: p_active_flag IN vea_tp_layers.active_flag%TYPE

Line 31: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,

27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
31: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
32: p_name IN vea_tp_layers.name%TYPE,
33: p_description IN vea_tp_layers.description%TYPE,
34: p_active_flag IN vea_tp_layers.active_flag%TYPE
35: )

Line 32: p_name IN vea_tp_layers.name%TYPE,

28: insert_row
29: (
30: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
31: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
32: p_name IN vea_tp_layers.name%TYPE,
33: p_description IN vea_tp_layers.description%TYPE,
34: p_active_flag IN vea_tp_layers.active_flag%TYPE
35: )
36: IS

Line 33: p_description IN vea_tp_layers.description%TYPE,

29: (
30: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
31: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
32: p_name IN vea_tp_layers.name%TYPE,
33: p_description IN vea_tp_layers.description%TYPE,
34: p_active_flag IN vea_tp_layers.active_flag%TYPE
35: )
36: IS
37: --{

Line 34: p_active_flag IN vea_tp_layers.active_flag%TYPE

30: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
31: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
32: p_name IN vea_tp_layers.name%TYPE,
33: p_description IN vea_tp_layers.description%TYPE,
34: p_active_flag IN vea_tp_layers.active_flag%TYPE
35: )
36: IS
37: --{
38: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 49: INSERT INTO vea_tp_layers

45: BEGIN
46: --{
47: l_location := '0010';
48: --
49: INSERT INTO vea_tp_layers
50: (
51: layer_provider_code, tp_layer_id,
52: name,
53: description,

Line 90: PURPOSE: Updates a record into VEA_TP_LAYERS table

86: /*========================================================================
87:
88: PROCEDURE NAME: update_row
89:
90: PURPOSE: Updates a record into VEA_TP_LAYERS table
91:
92: ========================================================================*/
93: PROCEDURE
94: update_row

Line 96: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

92: ========================================================================*/
93: PROCEDURE
94: update_row
95: (
96: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
97: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
98: p_name IN vea_tp_layers.name%TYPE,
99: p_description IN vea_tp_layers.description%TYPE,
100: p_active_flag IN vea_tp_layers.active_flag%TYPE

Line 97: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,

93: PROCEDURE
94: update_row
95: (
96: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
97: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
98: p_name IN vea_tp_layers.name%TYPE,
99: p_description IN vea_tp_layers.description%TYPE,
100: p_active_flag IN vea_tp_layers.active_flag%TYPE
101: )

Line 98: p_name IN vea_tp_layers.name%TYPE,

94: update_row
95: (
96: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
97: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
98: p_name IN vea_tp_layers.name%TYPE,
99: p_description IN vea_tp_layers.description%TYPE,
100: p_active_flag IN vea_tp_layers.active_flag%TYPE
101: )
102: IS

Line 99: p_description IN vea_tp_layers.description%TYPE,

95: (
96: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
97: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
98: p_name IN vea_tp_layers.name%TYPE,
99: p_description IN vea_tp_layers.description%TYPE,
100: p_active_flag IN vea_tp_layers.active_flag%TYPE
101: )
102: IS
103: --{

Line 100: p_active_flag IN vea_tp_layers.active_flag%TYPE

96: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
97: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
98: p_name IN vea_tp_layers.name%TYPE,
99: p_description IN vea_tp_layers.description%TYPE,
100: p_active_flag IN vea_tp_layers.active_flag%TYPE
101: )
102: IS
103: --{
104: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 115: UPDATE vea_tp_layers

111: BEGIN
112: --{
113: l_location := '0010';
114: --
115: UPDATE vea_tp_layers
116: SET name = p_name,
117: description = p_description,
118: active_flag = 'N', --p_active_flag,
119: last_updated_by = l_user_id,

Line 151: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

147: ========================================================================*/
148: PROCEDURE
149: delete_row
150: (
151: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
152: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
153: )
154: IS
155: --{

Line 152: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE

148: PROCEDURE
149: delete_row
150: (
151: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
152: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
153: )
154: IS
155: --{
156: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';

Line 178: DELETE vea_tp_layers

174: --
175: l_location := '0020';
176: */
177: --
178: DELETE vea_tp_layers
179: WHERE layer_provider_code = p_layer_provider_code
180: AND tp_layer_id = p_tp_layer_id;
181: --}
182: EXCEPTION

Line 208: p_tp_layer_name IN vea_tp_layers.name%TYPE

204: ========================================================================*/
205: FUNCTION
206: get_tp_layer_id
207: (
208: p_tp_layer_name IN vea_tp_layers.name%TYPE
209: )
210: RETURN vea_tp_layers.tp_layer_id%TYPE
211: IS
212: --{

Line 210: RETURN vea_tp_layers.tp_layer_id%TYPE

206: get_tp_layer_id
207: (
208: p_tp_layer_name IN vea_tp_layers.name%TYPE
209: )
210: RETURN vea_tp_layers.tp_layer_id%TYPE
211: IS
212: --{
213: CURSOR tp_layer_cur
214: (

Line 215: p_layer_provider_code IN vea_tp_layers.name%TYPE,

211: IS
212: --{
213: CURSOR tp_layer_cur
214: (
215: p_layer_provider_code IN vea_tp_layers.name%TYPE,
216: p_tp_layer_name IN vea_tp_layers.name%TYPE
217: )
218: IS
219: SELECT tp_layer_id

Line 216: p_tp_layer_name IN vea_tp_layers.name%TYPE

212: --{
213: CURSOR tp_layer_cur
214: (
215: p_layer_provider_code IN vea_tp_layers.name%TYPE,
216: p_tp_layer_name IN vea_tp_layers.name%TYPE
217: )
218: IS
219: SELECT tp_layer_id
220: FROM vea_tp_layers

Line 220: FROM vea_tp_layers

216: p_tp_layer_name IN vea_tp_layers.name%TYPE
217: )
218: IS
219: SELECT tp_layer_id
220: FROM vea_tp_layers
221: WHERE name = p_tp_layer_name
222: AND layer_provider_code = p_layer_provider_code;
223: --
224: --

Line 263: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

259: ========================================================================*/
260: FUNCTION
261: getId
262: (
263: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
264: p_tp_layer_name IN vea_tp_layers.name%TYPE
265: )
266: RETURN vea_tp_layers.tp_layer_id%TYPE
267: IS

Line 264: p_tp_layer_name IN vea_tp_layers.name%TYPE

260: FUNCTION
261: getId
262: (
263: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
264: p_tp_layer_name IN vea_tp_layers.name%TYPE
265: )
266: RETURN vea_tp_layers.tp_layer_id%TYPE
267: IS
268: --{

Line 266: RETURN vea_tp_layers.tp_layer_id%TYPE

262: (
263: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
264: p_tp_layer_name IN vea_tp_layers.name%TYPE
265: )
266: RETURN vea_tp_layers.tp_layer_id%TYPE
267: IS
268: --{
269: CURSOR tp_layer_cur
270: (

Line 271: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

267: IS
268: --{
269: CURSOR tp_layer_cur
270: (
271: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
272: p_tp_layer_name IN vea_tp_layers.name%TYPE
273: )
274: IS
275: SELECT tp_layer_id

Line 272: p_tp_layer_name IN vea_tp_layers.name%TYPE

268: --{
269: CURSOR tp_layer_cur
270: (
271: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
272: p_tp_layer_name IN vea_tp_layers.name%TYPE
273: )
274: IS
275: SELECT tp_layer_id
276: FROM vea_tp_layers

Line 276: FROM vea_tp_layers

272: p_tp_layer_name IN vea_tp_layers.name%TYPE
273: )
274: IS
275: SELECT tp_layer_id
276: FROM vea_tp_layers
277: WHERE name = p_tp_layer_name
278: AND layer_provider_code = p_layer_provider_code;
279: --
280: --

Line 320: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

316: ========================================================================*/
317: PROCEDURE
318: delete_rows
319: (
320: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
321: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
322: p_application_short_name IN vea_packages.application_short_name%TYPE
323: )
324: IS

Line 321: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,

317: PROCEDURE
318: delete_rows
319: (
320: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
321: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
322: p_application_short_name IN vea_packages.application_short_name%TYPE
323: )
324: IS
325: --{

Line 334: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;

330: --
331: l_location VARCHAR2(32767);
332: --
333: --
334: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
335: l_layer_header_count NUMBER;
336: l_package_count NUMBER;
337: --
338: --

Line 428: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

424: ========================================================================*/
425: PROCEDURE
426: delete_rows
427: (
428: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
429: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
430: p_tp_layer_name IN vea_tp_layers.name%TYPE,
431: p_application_short_name IN vea_packages.application_short_name%TYPE
432: )

Line 429: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,

425: PROCEDURE
426: delete_rows
427: (
428: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
429: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
430: p_tp_layer_name IN vea_tp_layers.name%TYPE,
431: p_application_short_name IN vea_packages.application_short_name%TYPE
432: )
433: IS

Line 430: p_tp_layer_name IN vea_tp_layers.name%TYPE,

426: delete_rows
427: (
428: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
429: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
430: p_tp_layer_name IN vea_tp_layers.name%TYPE,
431: p_application_short_name IN vea_packages.application_short_name%TYPE
432: )
433: IS
434: --{

Line 448: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

444: --
445: --
446: CURSOR tp_layer_id_cur
447: (
448: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
449: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
450: )
451: IS
452: SELECT tp_layer_id

Line 449: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE

445: --
446: CURSOR tp_layer_id_cur
447: (
448: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
449: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
450: )
451: IS
452: SELECT tp_layer_id
453: FROM vea_tp_layers

Line 453: FROM vea_tp_layers

449: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
450: )
451: IS
452: SELECT tp_layer_id
453: FROM vea_tp_layers
454: WHERE layer_provider_code = p_layer_provider_code
455: AND tp_layer_id = p_tp_layer_id;
456: --
457: --

Line 460: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

456: --
457: --
458: CURSOR tp_layer_name_cur
459: (
460: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
461: p_tp_layer_name IN vea_tp_layers.name%TYPE
462: )
463: IS
464: SELECT tp_layer_id

Line 461: p_tp_layer_name IN vea_tp_layers.name%TYPE

457: --
458: CURSOR tp_layer_name_cur
459: (
460: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
461: p_tp_layer_name IN vea_tp_layers.name%TYPE
462: )
463: IS
464: SELECT tp_layer_id
465: FROM vea_tp_layers

Line 465: FROM vea_tp_layers

461: p_tp_layer_name IN vea_tp_layers.name%TYPE
462: )
463: IS
464: SELECT tp_layer_id
465: FROM vea_tp_layers
466: WHERE layer_provider_code = p_layer_provider_code
467: AND name = NVL(p_tp_layer_name,name);
468: --
469: --

Line 470: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;

466: WHERE layer_provider_code = p_layer_provider_code
467: AND name = NVL(p_tp_layer_name,name);
468: --
469: --
470: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
471: --
472: --
473: --}
474: BEGIN

Line 573: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE

569: ========================================================================*/
570: PROCEDURE
571: deleteUnlicensedLayers
572: (
573: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE
574: )
575: IS
576: --{
577: l_api_name CONSTANT VARCHAR2(30) := 'deleteUnlicensedLayers';

Line 588: DELETE vea_tp_layers

584: BEGIN
585: --{
586: l_location := '0010';
587: --
588: DELETE vea_tp_layers
589: WHERE layer_provider_code = p_layer_provider_code
590: AND tp_layer_id NOT IN (
591: SELECT tp_layer_id
592: FROM vea_packages

Line 621: PURPOSE: Table hadndler API for VEA_TP_LAYERS table.

617: /*========================================================================
618:
619: PROCEDURE NAME: process
620:
621: PURPOSE: Table hadndler API for VEA_TP_LAYERS table.
622:
623: It inserts/updates a record in VEA_TP_LAYERS table.
624:
625: ========================================================================*/

Line 623: It inserts/updates a record in VEA_TP_LAYERS table.

619: PROCEDURE NAME: process
620:
621: PURPOSE: Table hadndler API for VEA_TP_LAYERS table.
622:
623: It inserts/updates a record in VEA_TP_LAYERS table.
624:
625: ========================================================================*/
626: PROCEDURE
627: process

Line 636: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,

632: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,
636: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
637: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
638: p_name IN vea_tp_layers.name%TYPE,
639: p_description IN vea_tp_layers.description%TYPE,
640: p_active_flag IN vea_tp_layers.active_flag%TYPE,

Line 637: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,
636: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
637: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
638: p_name IN vea_tp_layers.name%TYPE,
639: p_description IN vea_tp_layers.description%TYPE,
640: p_active_flag IN vea_tp_layers.active_flag%TYPE,
641: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL

Line 638: p_name IN vea_tp_layers.name%TYPE,

634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,
636: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
637: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
638: p_name IN vea_tp_layers.name%TYPE,
639: p_description IN vea_tp_layers.description%TYPE,
640: p_active_flag IN vea_tp_layers.active_flag%TYPE,
641: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
642: )

Line 639: p_description IN vea_tp_layers.description%TYPE,

635: x_msg_data OUT NOCOPY VARCHAR2,
636: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
637: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
638: p_name IN vea_tp_layers.name%TYPE,
639: p_description IN vea_tp_layers.description%TYPE,
640: p_active_flag IN vea_tp_layers.active_flag%TYPE,
641: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
642: )
643: IS

Line 640: p_active_flag IN vea_tp_layers.active_flag%TYPE,

636: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
637: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
638: p_name IN vea_tp_layers.name%TYPE,
639: p_description IN vea_tp_layers.description%TYPE,
640: p_active_flag IN vea_tp_layers.active_flag%TYPE,
641: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
642: )
643: IS
644: --{

Line 641: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL

637: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
638: p_name IN vea_tp_layers.name%TYPE,
639: p_description IN vea_tp_layers.description%TYPE,
640: p_active_flag IN vea_tp_layers.active_flag%TYPE,
641: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
642: )
643: IS
644: --{
645: l_api_name CONSTANT VARCHAR2(30) := 'process';

Line 652: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;

648: --
649: --
650: l_location VARCHAR2(32767);
651: l_savepoint_name VARCHAR2(30);
652: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
653: --
654: --
655: CURSOR tp_layer_cur
656: (

Line 657: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

653: --
654: --
655: CURSOR tp_layer_cur
656: (
657: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
658: p_name IN vea_tp_layers.name%TYPE
659: )
660: IS
661: SELECT tp_layer_id

Line 658: p_name IN vea_tp_layers.name%TYPE

654: --
655: CURSOR tp_layer_cur
656: (
657: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
658: p_name IN vea_tp_layers.name%TYPE
659: )
660: IS
661: SELECT tp_layer_id
662: FROM vea_tp_layers

Line 662: FROM vea_tp_layers

658: p_name IN vea_tp_layers.name%TYPE
659: )
660: IS
661: SELECT tp_layer_id
662: FROM vea_tp_layers
663: WHERE layer_provider_code = p_layer_provider_code
664: AND name = p_name;
665: --
666: --

Line 670: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

666: --
667: /*
668: CURSOR tp_layer_cur
669: (
670: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
671: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
672: )
673: IS
674: SELECT tp_layer_id

Line 671: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE

667: /*
668: CURSOR tp_layer_cur
669: (
670: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
671: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
672: )
673: IS
674: SELECT tp_layer_id
675: FROM vea_tp_layers

Line 675: FROM vea_tp_layers

671: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
672: )
673: IS
674: SELECT tp_layer_id
675: FROM vea_tp_layers
676: WHERE layer_provider_code = p_layer_provider_code
677: AND tp_layer_id = p_tp_layer_id;
678: */
679: --

Line 741: SELECT NVL( p_id, vea_tp_layers_s.NEXTVAL )

737: l_location := '0070';
738: --
739: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
740: THEN
741: SELECT NVL( p_id, vea_tp_layers_s.NEXTVAL )
742: INTO l_tp_layer_id
743: FROM DUAL;
744: ELSE
745: SELECT vea_tp_layers_s.NEXTVAL

Line 745: SELECT vea_tp_layers_s.NEXTVAL

741: SELECT NVL( p_id, vea_tp_layers_s.NEXTVAL )
742: INTO l_tp_layer_id
743: FROM DUAL;
744: ELSE
745: SELECT vea_tp_layers_s.NEXTVAL
746: INTO l_tp_layer_id
747: FROM DUAL;
748: END IF;
749: --

Line 867: END VEA_TP_LAYERS_SV;

863: --}
864: --}
865: END process;
866: --}
867: END VEA_TP_LAYERS_SV;