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

Line 248: p_package_id IN vea_packages.package_id%TYPE,

244: delete_rows
245: (
246: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
247: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
248: p_package_id IN vea_packages.package_id%TYPE,
249: p_application_short_name IN vea_packages.application_short_name%TYPE,
250: x_program_unit_count OUT NOCOPY NUMBER,
251: x_tps_program_unit_count OUT NOCOPY NUMBER
252: )

Line 249: p_application_short_name IN vea_packages.application_short_name%TYPE,

245: (
246: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
247: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
248: p_package_id IN vea_packages.package_id%TYPE,
249: p_application_short_name IN vea_packages.application_short_name%TYPE,
250: x_program_unit_count OUT NOCOPY NUMBER,
251: x_tps_program_unit_count OUT NOCOPY NUMBER
252: )
253: IS

Line 262: p_package_id IN vea_packages.package_id%TYPE

258: --
259: CURSOR program_unit_cur
260: (
261: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
262: p_package_id IN vea_packages.package_id%TYPE
263: )
264: IS
265: SELECT program_unit_id,
266: layer_provider_code,

Line 289: p_package_id IN vea_packages.package_id%TYPE,

285: CURSOR application_cur
286: (
287: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
288: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
289: p_package_id IN vea_packages.package_id%TYPE,
290: p_program_unit_id IN vea_program_units.program_unit_id%TYPE
291: )
292: IS
293: SELECT PK.application_short_name

Line 296: vea_packages PK,

292: IS
293: SELECT PK.application_short_name
294: FROM vea_program_units LPU,
295: vea_layer_headers LH,
296: vea_packages PK,
297: vea_program_units PU,
298: vea_layers_v LA
299: WHERE LA.layer_provider_code = p_layer_provider_code
300: AND LA.tp_layer_id = p_tp_layer_id

Line 483: x_package_name OUT NOCOPY vea_packages.name%TYPE

479: (
480: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
481: p_program_unit_id IN vea_program_units.program_unit_id%TYPE,
482: x_program_unit_name OUT NOCOPY vea_program_units.name%TYPE,
483: x_package_name OUT NOCOPY vea_packages.name%TYPE
484: )
485: IS
486: --{
487: l_api_name CONSTANT VARCHAR2(30) := 'getName';

Line 500: vea_packages PK

496: IS
497: SELECT PU.name program_unit_name,
498: PK.name package_name
499: FROM vea_program_units PU,
500: vea_packages PK
501: WHERE PU.layer_provider_code = p_layer_provider_code
502: AND PU.program_unit_id = p_program_unit_id
503: AND PK.layer_provider_code = PU.layer_provider_code
504: AND PK.package_id = PU.package_id;

Line 562: l_package_name vea_packages.name%TYPE;

558: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
559: --
560: --
561: l_program_unit_name vea_program_units.name%TYPE;
562: l_package_name vea_packages.name%TYPE;
563: l_pub_program_unit_name vea_program_units.name%TYPE;
564: l_pub_package_name vea_packages.name%TYPE;
565: l_tpa_program_unit_name vea_program_units.name%TYPE;
566: l_tpa_package_name vea_packages.name%TYPE;

Line 564: l_pub_package_name vea_packages.name%TYPE;

560: --
561: l_program_unit_name vea_program_units.name%TYPE;
562: l_package_name vea_packages.name%TYPE;
563: l_pub_program_unit_name vea_program_units.name%TYPE;
564: l_pub_package_name vea_packages.name%TYPE;
565: l_tpa_program_unit_name vea_program_units.name%TYPE;
566: l_tpa_package_name vea_packages.name%TYPE;
567: --}
568: BEGIN

Line 566: l_tpa_package_name vea_packages.name%TYPE;

562: l_package_name vea_packages.name%TYPE;
563: l_pub_program_unit_name vea_program_units.name%TYPE;
564: l_pub_package_name vea_packages.name%TYPE;
565: l_tpa_program_unit_name vea_program_units.name%TYPE;
566: l_tpa_package_name vea_packages.name%TYPE;
567: --}
568: BEGIN
569: --{
570: l_location := '0010';

Line 836: l_package_id vea_packages.package_id%TYPE;

832: l_savepoint_name VARCHAR2(30);
833: l_program_unit_id vea_program_units.program_unit_id%TYPE;
834: l_db_tpa_program_unit_id vea_program_units.tpa_program_unit_id%TYPE;
835: l_tpa_program_unit_id vea_program_units.tpa_program_unit_id%TYPE;
836: l_package_id vea_packages.package_id%TYPE;
837: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
838: --
839: --
840: CURSOR program_unit_cur

Line 913: --l_package_id := nvl(vea_packages_sv.g_package_id,p_package_id);

909: --
910: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN
911: --{
912: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_package_id ' || p_package_id);
913: --l_package_id := nvl(vea_packages_sv.g_package_id,p_package_id);
914: l_location := '0040';
915: --
916: l_package_id := vea_packages_sv.g_package_id;
917: l_tp_layer_id := nvl(vea_packages_sv.g_tp_layer_id,p_tp_layer_id);

Line 916: l_package_id := vea_packages_sv.g_package_id;

912: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_package_id ' || p_package_id);
913: --l_package_id := nvl(vea_packages_sv.g_package_id,p_package_id);
914: l_location := '0040';
915: --
916: l_package_id := vea_packages_sv.g_package_id;
917: l_tp_layer_id := nvl(vea_packages_sv.g_tp_layer_id,p_tp_layer_id);
918: --
919: --
920: IF p_tpa_program_unit_id IS NOT NULL

Line 917: l_tp_layer_id := nvl(vea_packages_sv.g_tp_layer_id,p_tp_layer_id);

913: --l_package_id := nvl(vea_packages_sv.g_package_id,p_package_id);
914: l_location := '0040';
915: --
916: l_package_id := vea_packages_sv.g_package_id;
917: l_tp_layer_id := nvl(vea_packages_sv.g_tp_layer_id,p_tp_layer_id);
918: --
919: --
920: IF p_tpa_program_unit_id IS NOT NULL
921: THEN