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_PROGRAM_UNITS

Line 66: vea_program_units PU,

62: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE)
63: IS
64: SELECT PA.name
65: FROM vea_parameters PA,
66: vea_program_units PU,
67: vea_layer_headers LH
68: WHERE PA.parameter_id = p_tps_parameter_id
69: AND LH.layer_provider_code = p_layer_provider_code
70: AND LH.layer_header_id = p_layer_header_id

Line 1132: p_program_unit_name IN vea_program_units.name%TYPE)

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);
1136: l_api_name CONSTANT VARCHAR2(30) := 'checkConflictingLayers';

Line 1387: l_program_unit_name vea_program_units.name%TYPE;

1383: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1384: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
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;

Line 1388: l_program_unit_id vea_program_units.program_unit_id%TYPE;

1384: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
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: --

Line 1405: FROM vea_program_units PU,

1401: PU.program_unit_id ,
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'

Line 1421: ( p_program_unit_name IN vea_program_units.name%TYPE,

1417: AND LV.layer_provider_code = p_layer_provider_code;
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,

Line 1425: ( p_program_unit_id IN vea_program_units.program_unit_id%TYPE,

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,
1427: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE)
1428: IS
1429: SELECT LA.sequence_number ,

Line 1456: vea_program_units PU,

1452: LA.tps_parameter10_id,
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

Line 1493: vea_program_units PU,

1489: SELECT count(distinct LA.layer_provider_code)
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

Line 1617: vea_program_units TPA,

1613: LA.layer_id,
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

Line 1619: vea_program_units PU,

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
1623: AND LH.layer_header_id = p_layer_header_id

Line 2166: vea_program_units PU

2162: LA.tp_layer_name,
2163: LA.active_flag
2164: FROM vea_layers_v LA,
2165: vea_layer_headers LH,
2166: vea_program_units PU
2167: WHERE LA.layer_provider_code = p_layer_provider_code
2168: AND LH.layer_provider_code = LA.layer_provider_code
2169: AND LH.layer_header_id = LA.layer_header_id
2170: AND PU.layer_provider_code = LH.program_unit_lp_code

Line 2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;

2570: l_layer_id vea_layers.layer_id%TYPE;
2571: l_active_flag vea_layers.active_flag%TYPE;
2572: l_layer_header_id vea_layers.layer_header_id%TYPE;
2573: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
2574: l_new_program_unit_id vea_program_units.program_unit_id%TYPE;
2575: l_tps_parameter1_id vea_layers.tps_parameter1_id%TYPE;
2576: l_tps_parameter2_id vea_layers.tps_parameter2_id%TYPE;
2577: l_tps_parameter3_id vea_layers.tps_parameter3_id%TYPE;
2578: l_tps_parameter4_id vea_layers.tps_parameter4_id%TYPE;

Line 2593: p_new_program_unit_id IN vea_program_units.name%TYPE

2589: CURSOR layer_cur
2590: (
2591: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2592: p_tp_layer_id IN vea_tp_layers.name%TYPE,
2593: p_new_program_unit_id IN vea_program_units.name%TYPE
2594: )
2595: IS
2596: SELECT LA.LAYER_ID LAYER_ID
2597: FROM vea_layers LA,

Line 2599: VEA_PROGRAM_UNITS PU,

2595: IS
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