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: /*========================================================================
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:
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
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: );
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,
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,
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,
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,
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,
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,
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,
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,
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,
64: --
65: --
66: --
67: --}
68: END VEA_LAYER_HEADERS_SV;