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_LAYERPROVIDERS_SV dependencies on VEA_LAYER_PROVIDERS

Line 30: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: validateUniqueCodes
29: (
30: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
31: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
32: )
33: IS
34: --{

Line 31: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE

27: PROCEDURE
28: validateUniqueCodes
29: (
30: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
31: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
32: )
33: IS
34: --{
35: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueCodes';

Line 46: FROM vea_layer_providers

42: --
43: CURSOR layer_cur IS
44: --
45: SELECT layer_provider_code
46: FROM vea_layer_providers
47: WHERE layer_provider_code = p_layer_provider_code;
48: --
49: --}
50: BEGIN

Line 105: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

101: ========================================================================*/
102: PROCEDURE
103: validate
104: (
105: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
106: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
107: )
108: IS
109: --{

Line 106: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE

102: PROCEDURE
103: validate
104: (
105: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
106: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
107: )
108: IS
109: --{
110: l_api_name CONSTANT VARCHAR2(30) := 'validate';

Line 172: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,

168: ========================================================================*/
169: PROCEDURE
170: insert_row
171: (
172: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
173: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
174: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
175: p_description IN vea_layer_providers.description%TYPE
176: )

Line 173: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

169: PROCEDURE
170: insert_row
171: (
172: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
173: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
174: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
175: p_description IN vea_layer_providers.description%TYPE
176: )
177: IS

Line 174: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,

170: insert_row
171: (
172: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
173: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
174: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
175: p_description IN vea_layer_providers.description%TYPE
176: )
177: IS
178: --{

Line 175: p_description IN vea_layer_providers.description%TYPE

171: (
172: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
173: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
174: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
175: p_description IN vea_layer_providers.description%TYPE
176: )
177: IS
178: --{
179: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 201: INSERT INTO vea_layer_providers

197: --
198: l_location := '0020';
199: --
200: --
201: INSERT INTO vea_layer_providers
202: (
203: layer_provider_id,
204: layer_provider_code,
205: layer_provider_name,

Line 248: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,

244: ========================================================================*/
245: PROCEDURE
246: update_row
247: (
248: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
249: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
250: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
251: p_description IN vea_layer_providers.description%TYPE
252: )

Line 249: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

245: PROCEDURE
246: update_row
247: (
248: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
249: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
250: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
251: p_description IN vea_layer_providers.description%TYPE
252: )
253: IS

Line 250: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,

246: update_row
247: (
248: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
249: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
250: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
251: p_description IN vea_layer_providers.description%TYPE
252: )
253: IS
254: --{

Line 251: p_description IN vea_layer_providers.description%TYPE

247: (
248: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
249: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
250: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
251: p_description IN vea_layer_providers.description%TYPE
252: )
253: IS
254: --{
255: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 266: UPDATE vea_layer_providers

262: BEGIN
263: --{
264: l_location := '0010';
265: --
266: UPDATE vea_layer_providers
267: SET layer_provider_code = p_layer_provider_code,
268: layer_provider_name = p_layer_provider_name,
269: description = p_description,
270: last_updated_by = l_user_id,

Line 302: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

298: ========================================================================*/
299: PROCEDURE
300: delete_rows
301: (
302: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
303: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
304: )
305: IS
306: --{

Line 303: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE

299: PROCEDURE
300: delete_rows
301: (
302: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
303: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
304: )
305: IS
306: --{
307: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';

Line 346: DELETE vea_layer_providers

342: --
343: IF p_layer_provider_code <> 'ORCL' THEN
344: -- Bug No: 1387766 - rvishnuv
345: --{
346: DELETE vea_layer_providers
347: WHERE layer_provider_code = p_layer_provider_code;
348: -- }
349: END IF;
350: --

Line 400: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE

396: ========================================================================*/
397: FUNCTION
398: getLayerProviderCode
399: (
400: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
401: )
402: RETURN VARCHAR2
403: IS
404: --{

Line 409: l_layer_provider_code vea_layer_providers.layer_provider_code%TYPE;

405: l_api_name CONSTANT VARCHAR2(30) := 'getLayerProviderCode';
406: l_location VARCHAR2(32767);
407: --
408: --
409: l_layer_provider_code vea_layer_providers.layer_provider_code%TYPE;
410: --
411: --
412: CURSOR layer_cur IS
413: --

Line 415: FROM vea_layer_providers

411: --
412: CURSOR layer_cur IS
413: --
414: SELECT layer_provider_code
415: FROM vea_layer_providers
416: WHERE layer_provider_name = p_layer_provider_name;
417: --
418: --}
419: BEGIN

Line 476: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE

472: ========================================================================*/
473: FUNCTION
474: getLayerProviderName
475: (
476: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE
477: )
478: RETURN VARCHAR2
479: IS
480: --{

Line 485: l_layer_provider_name vea_layer_providers.layer_provider_name%TYPE;

481: l_api_name CONSTANT VARCHAR2(30) := 'getLayerProviderName';
482: l_location VARCHAR2(32767);
483: --
484: --
485: l_layer_provider_name vea_layer_providers.layer_provider_name%TYPE;
486: --
487: --
488: CURSOR layer_cur IS
489: --

Line 491: FROM vea_layer_providers

487: --
488: CURSOR layer_cur IS
489: --
490: SELECT layer_provider_name
491: FROM vea_layer_providers
492: WHERE layer_provider_code = p_layer_provider_code;
493: --
494: --}
495: BEGIN

Line 561: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

557: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,
561: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
562: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
563: p_description IN vea_layer_providers.description%TYPE
564: )
565: IS

Line 562: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,

558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,
561: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
562: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
563: p_description IN vea_layer_providers.description%TYPE
564: )
565: IS
566: --{

Line 563: p_description IN vea_layer_providers.description%TYPE

559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,
561: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
562: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
563: p_description IN vea_layer_providers.description%TYPE
564: )
565: IS
566: --{
567: l_api_name CONSTANT VARCHAR2(30) := 'process';

Line 575: l_layer_provider_name vea_layer_providers.layer_provider_name%TYPE;

571: --
572: l_location VARCHAR2(32767);
573: l_savepoint_name VARCHAR2(30);
574: l_insert BOOLEAN := TRUE;
575: l_layer_provider_name vea_layer_providers.layer_provider_name%TYPE;
576: l_layer_provider_id vea_layer_providers.layer_provider_id%TYPE;
577: l_layer_provider_code vea_layer_providers.layer_provider_code%TYPE;
578: l_layer_count NUMBER := 0;
579: --

Line 576: l_layer_provider_id vea_layer_providers.layer_provider_id%TYPE;

572: l_location VARCHAR2(32767);
573: l_savepoint_name VARCHAR2(30);
574: l_insert BOOLEAN := TRUE;
575: l_layer_provider_name vea_layer_providers.layer_provider_name%TYPE;
576: l_layer_provider_id vea_layer_providers.layer_provider_id%TYPE;
577: l_layer_provider_code vea_layer_providers.layer_provider_code%TYPE;
578: l_layer_count NUMBER := 0;
579: --
580: --

Line 577: l_layer_provider_code vea_layer_providers.layer_provider_code%TYPE;

573: l_savepoint_name VARCHAR2(30);
574: l_insert BOOLEAN := TRUE;
575: l_layer_provider_name vea_layer_providers.layer_provider_name%TYPE;
576: l_layer_provider_id vea_layer_providers.layer_provider_id%TYPE;
577: l_layer_provider_code vea_layer_providers.layer_provider_code%TYPE;
578: l_layer_count NUMBER := 0;
579: --
580: --
581: TYPE lp_rec_type IS

Line 584: layer_provider_id vea_layer_providers.layer_provider_id%TYPE,

580: --
581: TYPE lp_rec_type IS
582: RECORD
583: (
584: layer_provider_id vea_layer_providers.layer_provider_id%TYPE,
585: layer_provider_code vea_layer_providers.layer_provider_code%TYPE,
586: layer_provider_name vea_layer_providers.layer_provider_name%TYPE
587: );
588: --

Line 585: layer_provider_code vea_layer_providers.layer_provider_code%TYPE,

581: TYPE lp_rec_type IS
582: RECORD
583: (
584: layer_provider_id vea_layer_providers.layer_provider_id%TYPE,
585: layer_provider_code vea_layer_providers.layer_provider_code%TYPE,
586: layer_provider_name vea_layer_providers.layer_provider_name%TYPE
587: );
588: --
589: --

Line 586: layer_provider_name vea_layer_providers.layer_provider_name%TYPE

582: RECORD
583: (
584: layer_provider_id vea_layer_providers.layer_provider_id%TYPE,
585: layer_provider_code vea_layer_providers.layer_provider_code%TYPE,
586: layer_provider_name vea_layer_providers.layer_provider_name%TYPE
587: );
588: --
589: --
590: TYPE layer_cur_type IS REF CURSOR ;

Line 643: from vea_layer_providers

639: THEN
640: open layer_cur for
641: 'select layer_provider_id,
642: layer_provider_code, layer_provider_name
643: from vea_layer_providers
644: where layer_provider_code = :lp_code'
645: using p_layer_provider_code;
646: ELSE
647: open layer_cur for

Line 650: from vea_layer_providers

646: ELSE
647: open layer_cur for
648: select layer_provider_id,
649: layer_provider_code, layer_provider_name
650: from vea_layer_providers
651: where layer_provider_code is not null;
652: END IF;
653:
654: LOOP

Line 709: p_lookup_type => 'VEA_LAYER_PROVIDERS',

705: p_description => p_description
706: );
707: vea_tpa_util_pvt.update_lookup_values
708: (
709: p_lookup_type => 'VEA_LAYER_PROVIDERS',
710: p_new_lookup_code => p_layer_provider_code,
711: p_current_lookup_code => layer_rec.layer_provider_code,
712: p_meaning => p_layer_provider_name,
713: p_description => p_layer_provider_name

Line 735: SELECT vea_layer_providers_s.NEXTVAL

731: --{
732: l_location := '0110';
733: --
734: --
735: SELECT vea_layer_providers_s.NEXTVAL
736: INTO l_layer_provider_id
737: FROM DUAL;
738: --
739: --

Line 752: p_lookup_type => 'VEA_LAYER_PROVIDERS',

748: THEN
749: --{
750: vea_tpa_util_pvt.insert_lookup_values
751: (
752: p_lookup_type => 'VEA_LAYER_PROVIDERS',
753: p_lookup_code => p_layer_provider_code,
754: p_meaning => p_layer_provider_name,
755: p_description => p_layer_provider_name
756: );