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_TPA_UTIL_PVT dependencies on VEA_TPA_UTIL_PVT

Line 1: PACKAGE BODY VEA_TPA_UTIL_PVT as

1: PACKAGE BODY VEA_TPA_UTIL_PVT as
2: /* $Header: VEATUTLB.pls 115.18 2004/07/27 00:08:33 rvishnuv ship $ */
3: --{
4: /*======================== vea_tpa_util_pvt ===========================*/
5: /*========================================================================

Line 4: /======================== vea_tpa_util_pvt ===========================/

1: PACKAGE BODY VEA_TPA_UTIL_PVT as
2: /* $Header: VEATUTLB.pls 115.18 2004/07/27 00:08:33 rvishnuv ship $ */
3: --{
4: /*======================== vea_tpa_util_pvt ===========================*/
5: /*========================================================================
6: PURPOSE: TPA Utilities Package
7:
8: NOTES: To run the script:

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

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

Line 231: vea_tpa_util_pvt.set_message

227: THEN
228: --{
229: l_location := '0020';
230: --
231: vea_tpa_util_pvt.set_message
232: (
233: p_error_name => p_error_name,
234: p_token1 => p_token1,
235: p_value1 => p_value1,

Line 312: vea_tpa_util_pvt.set_message

308: THEN
309: --{
310: l_location := '0020';
311: --
312: vea_tpa_util_pvt.set_message
313: (
314: p_error_name => p_error_name,
315: p_token1 => p_token1,
316: p_value1 => p_value1,

Line 389: vea_tpa_util_pvt.add_message

385: THEN
386: --{
387: l_location := '0020';
388: --
389: vea_tpa_util_pvt.add_message
390: (
391: p_error_name => p_error_name,
392: p_token1 => p_token1,
393: p_value1 => p_value1,

Line 447: vea_tpa_util_pvt.add_message

443: BEGIN
444: --{
445: l_location := '0010';
446: --
447: vea_tpa_util_pvt.add_message
448: (
449: p_error_name => 'VEA_PLSQL_UNEXPECTED_ERROR',
450: p_token1 => 'PACKAGE_NAME',
451: p_value1 => p_package_name,

Line 492: vea_tpa_util_pvt.add_exc_message

488: --{
489: l_location := '0010';
490: --
491: --
492: vea_tpa_util_pvt.add_exc_message
493: (
494: p_package_name => p_package_name,
495: p_api_name => p_api_name,
496: p_location => p_location

Line 502: RAISE vea_tpa_util_pvt.e_unexpected_error;

498: --
499: --
500: l_location := '0020';
501: --
502: RAISE vea_tpa_util_pvt.e_unexpected_error;
503: --}
504: EXCEPTION
505: --{
506: WHEN OTHERS THEN

Line 579: vea_tpa_util_pvt.add_exc_message

575: --THEN
576: --{
577: l_location := '0070';
578: --
579: vea_tpa_util_pvt.add_exc_message
580: (
581: p_package_name => p_package_name,
582: p_api_name => p_api_name,
583: p_location => p_location

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

1110: IS
1111: --{
1112: l_api_name CONSTANT VARCHAR2(30) := 'get_constants';
1113: l_api_version CONSTANT NUMBER := 1.0;
1114: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
1115: --
1116: --
1117: l_location VARCHAR2(32767);
1118: l_savepoint_name VARCHAR2(30);

Line 1127: vea_tpa_util_pvt.api_header

1123: -- Standard API Header
1124: --
1125: l_location := '0010';
1126: --
1127: vea_tpa_util_pvt.api_header
1128: (
1129: p_package_name => G_PACKAGE_NAME,
1130: p_api_name => l_api_name,
1131: p_api_type => l_api_type,

Line 1172: vea_tpa_util_pvt.api_footer

1168: -- Standard API Footer
1169: --
1170: l_location := '0040';
1171: --
1172: vea_tpa_util_pvt.api_footer
1173: (
1174: p_commit => p_commit,
1175: x_msg_count => x_msg_count,
1176: x_msg_data => x_msg_data

Line 1185: vea_tpa_util_pvt.handle_error

1181: WHEN FND_API.G_EXC_ERROR
1182: THEN
1183: --{
1184: --RAISE;
1185: vea_tpa_util_pvt.handle_error
1186: (
1187: p_error_type => vea_tpa_util_pvt.G_ERROR,
1188: p_savepoint_name => l_savepoint_name,
1189: p_package_name => G_PACKAGE_NAME,

Line 1187: p_error_type => vea_tpa_util_pvt.G_ERROR,

1183: --{
1184: --RAISE;
1185: vea_tpa_util_pvt.handle_error
1186: (
1187: p_error_type => vea_tpa_util_pvt.G_ERROR,
1188: p_savepoint_name => l_savepoint_name,
1189: p_package_name => G_PACKAGE_NAME,
1190: p_api_name => l_api_name,
1191: p_location => l_location,

Line 1201: vea_tpa_util_pvt.handle_error

1197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1198: THEN
1199: --{
1200: --RAISE;
1201: vea_tpa_util_pvt.handle_error
1202: (
1203: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1204: p_savepoint_name => l_savepoint_name,
1205: p_package_name => G_PACKAGE_NAME,

Line 1203: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

1199: --{
1200: --RAISE;
1201: vea_tpa_util_pvt.handle_error
1202: (
1203: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1204: p_savepoint_name => l_savepoint_name,
1205: p_package_name => G_PACKAGE_NAME,
1206: p_api_name => l_api_name,
1207: p_location => l_location,

Line 1217: vea_tpa_util_pvt.handle_error

1213: WHEN OTHERS
1214: THEN
1215: --{
1216: --RAISE;
1217: vea_tpa_util_pvt.handle_error
1218: (
1219: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1220: p_savepoint_name => l_savepoint_name,
1221: p_package_name => G_PACKAGE_NAME,

Line 1219: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

1215: --{
1216: --RAISE;
1217: vea_tpa_util_pvt.handle_error
1218: (
1219: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1220: p_savepoint_name => l_savepoint_name,
1221: p_package_name => G_PACKAGE_NAME,
1222: p_api_name => l_api_name,
1223: p_location => l_location,

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

1252: IS
1253: --{
1254: l_api_name CONSTANT VARCHAR2(30) := 'isVEAInstalled';
1255: l_api_version CONSTANT NUMBER := 1.0;
1256: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
1257: --
1258: --
1259: l_location VARCHAR2(32767);
1260: l_savepoint_name VARCHAR2(30);

Line 1271: vea_tpa_util_pvt.api_header

1267: -- Standard API Header
1268: --
1269: l_location := '0010';
1270: --
1271: vea_tpa_util_pvt.api_header
1272: (
1273: p_package_name => G_PACKAGE_NAME,
1274: p_api_name => l_api_name,
1275: p_api_type => l_api_type,

Line 1299: vea_tpa_util_pvt.api_footer

1295: -- Standard API Footer
1296: --
1297: l_location := '0030';
1298: --
1299: vea_tpa_util_pvt.api_footer
1300: (
1301: p_commit => p_commit,
1302: x_msg_count => x_msg_count,
1303: x_msg_data => x_msg_data

Line 1312: vea_tpa_util_pvt.handle_error

1308: WHEN FND_API.G_EXC_ERROR
1309: THEN
1310: --{
1311: --RAISE;
1312: vea_tpa_util_pvt.handle_error
1313: (
1314: p_error_type => vea_tpa_util_pvt.G_ERROR,
1315: p_savepoint_name => l_savepoint_name,
1316: p_package_name => G_PACKAGE_NAME,

Line 1314: p_error_type => vea_tpa_util_pvt.G_ERROR,

1310: --{
1311: --RAISE;
1312: vea_tpa_util_pvt.handle_error
1313: (
1314: p_error_type => vea_tpa_util_pvt.G_ERROR,
1315: p_savepoint_name => l_savepoint_name,
1316: p_package_name => G_PACKAGE_NAME,
1317: p_api_name => l_api_name,
1318: p_location => l_location,

Line 1328: vea_tpa_util_pvt.handle_error

1324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1325: THEN
1326: --{
1327: --RAISE;
1328: vea_tpa_util_pvt.handle_error
1329: (
1330: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1331: p_savepoint_name => l_savepoint_name,
1332: p_package_name => G_PACKAGE_NAME,

Line 1330: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

1326: --{
1327: --RAISE;
1328: vea_tpa_util_pvt.handle_error
1329: (
1330: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1331: p_savepoint_name => l_savepoint_name,
1332: p_package_name => G_PACKAGE_NAME,
1333: p_api_name => l_api_name,
1334: p_location => l_location,

Line 1344: vea_tpa_util_pvt.handle_error

1340: WHEN OTHERS
1341: THEN
1342: --{
1343: --RAISE;
1344: vea_tpa_util_pvt.handle_error
1345: (
1346: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1347: p_savepoint_name => l_savepoint_name,
1348: p_package_name => G_PACKAGE_NAME,

Line 1346: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

1342: --{
1343: --RAISE;
1344: vea_tpa_util_pvt.handle_error
1345: (
1346: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1347: p_savepoint_name => l_savepoint_name,
1348: p_package_name => G_PACKAGE_NAME,
1349: p_api_name => l_api_name,
1350: p_location => l_location,

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

1435: IS
1436: --{
1437: l_api_name CONSTANT VARCHAR2(30) := 'preProcess';
1438: l_api_version CONSTANT NUMBER := 1.0;
1439: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
1440: --
1441: --
1442: l_location VARCHAR2(32767);
1443: l_savepoint_name VARCHAR2(30);

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

1450: BEGIN
1451: --{
1452: l_location := '0010';
1453: --
1454: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
1455: THEN
1456: RETURN;
1457: END IF;
1458: --

Line 1464: vea_tpa_util_pvt.api_header

1460: -- Standard API Header
1461: --
1462: l_location := '0020';
1463: --
1464: vea_tpa_util_pvt.api_header
1465: (
1466: p_package_name => G_PACKAGE_NAME,
1467: p_api_name => l_api_name,
1468: p_api_type => l_api_type,

Line 1532: vea_tpa_util_pvt.api_footer

1528: -- Standard API Footer
1529: --
1530: l_location := '0070';
1531: --
1532: vea_tpa_util_pvt.api_footer
1533: (
1534: p_commit => p_commit,
1535: x_msg_count => x_msg_count,
1536: x_msg_data => x_msg_data

Line 1545: vea_tpa_util_pvt.handle_error

1541: WHEN FND_API.G_EXC_ERROR
1542: THEN
1543: --{
1544: --RAISE;
1545: vea_tpa_util_pvt.handle_error
1546: (
1547: p_error_type => vea_tpa_util_pvt.G_ERROR,
1548: p_savepoint_name => l_savepoint_name,
1549: p_package_name => G_PACKAGE_NAME,

Line 1547: p_error_type => vea_tpa_util_pvt.G_ERROR,

1543: --{
1544: --RAISE;
1545: vea_tpa_util_pvt.handle_error
1546: (
1547: p_error_type => vea_tpa_util_pvt.G_ERROR,
1548: p_savepoint_name => l_savepoint_name,
1549: p_package_name => G_PACKAGE_NAME,
1550: p_api_name => l_api_name,
1551: p_location => l_location,

Line 1561: vea_tpa_util_pvt.handle_error

1557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1558: THEN
1559: --{
1560: --RAISE;
1561: vea_tpa_util_pvt.handle_error
1562: (
1563: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1564: p_savepoint_name => l_savepoint_name,
1565: p_package_name => G_PACKAGE_NAME,

Line 1563: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

1559: --{
1560: --RAISE;
1561: vea_tpa_util_pvt.handle_error
1562: (
1563: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1564: p_savepoint_name => l_savepoint_name,
1565: p_package_name => G_PACKAGE_NAME,
1566: p_api_name => l_api_name,
1567: p_location => l_location,

Line 1577: vea_tpa_util_pvt.handle_error

1573: WHEN OTHERS
1574: THEN
1575: --{
1576: --RAISE;
1577: vea_tpa_util_pvt.handle_error
1578: (
1579: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1580: p_savepoint_name => l_savepoint_name,
1581: p_package_name => G_PACKAGE_NAME,

Line 1579: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

1575: --{
1576: --RAISE;
1577: vea_tpa_util_pvt.handle_error
1578: (
1579: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1580: p_savepoint_name => l_savepoint_name,
1581: p_package_name => G_PACKAGE_NAME,
1582: p_api_name => l_api_name,
1583: p_location => l_location,

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

1622: IS
1623: --{
1624: l_api_name CONSTANT VARCHAR2(30) := 'postProcess';
1625: l_api_version CONSTANT NUMBER := 1.0;
1626: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
1627: --
1628: --
1629: l_location VARCHAR2(32767);
1630: l_savepoint_name VARCHAR2(30);

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

1638: BEGIN
1639: --{
1640: l_location := '0010';
1641: --
1642: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
1643: THEN
1644: RETURN;
1645: END IF;
1646: --

Line 1654: vea_tpa_util_pvt.api_header

1650: l_location := '0020';
1651:
1652:
1653: --
1654: vea_tpa_util_pvt.api_header
1655: (
1656: p_package_name => G_PACKAGE_NAME,
1657: p_api_name => l_api_name,
1658: p_api_type => l_api_type,

Line 1685: vea_tpa_util_pvt.get

1681: --
1682: --
1683: l_location := '0050';
1684: --
1685: vea_tpa_util_pvt.get
1686: (
1687: p_key => g_pend_puId_tpaPUId_tbl(l_index).value,
1688: p_cache_tbl => g_PU_fileId_dbId_tbl,
1689: p_cache_ext_tbl => g_PU_fileId_dbId_ext_tbl,

Line 1733: vea_tpa_util_pvt.get

1729: --
1730: --
1731: l_location := '0100';
1732: --
1733: vea_tpa_util_pvt.get
1734: (
1735: p_key => g_pend_puId_tpaPUId_ext_tbl(l_index).value,
1736: p_cache_tbl => g_PU_fileId_dbId_tbl,
1737: p_cache_ext_tbl => g_PU_fileId_dbId_ext_tbl,

Line 1829: vea_tpa_util_pvt.api_footer

1825: -- Standard API Footer
1826: --
1827: l_location := '0180';
1828: --
1829: vea_tpa_util_pvt.api_footer
1830: (
1831: p_commit => p_commit,
1832: x_msg_count => x_msg_count,
1833: x_msg_data => x_msg_data

Line 1842: vea_tpa_util_pvt.handle_error

1838: WHEN FND_API.G_EXC_ERROR
1839: THEN
1840: --{
1841: --RAISE;
1842: vea_tpa_util_pvt.handle_error
1843: (
1844: p_error_type => vea_tpa_util_pvt.G_ERROR,
1845: p_savepoint_name => l_savepoint_name,
1846: p_package_name => G_PACKAGE_NAME,

Line 1844: p_error_type => vea_tpa_util_pvt.G_ERROR,

1840: --{
1841: --RAISE;
1842: vea_tpa_util_pvt.handle_error
1843: (
1844: p_error_type => vea_tpa_util_pvt.G_ERROR,
1845: p_savepoint_name => l_savepoint_name,
1846: p_package_name => G_PACKAGE_NAME,
1847: p_api_name => l_api_name,
1848: p_location => l_location,

Line 1858: vea_tpa_util_pvt.handle_error

1854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1855: THEN
1856: --{
1857: --RAISE;
1858: vea_tpa_util_pvt.handle_error
1859: (
1860: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1861: p_savepoint_name => l_savepoint_name,
1862: p_package_name => G_PACKAGE_NAME,

Line 1860: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

1856: --{
1857: --RAISE;
1858: vea_tpa_util_pvt.handle_error
1859: (
1860: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1861: p_savepoint_name => l_savepoint_name,
1862: p_package_name => G_PACKAGE_NAME,
1863: p_api_name => l_api_name,
1864: p_location => l_location,

Line 1874: vea_tpa_util_pvt.handle_error

1870: WHEN OTHERS
1871: THEN
1872: --{
1873: --RAISE;
1874: vea_tpa_util_pvt.handle_error
1875: (
1876: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1877: p_savepoint_name => l_savepoint_name,
1878: p_package_name => G_PACKAGE_NAME,

Line 1876: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

1872: --{
1873: --RAISE;
1874: vea_tpa_util_pvt.handle_error
1875: (
1876: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1877: p_savepoint_name => l_savepoint_name,
1878: p_package_name => G_PACKAGE_NAME,
1879: p_api_name => l_api_name,
1880: p_location => l_location,

Line 2265: vea_tpa_util_pvt.get_user_id,

2261: 'N',
2262: 'N',
2263: 'N',
2264: 'N',
2265: vea_tpa_util_pvt.get_user_id,
2266: SYSDATE,
2267: SYSDATE,
2268: vea_tpa_util_pvt.get_user_id,
2269: vea_tpa_util_pvt.get_login_id

Line 2268: vea_tpa_util_pvt.get_user_id,

2264: 'N',
2265: vea_tpa_util_pvt.get_user_id,
2266: SYSDATE,
2267: SYSDATE,
2268: vea_tpa_util_pvt.get_user_id,
2269: vea_tpa_util_pvt.get_login_id
2270: );
2271: --}
2272: EXCEPTION

Line 2269: vea_tpa_util_pvt.get_login_id

2265: vea_tpa_util_pvt.get_user_id,
2266: SYSDATE,
2267: SYSDATE,
2268: vea_tpa_util_pvt.get_user_id,
2269: vea_tpa_util_pvt.get_login_id
2270: );
2271: --}
2272: EXCEPTION
2273: --{

Line 2356: vea_tpa_util_pvt.insert_ece_xref_category

2352: --
2353: --
2354: l_location := '0060';
2355: --
2356: vea_tpa_util_pvt.insert_ece_xref_category
2357: (
2358: p_category_id => l_xref_category_id,
2359: p_category_code => p_category_code,
2360: p_description => p_description

Line 2440: vea_tpa_util_pvt.get_user_id,

2436: p_key1,
2437: p_ext_value,
2438: p_ext_value,
2439: 'BOTH',
2440: vea_tpa_util_pvt.get_user_id,
2441: SYSDATE,
2442: SYSDATE,
2443: vea_tpa_util_pvt.get_user_id,
2444: vea_tpa_util_pvt.get_login_id

Line 2443: vea_tpa_util_pvt.get_user_id,

2439: 'BOTH',
2440: vea_tpa_util_pvt.get_user_id,
2441: SYSDATE,
2442: SYSDATE,
2443: vea_tpa_util_pvt.get_user_id,
2444: vea_tpa_util_pvt.get_login_id
2445: );
2446: --}
2447: EXCEPTION

Line 2444: vea_tpa_util_pvt.get_login_id

2440: vea_tpa_util_pvt.get_user_id,
2441: SYSDATE,
2442: SYSDATE,
2443: vea_tpa_util_pvt.get_user_id,
2444: vea_tpa_util_pvt.get_login_id
2445: );
2446: --}
2447: EXCEPTION
2448: --{

Line 2543: vea_tpa_util_pvt.insert_ece_xref_data

2539: --
2540: --
2541: l_location := '0060';
2542: --
2543: vea_tpa_util_pvt.insert_ece_xref_data
2544: (
2545: p_data_id => l_xref_data_id,
2546: p_category_id => p_category_id,
2547: p_category_code => p_category_code,

Line 2556: vea_tpa_util_pvt.add_message

2552: --
2553: --
2554: l_location := '0070';
2555: --
2556: vea_tpa_util_pvt.add_message
2557: (
2558: p_error_name => 'VEA_LM_NEW_ECE_XREF_DATA',
2559: p_token1 => 'ECE_XREF_CATEGORY_CODE',
2560: p_value1 => p_category_code,

Line 2714: vea_tpa_util_pvt.get_ece_xref_category_code

2710: --
2711: --
2712: RETURN
2713: (
2714: vea_tpa_util_pvt.get_ece_xref_category_code
2715: (
2716: p_tps_parameter_name => parameter_rec.name
2717: )
2718: );

Line 2780: vea_tpa_util_pvt.get_ece_xref_category_code

2776: l_location := '0020';
2777: --
2778: l_ece_xref_category_code
2779: :=
2780: vea_tpa_util_pvt.get_ece_xref_category_code
2781: (
2782: p_layer_provider_code => p_layer_provider_code,
2783: p_layer_header_id => p_layer_header_id,
2784: p_tps_parameter_id => p_tps_parameter_id

Line 2799: vea_tpa_util_pvt.process_ece_xref_category

2795: l_location := '0040';
2796: --
2797: l_xref_category_id
2798: :=
2799: vea_tpa_util_pvt.process_ece_xref_category
2800: (
2801: p_category_code => l_ece_xref_category_code
2802: );
2803: --

Line 2807: vea_tpa_util_pvt.process_ece_xref_data

2803: --
2804: --
2805: l_location := '0050';
2806: --
2807: vea_tpa_util_pvt.process_ece_xref_data
2808: (
2809: p_category_id => l_xref_category_id,
2810: p_category_code => l_ece_xref_category_code,
2811: p_key1 => p_layer_provider_code,

Line 2848: x_code_conversion_tbl IN OUT NOCOPY vea_tpa_util_pvt.g_code_conversion_tbl_type

2844: (
2845: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
2846: p_parameter_name IN vea_parameters.name%TYPE,
2847: p_external_value IN ece_xref_data.xref_ext_value1%TYPE,
2848: x_code_conversion_tbl IN OUT NOCOPY vea_tpa_util_pvt.g_code_conversion_tbl_type
2849: )
2850: RETURN ece_xref_data.xref_int_value%TYPE
2851: IS
2852: --{

Line 2858: l_code_conversion_rec vea_tpa_util_pvt.g_code_conversion_rec_type;

2854: --
2855: --
2856: l_parameter_name vea_parameters.name%TYPE;
2857: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
2858: l_code_conversion_rec vea_tpa_util_pvt.g_code_conversion_rec_type;
2859: l_internal_value ece_xref_data.xref_int_value%TYPE;
2860: --
2861: --
2862: l_return_status VARCHAR2(32767);

Line 2899: vea_tpa_util_pvt.get_ece_xref_category_code

2895: --
2896: --
2897: l_ece_xref_category_code
2898: :=
2899: vea_tpa_util_pvt.get_ece_xref_category_code
2900: (
2901: p_tps_parameter_name => l_parameter_name
2902: );
2903: --

Line 3036: vea_tpa_util_pvt.get_ece_xref_category_code

3032: --
3033: --
3034: l_ece_xref_category_code
3035: :=
3036: vea_tpa_util_pvt.get_ece_xref_category_code
3037: (
3038: p_tps_parameter_name => l_parameter_name
3039: );
3040: --

Line 3162: vea_tpa_util_pvt.get_ece_xref_category_code

3158: --
3159: --
3160: l_ece_xref_category_code
3161: :=
3162: vea_tpa_util_pvt.get_ece_xref_category_code
3163: (
3164: p_tps_parameter_name => l_parameter_name
3165: );
3166: --

Line 3335: vea_tpa_util_pvt.set_message

3331: --{
3332: l_location := '0010';
3333: --
3334: --
3335: vea_tpa_util_pvt.set_message
3336: (
3337: p_error_name => p_error_name,
3338: p_token1 => p_token1,
3339: p_value1 => p_value1,

Line 3635: END VEA_TPA_UTIL_PVT;

3631: --
3632: --
3633:
3634: --}
3635: END VEA_TPA_UTIL_PVT;