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_LAYERS_SV dependencies on VEA_PACKAGES

Line 1131: p_package_name IN vea_packages.name%TYPE,

1127:
1128: ========================================================================*/
1129: PROCEDURE
1130: checkConflictingLayers(
1131: p_package_name IN vea_packages.name%TYPE,
1132: p_program_unit_name IN vea_program_units.name%TYPE)
1133: IS
1134: --{
1135: temp varchar2(200);

Line 1389: l_package_name vea_packages.name%TYPE;

1385: --
1386: --
1387: l_program_unit_name vea_program_units.name%TYPE;
1388: l_program_unit_id vea_program_units.program_unit_id%TYPE;
1389: l_package_name vea_packages.name%TYPE;
1390: l_package_id vea_packages.package_id%TYPE;
1391: l_layer_provider_code vea_packages.layer_provider_code%TYPE;
1392: --
1393: --

Line 1390: l_package_id vea_packages.package_id%TYPE;

1386: --
1387: l_program_unit_name vea_program_units.name%TYPE;
1388: l_program_unit_id vea_program_units.program_unit_id%TYPE;
1389: l_package_name vea_packages.name%TYPE;
1390: l_package_id vea_packages.package_id%TYPE;
1391: l_layer_provider_code vea_packages.layer_provider_code%TYPE;
1392: --
1393: --
1394: l_lp_count NUMBER := 0;

Line 1391: l_layer_provider_code vea_packages.layer_provider_code%TYPE;

1387: l_program_unit_name vea_program_units.name%TYPE;
1388: l_program_unit_id vea_program_units.program_unit_id%TYPE;
1389: l_package_name vea_packages.name%TYPE;
1390: l_package_id vea_packages.package_id%TYPE;
1391: l_layer_provider_code vea_packages.layer_provider_code%TYPE;
1392: --
1393: --
1394: l_lp_count NUMBER := 0;
1395: l_chkMultipleLayerProviders BOOLEAN := FALSE;

Line 1406: vea_packages PK,

1402: PK.name package_name ,
1403: PK.package_id ,
1404: PK.layer_provider_code
1405: FROM vea_program_units PU,
1406: vea_packages PK,
1407: vea_layer_headers LH,
1408: vea_layers_v LV
1409: WHERE PU.tps_flag = 'N'
1410: AND PU.layer_provider_code = PK.layer_provider_code

Line 1422: p_package_name IN vea_packages.name%TYPE)

1418: --
1419: --
1420: /*CURSOR layer_cur
1421: ( p_program_unit_name IN vea_program_units.name%TYPE,
1422: p_package_name IN vea_packages.name%TYPE)
1423: */
1424: CURSOR layer_cur
1425: ( p_program_unit_id IN vea_program_units.program_unit_id%TYPE,
1426: p_package_id IN vea_packages.package_id%TYPE,

Line 1426: p_package_id IN vea_packages.package_id%TYPE,

1422: p_package_name IN vea_packages.name%TYPE)
1423: */
1424: CURSOR layer_cur
1425: ( p_program_unit_id IN vea_program_units.program_unit_id%TYPE,
1426: p_package_id IN vea_packages.package_id%TYPE,
1427: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE)
1428: IS
1429: SELECT LA.sequence_number ,
1430: LA.layer_provider_code,

Line 1427: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE)

1423: */
1424: CURSOR layer_cur
1425: ( p_program_unit_id IN vea_program_units.program_unit_id%TYPE,
1426: p_package_id IN vea_packages.package_id%TYPE,
1427: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE)
1428: IS
1429: SELECT LA.sequence_number ,
1430: LA.layer_provider_code,
1431: LA.layer_id,

Line 1457: vea_packages PK

1453: LA.tps_parameter10_value
1454: FROM vea_layers LA,
1455: vea_layer_headers LH,
1456: vea_program_units PU,
1457: vea_packages PK
1458: WHERE PK.package_id = p_package_id
1459: AND PK.layer_provider_code = p_layer_provider_code
1460: AND PK.package_id = PU.package_id
1461: AND PK.layer_provider_code = PU.layer_provider_code

Line 1494: vea_packages PK

1490: INTO l_lp_count
1491: FROM vea_layers LA,
1492: vea_layer_headers LH,
1493: vea_program_units PU,
1494: vea_packages PK
1495: WHERE PK.package_id = l_package_id
1496: AND PK.layer_provider_code = l_layer_provider_code
1497: AND PK.package_id = PU.package_id
1498: AND PK.layer_provider_code = PU.layer_provider_code

Line 1618: vea_packages PK,

1614: PU.name program_unit_name,
1615: PK.name package_name
1616: FROM vea_layer_headers LH,
1617: vea_program_units TPA,
1618: vea_packages PK,
1619: vea_program_units PU,
1620: vea_layers LA,
1621: vea_layer_headers LH1
1622: WHERE LH.layer_provider_code = p_layer_provider_code

Line 2600: VEA_PACKAGES PK

2596: SELECT LA.LAYER_ID LAYER_ID
2597: FROM vea_layers LA,
2598: VEA_TP_LAYERS TL,
2599: VEA_PROGRAM_UNITS PU,
2600: VEA_PACKAGES PK
2601: WHERE TL.TP_LAYER_ID = p_tp_layer_id
2602: AND TL.TP_LAYER_ID = PK.TP_LAYER_ID
2603: AND TL.LAYER_PROVIDER_CODE = p_layer_provider_code
2604: AND TL.LAYER_PROVIDER_CODE = PK.LAYER_PROVIDER_CODE