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_LAYER_HEADERS

Line 1: PACKAGE VEA_LAYER_HEADERS_SV AUTHID CURRENT_USER as

1: PACKAGE VEA_LAYER_HEADERS_SV AUTHID CURRENT_USER as
2: /* $Header: VEAVALHS.pls 115.8 2004/07/27 00:07:48 rvishnuv ship $ */
3: --{
4: /*====================== vea_layer_headers_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_layer_headers_sv =========================/

1: PACKAGE VEA_LAYER_HEADERS_SV AUTHID CURRENT_USER as
2: /* $Header: VEAVALHS.pls 115.8 2004/07/27 00:07:48 rvishnuv ship $ */
3: --{
4: /*====================== vea_layer_headers_sv =========================*/
5: /*========================================================================
6: PURPOSE:
7:
8: NOTES: To run the script:

Line 21: g_tps_program_unit_lp_code vea_layer_headers.layer_provider_code%TYPE;

17: --
18: g_program_unit_id NUMBER;
19: g_tpa_program_unit_id NUMBER;
20: g_tps_program_unit_id NUMBER;
21: g_tps_program_unit_lp_code vea_layer_headers.layer_provider_code%TYPE;
22: g_layer_header_id NUMBER;
23: --
24: --
25: PROCEDURE

Line 28: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

24: --
25: PROCEDURE
26: delete_rows
27: (
28: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
29: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
30: p_application_short_name IN vea_packages.application_short_name%TYPE,
31: x_layer_header_count OUT NOCOPY NUMBER
32: );

Line 45: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,

41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
46: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
47: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,

Line 46: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
46: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
47: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,

Line 47: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,

43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
46: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
47: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
51: p_condition_type IN vea_layer_headers.condition_type%TYPE,

Line 48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,

44: x_msg_data OUT NOCOPY VARCHAR2,
45: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
46: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
47: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
51: p_condition_type IN vea_layer_headers.condition_type%TYPE,
52: p_description IN vea_layer_headers.description%TYPE,

Line 49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,

45: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
46: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
47: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
51: p_condition_type IN vea_layer_headers.condition_type%TYPE,
52: p_description IN vea_layer_headers.description%TYPE,
53: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,

Line 50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,

46: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
47: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
51: p_condition_type IN vea_layer_headers.condition_type%TYPE,
52: p_description IN vea_layer_headers.description%TYPE,
53: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
54: p_package_name IN vea_packages.name%TYPE DEFAULT NULL,

Line 51: p_condition_type IN vea_layer_headers.condition_type%TYPE,

47: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
51: p_condition_type IN vea_layer_headers.condition_type%TYPE,
52: p_description IN vea_layer_headers.description%TYPE,
53: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
54: p_package_name IN vea_packages.name%TYPE DEFAULT NULL,
55: p_pkg_app_name IN vea_packages.application_short_name%TYPE DEFAULT NULL,

Line 52: p_description IN vea_layer_headers.description%TYPE,

48: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
51: p_condition_type IN vea_layer_headers.condition_type%TYPE,
52: p_description IN vea_layer_headers.description%TYPE,
53: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
54: p_package_name IN vea_packages.name%TYPE DEFAULT NULL,
55: p_pkg_app_name IN vea_packages.application_short_name%TYPE DEFAULT NULL,
56: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE DEFAULT NULL,

Line 53: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,

49: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
50: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
51: p_condition_type IN vea_layer_headers.condition_type%TYPE,
52: p_description IN vea_layer_headers.description%TYPE,
53: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
54: p_package_name IN vea_packages.name%TYPE DEFAULT NULL,
55: p_pkg_app_name IN vea_packages.application_short_name%TYPE DEFAULT NULL,
56: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE DEFAULT NULL,
57: p_program_unit_name IN vea_program_units.name%TYPE DEFAULT NULL,

Line 68: END VEA_LAYER_HEADERS_SV;

64: --
65: --
66: --
67: --}
68: END VEA_LAYER_HEADERS_SV;