[Home] [Help]
PACKAGE: APPS.VEA_LAYER_HEADERS_SV
Source
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:
9
10 sql> start VEAVALHS.pls
11
12 HISTORY
13 Created N PARIKH 09/09/99 10:00 AM
14
15 =========================================================================*/
16 --
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
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 );
33 --
34 --
35 PROCEDURE
36 process
37 (
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE,
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,
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,
58 p_tps_package_name IN vea_packages.name%TYPE DEFAULT NULL,
59 p_tps_program_unit_name IN vea_program_units.name%TYPE DEFAULT NULL,
60 p_tpsPkg_app_name IN vea_packages.application_short_name%TYPE DEFAULT NULL,
61 p_tpsPkg_cs_flag IN vea_packages.client_server_flag%TYPE DEFAULT NULL
62 );
63 --
64 --
65 --
66 --
67 --}
68 END VEA_LAYER_HEADERS_SV;