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

Line 229: p_application_short_name IN vea_packages.application_short_name%TYPE,

225: delete_rows
226: (
227: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
228: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
229: p_application_short_name IN vea_packages.application_short_name%TYPE,
230: x_layer_header_count OUT NOCOPY NUMBER
231: )
232: IS
233: --{

Line 258: p_application_short_name IN vea_packages.application_short_name%TYPE

254: CURSOR application_cur
255: (
256: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
257: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
258: p_application_short_name IN vea_packages.application_short_name%TYPE
259: )
260: IS
261: SELECT 'x'
262: FROM vea_layer_headers LH,

Line 264: vea_packages PK

260: IS
261: SELECT 'x'
262: FROM vea_layer_headers LH,
263: vea_program_units PU,
264: vea_packages PK
265: WHERE LH.layer_provider_code = p_layer_provider_code
266: AND LH.layer_header_id = p_layer_header_id
267: AND PU.program_unit_id = LH.program_unit_id
268: AND PU.layer_provider_code = LH.program_unit_lp_code

Line 417: p_package_name IN vea_packages.name%TYPE,

413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
414: p_condition_type IN vea_layer_headers.condition_type%TYPE,
415: p_description IN vea_layer_headers.description%TYPE,
416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
417: p_package_name IN vea_packages.name%TYPE,
418: p_pkg_app_name IN vea_packages.application_short_name%TYPE,
419: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE,
420: p_program_unit_name IN vea_program_units.name%TYPE,
421: p_tps_package_name IN vea_packages.name%TYPE,

Line 418: p_pkg_app_name IN vea_packages.application_short_name%TYPE,

414: p_condition_type IN vea_layer_headers.condition_type%TYPE,
415: p_description IN vea_layer_headers.description%TYPE,
416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
417: p_package_name IN vea_packages.name%TYPE,
418: p_pkg_app_name IN vea_packages.application_short_name%TYPE,
419: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE,
420: p_program_unit_name IN vea_program_units.name%TYPE,
421: p_tps_package_name IN vea_packages.name%TYPE,
422: p_tps_program_unit_name IN vea_program_units.name%TYPE,

Line 419: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE,

415: p_description IN vea_layer_headers.description%TYPE,
416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
417: p_package_name IN vea_packages.name%TYPE,
418: p_pkg_app_name IN vea_packages.application_short_name%TYPE,
419: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE,
420: p_program_unit_name IN vea_program_units.name%TYPE,
421: p_tps_package_name IN vea_packages.name%TYPE,
422: p_tps_program_unit_name IN vea_program_units.name%TYPE,
423: p_tpsPkg_app_name IN vea_packages.application_short_name%TYPE,

Line 421: p_tps_package_name IN vea_packages.name%TYPE,

417: p_package_name IN vea_packages.name%TYPE,
418: p_pkg_app_name IN vea_packages.application_short_name%TYPE,
419: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE,
420: p_program_unit_name IN vea_program_units.name%TYPE,
421: p_tps_package_name IN vea_packages.name%TYPE,
422: p_tps_program_unit_name IN vea_program_units.name%TYPE,
423: p_tpsPkg_app_name IN vea_packages.application_short_name%TYPE,
424: p_tpsPkg_cs_flag IN vea_packages.client_server_flag%TYPE
425: )

Line 423: p_tpsPkg_app_name IN vea_packages.application_short_name%TYPE,

419: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE,
420: p_program_unit_name IN vea_program_units.name%TYPE,
421: p_tps_package_name IN vea_packages.name%TYPE,
422: p_tps_program_unit_name IN vea_program_units.name%TYPE,
423: p_tpsPkg_app_name IN vea_packages.application_short_name%TYPE,
424: p_tpsPkg_cs_flag IN vea_packages.client_server_flag%TYPE
425: )
426: IS
427: --{

Line 424: p_tpsPkg_cs_flag IN vea_packages.client_server_flag%TYPE

420: p_program_unit_name IN vea_program_units.name%TYPE,
421: p_tps_package_name IN vea_packages.name%TYPE,
422: p_tps_program_unit_name IN vea_program_units.name%TYPE,
423: p_tpsPkg_app_name IN vea_packages.application_short_name%TYPE,
424: p_tpsPkg_cs_flag IN vea_packages.client_server_flag%TYPE
425: )
426: IS
427: --{
428: l_api_name CONSTANT VARCHAR2(30) := 'process';

Line 524: l_package_id := vea_packages_sv.getId

520: --
521: --
522: l_location := '0050';
523: --
524: l_package_id := vea_packages_sv.getId
525: (
526: p_layer_provider_code => p_program_unit_lp_code,
527: p_application_short_name => p_pkg_app_name,
528: p_client_server_flag => p_pkg_cs_flag,

Line 555: l_tps_package_id := vea_packages_sv.getId

551: END LOOP;
552: --
553: l_location := '0070';
554: --
555: l_tps_package_id := vea_packages_sv.getId
556: (
557: p_layer_provider_code => p_tps_program_unit_lp_code,
558: p_application_short_name => p_tpsPkg_app_name,
559: p_client_server_flag => p_tpsPkg_cs_flag,