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_LAYER_HEADERS

Line 67: vea_layer_headers LH

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
71: AND PU.program_unit_id = LH.tps_program_unit_id

Line 1407: vea_layer_headers LH,

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
1411: AND PU.package_id = PK.package_id

Line 1455: vea_layer_headers LH,

1451: LA.tps_parameter9_value,
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

Line 1492: vea_layer_headers LH,

1488:
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

Line 1616: FROM vea_layer_headers LH,

1612: SELECT LA.layer_provider_code,
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,

Line 1621: vea_layer_headers LH1

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
1624: AND TPA.layer_provider_code = LH.program_unit_lp_code
1625: AND TPA.program_unit_id = LH.program_unit_id

Line 2165: vea_layer_headers LH,

2161: LA.tp_layer_id,
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

Line 2243: FROM vea_layer_headers LH,

2239: SELECT TLA.tp_layer_id,
2240: TLA.name tp_layer_name,
2241: LH.program_unit_id,
2242: LH.program_unit_lp_code
2243: FROM vea_layer_headers LH,
2244: vea_tp_layers TLA
2245: WHERE LH.layer_provider_code = p_layer_provider_code
2246: AND LH.layer_header_id = p_layer_header_id
2247: AND TLA.layer_provider_code = p_layer_provider_code

Line 2585: l_tps_program_unit_id vea_layer_headers.tps_program_unit_id%TYPE;

2581: l_tps_parameter7_id vea_layers.tps_parameter7_id%TYPE;
2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;
2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;
2584: l_tps_parameter10_id vea_layers.tps_parameter10_id%TYPE;
2585: l_tps_program_unit_id vea_layer_headers.tps_program_unit_id%TYPE;
2586: l_tps_program_unit_lp_code vea_layer_headers.tps_program_unit_lp_code%TYPE;
2587: --
2588: --
2589: CURSOR layer_cur

Line 2586: l_tps_program_unit_lp_code vea_layer_headers.tps_program_unit_lp_code%TYPE;

2582: l_tps_parameter8_id vea_layers.tps_parameter8_id%TYPE;
2583: l_tps_parameter9_id vea_layers.tps_parameter9_id%TYPE;
2584: l_tps_parameter10_id vea_layers.tps_parameter10_id%TYPE;
2585: l_tps_program_unit_id vea_layer_headers.tps_program_unit_id%TYPE;
2586: l_tps_program_unit_lp_code vea_layer_headers.tps_program_unit_lp_code%TYPE;
2587: --
2588: --
2589: CURSOR layer_cur
2590: (

Line 2711: l_layer_header_id := vea_layer_headers_sv.g_layer_header_id;

2707: --
2708: --
2709: l_location := '0027';
2710: --
2711: l_layer_header_id := vea_layer_headers_sv.g_layer_header_id;
2712: l_tp_layer_id := p_tp_layer_id;
2713: l_new_program_unit_id := p_new_program_unit_id;
2714: l_tps_parameter1_id := p_tps_parameter1_id;
2715: l_tps_parameter2_id := p_tps_parameter2_id;

Line 2811: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2807: --
2808:
2809: l_tps_parameter1_id := vea_parameters_sv.getId
2810: (
2811: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2812: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2813: p_name => p_tps_parameter1_name
2814: );
2815: --

Line 2812: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2808:
2809: l_tps_parameter1_id := vea_parameters_sv.getId
2810: (
2811: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2812: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2813: p_name => p_tps_parameter1_name
2814: );
2815: --
2816: --

Line 2836: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2832: l_location := '0140';
2833: --
2834: l_tps_parameter2_id := vea_parameters_sv.getId
2835: (
2836: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2837: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2838: p_name => p_tps_parameter2_name
2839: );
2840: --

Line 2837: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2833: --
2834: l_tps_parameter2_id := vea_parameters_sv.getId
2835: (
2836: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2837: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2838: p_name => p_tps_parameter2_name
2839: );
2840: --
2841: --

Line 2860: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2856: l_location := '0160';
2857: --
2858: l_tps_parameter3_id := vea_parameters_sv.getId
2859: (
2860: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2861: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2862: p_name => p_tps_parameter3_name
2863: );
2864: --

Line 2861: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2857: --
2858: l_tps_parameter3_id := vea_parameters_sv.getId
2859: (
2860: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2861: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2862: p_name => p_tps_parameter3_name
2863: );
2864: --
2865: --

Line 2883: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2879: l_location := '0180';
2880: --
2881: l_tps_parameter4_id := vea_parameters_sv.getId
2882: (
2883: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2884: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2885: p_name => p_tps_parameter4_name
2886: );
2887: --

Line 2884: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2880: --
2881: l_tps_parameter4_id := vea_parameters_sv.getId
2882: (
2883: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2884: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2885: p_name => p_tps_parameter4_name
2886: );
2887: --
2888: --

Line 2906: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2902: l_location := '0200';
2903: --
2904: l_tps_parameter5_id := vea_parameters_sv.getId
2905: (
2906: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2907: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2908: p_name => p_tps_parameter5_name
2909: );
2910: --

Line 2907: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2903: --
2904: l_tps_parameter5_id := vea_parameters_sv.getId
2905: (
2906: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2907: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2908: p_name => p_tps_parameter5_name
2909: );
2910: --
2911: --

Line 2929: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2925: l_location := '0220';
2926: --
2927: l_tps_parameter6_id := vea_parameters_sv.getId
2928: (
2929: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2930: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2931: p_name => p_tps_parameter6_name
2932: );
2933: --

Line 2930: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2926: --
2927: l_tps_parameter6_id := vea_parameters_sv.getId
2928: (
2929: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2930: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2931: p_name => p_tps_parameter6_name
2932: );
2933: --
2934: --

Line 2952: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2948: l_location := '0240';
2949: --
2950: l_tps_parameter7_id := vea_parameters_sv.getId
2951: (
2952: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2953: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2954: p_name => p_tps_parameter7_name
2955: );
2956: --

Line 2953: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2949: --
2950: l_tps_parameter7_id := vea_parameters_sv.getId
2951: (
2952: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2953: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2954: p_name => p_tps_parameter7_name
2955: );
2956: --
2957: --

Line 2975: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2971: l_location := '0260';
2972: --
2973: l_tps_parameter8_id := vea_parameters_sv.getId
2974: (
2975: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2976: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2977: p_name => p_tps_parameter8_name
2978: );
2979: --

Line 2976: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2972: --
2973: l_tps_parameter8_id := vea_parameters_sv.getId
2974: (
2975: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2976: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2977: p_name => p_tps_parameter8_name
2978: );
2979: --
2980: --

Line 2998: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

2994: l_location := '0280';
2995: --
2996: l_tps_parameter9_id := vea_parameters_sv.getId
2997: (
2998: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2999: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
3000: p_name => p_tps_parameter9_name
3001: );
3002: --

Line 2999: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

2995: --
2996: l_tps_parameter9_id := vea_parameters_sv.getId
2997: (
2998: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2999: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
3000: p_name => p_tps_parameter9_name
3001: );
3002: --
3003: --

Line 3021: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,

3017: l_location := '0300';
3018: --
3019: l_tps_parameter10_id := vea_parameters_sv.getId
3020: (
3021: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
3022: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
3023: p_name => p_tps_parameter10_name
3024: );
3025: --

Line 3022: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,

3018: --
3019: l_tps_parameter10_id := vea_parameters_sv.getId
3020: (
3021: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
3022: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
3023: p_name => p_tps_parameter10_name
3024: );
3025: --
3026: --