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_TPA_UTIL_PVT

Line 42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

38: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
39: l_location VARCHAR2(32767);
40: --
41: --
42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
44: --}
45: BEGIN
46: --{

Line 43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

39: l_location VARCHAR2(32767);
40: --
41: --
42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
44: --}
45: BEGIN
46: --{
47: l_location := '0010';

Line 75: vea_tpa_util_pvt.add_exc_message_and_raise

71: --{
72: WHEN OTHERS
73: THEN
74: --{
75: vea_tpa_util_pvt.add_exc_message_and_raise
76: (
77: p_package_name => G_PACKAGE_NAME,
78: p_api_name => l_api_name,
79: p_location => l_location

Line 108: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

104: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
105: l_location VARCHAR2(32767);
106: --
107: --
108: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
109: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
110: --}
111: BEGIN
112: --{

Line 109: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

105: l_location VARCHAR2(32767);
106: --
107: --
108: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
109: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
110: --}
111: BEGIN
112: --{
113: l_location := '0010';

Line 130: vea_tpa_util_pvt.add_exc_message_and_raise

126: --{
127: WHEN OTHERS
128: THEN
129: --{
130: vea_tpa_util_pvt.add_exc_message_and_raise
131: (
132: p_package_name => G_PACKAGE_NAME,
133: p_api_name => l_api_name,
134: p_location => l_location

Line 160: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

156: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
157: l_location VARCHAR2(32767);
158: --
159: --
160: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
161: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
162: --}
163: BEGIN
164: --{

Line 161: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

157: l_location VARCHAR2(32767);
158: --
159: --
160: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
161: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
162: --}
163: BEGIN
164: --{
165: l_location := '0010';

Line 187: vea_tpa_util_pvt.add_exc_message_and_raise

183: --{
184: WHEN OTHERS
185: THEN
186: --{
187: vea_tpa_util_pvt.add_exc_message_and_raise
188: (
189: p_package_name => G_PACKAGE_NAME,
190: p_api_name => l_api_name,
191: p_location => l_location

Line 230: p_layer_provider_code => vea_tpa_util_pvt.get_curr_layer_provider_code,

226: BEGIN
227: --{
228: FOR tp_layer_rec IN tp_layer_cur
229: (
230: p_layer_provider_code => vea_tpa_util_pvt.get_curr_layer_provider_code,
231: p_tp_layer_name => p_tp_layer_name
232: )
233: LOOP
234: --{

Line 328: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PRIVATE_API;

324: IS
325: --{
326: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
327: l_api_version CONSTANT NUMBER := 1.0;
328: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PRIVATE_API;
329: --
330: --
331: l_location VARCHAR2(32767);
332: --

Line 406: vea_tpa_util_pvt.add_exc_message_and_raise

402: --{
403: WHEN OTHERS
404: THEN
405: --{
406: vea_tpa_util_pvt.add_exc_message_and_raise
407: (
408: p_package_name => G_PACKAGE_NAME,
409: p_api_name => l_api_name,
410: p_location => l_location

Line 437: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;

433: IS
434: --{
435: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
436: l_api_version CONSTANT NUMBER := 1.0;
437: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
438: --
439: --
440: l_location VARCHAR2(32767);
441: l_savepoint_name VARCHAR2(30);

Line 442: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

438: --
439: --
440: l_location VARCHAR2(32767);
441: l_savepoint_name VARCHAR2(30);
442: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
443: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
444: --
445: --
446: CURSOR tp_layer_id_cur

Line 443: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

439: --
440: l_location VARCHAR2(32767);
441: l_savepoint_name VARCHAR2(30);
442: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
443: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
444: --
445: --
446: CURSOR tp_layer_id_cur
447: (

Line 551: vea_tpa_util_pvt.add_exc_message_and_raise

547: --{
548: WHEN OTHERS
549: THEN
550: --{
551: vea_tpa_util_pvt.add_exc_message_and_raise
552: (
553: p_package_name => G_PACKAGE_NAME,
554: p_api_name => l_api_name,
555: p_location => l_location

Line 581: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

577: l_api_name CONSTANT VARCHAR2(30) := 'deleteUnlicensedLayers';
578: l_location VARCHAR2(32767);
579: --
580: --
581: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
582: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
583: --}
584: BEGIN
585: --{

Line 582: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

578: l_location VARCHAR2(32767);
579: --
580: --
581: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
582: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
583: --}
584: BEGIN
585: --{
586: l_location := '0010';

Line 606: vea_tpa_util_pvt.add_exc_message_and_raise

602: --{
603: WHEN OTHERS
604: THEN
605: --{
606: vea_tpa_util_pvt.add_exc_message_and_raise
607: (
608: p_package_name => G_PACKAGE_NAME,
609: p_api_name => l_api_name,
610: p_location => l_location

Line 647: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;

643: IS
644: --{
645: l_api_name CONSTANT VARCHAR2(30) := 'process';
646: l_api_version CONSTANT NUMBER := 1.0;
647: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
648: --
649: --
650: l_location VARCHAR2(32767);
651: l_savepoint_name VARCHAR2(30);

Line 686: IF NOT( vea_tpa_util_pvt.is_vea_installed() )

682: BEGIN
683: --{
684: l_location := '0010';
685: --
686: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
687: THEN
688: RETURN;
689: END IF;
690: --

Line 696: vea_tpa_util_pvt.api_header

692: -- Standard API Header
693: --
694: l_location := '0020';
695: --
696: vea_tpa_util_pvt.api_header
697: (
698: p_package_name => G_PACKAGE_NAME,
699: p_api_name => l_api_name,
700: p_api_type => l_api_type,

Line 739: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code

735: THEN
736: --{
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;

Line 791: vea_tpa_util_pvt.put

787: --
788: --
789: IF p_id IS NOT NULL
790: THEN
791: vea_tpa_util_pvt.put
792: (
793: p_key => p_id,
794: p_value => l_tp_layer_id,
795: x_cache_tbl => vea_tpa_util_pvt.g_tpLyr_fileId_dbId_tbl,

Line 795: x_cache_tbl => vea_tpa_util_pvt.g_tpLyr_fileId_dbId_tbl,

791: vea_tpa_util_pvt.put
792: (
793: p_key => p_id,
794: p_value => l_tp_layer_id,
795: x_cache_tbl => vea_tpa_util_pvt.g_tpLyr_fileId_dbId_tbl,
796: x_cache_ext_tbl => vea_tpa_util_pvt.g_tpLyr_fileId_dbId_ext_tbl
797: );
798: END IF;
799: --

Line 796: x_cache_ext_tbl => vea_tpa_util_pvt.g_tpLyr_fileId_dbId_ext_tbl

792: (
793: p_key => p_id,
794: p_value => l_tp_layer_id,
795: x_cache_tbl => vea_tpa_util_pvt.g_tpLyr_fileId_dbId_tbl,
796: x_cache_ext_tbl => vea_tpa_util_pvt.g_tpLyr_fileId_dbId_ext_tbl
797: );
798: END IF;
799: --
800: --} API Body

Line 807: vea_tpa_util_pvt.api_footer

803: -- Standard API Footer
804: --
805: l_location := '0110';
806: --
807: vea_tpa_util_pvt.api_footer
808: (
809: p_commit => p_commit,
810: x_msg_count => x_msg_count,
811: x_msg_data => x_msg_data

Line 820: vea_tpa_util_pvt.handle_error

816: WHEN FND_API.G_EXC_ERROR
817: THEN
818: --{
819: --RAISE;
820: vea_tpa_util_pvt.handle_error
821: (
822: p_error_type => vea_tpa_util_pvt.G_ERROR,
823: p_savepoint_name => l_savepoint_name,
824: p_package_name => G_PACKAGE_NAME,

Line 822: p_error_type => vea_tpa_util_pvt.G_ERROR,

818: --{
819: --RAISE;
820: vea_tpa_util_pvt.handle_error
821: (
822: p_error_type => vea_tpa_util_pvt.G_ERROR,
823: p_savepoint_name => l_savepoint_name,
824: p_package_name => G_PACKAGE_NAME,
825: p_api_name => l_api_name,
826: p_location => l_location,

Line 836: vea_tpa_util_pvt.handle_error

832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
833: THEN
834: --{
835: --RAISE;
836: vea_tpa_util_pvt.handle_error
837: (
838: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
839: p_savepoint_name => l_savepoint_name,
840: p_package_name => G_PACKAGE_NAME,

Line 838: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

834: --{
835: --RAISE;
836: vea_tpa_util_pvt.handle_error
837: (
838: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
839: p_savepoint_name => l_savepoint_name,
840: p_package_name => G_PACKAGE_NAME,
841: p_api_name => l_api_name,
842: p_location => l_location,

Line 852: vea_tpa_util_pvt.handle_error

848: WHEN OTHERS
849: THEN
850: --{
851: --RAISE;
852: vea_tpa_util_pvt.handle_error
853: (
854: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
855: p_savepoint_name => l_savepoint_name,
856: p_package_name => G_PACKAGE_NAME,

Line 854: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

850: --{
851: --RAISE;
852: vea_tpa_util_pvt.handle_error
853: (
854: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
855: p_savepoint_name => l_savepoint_name,
856: p_package_name => G_PACKAGE_NAME,
857: p_api_name => l_api_name,
858: p_location => l_location,