[Home] [Help]
PACKAGE: APPS.VEA_TP_LAYERS_SV
Source
1 PACKAGE VEA_TP_LAYERS_SV AUTHID CURRENT_USER as
2 /* $Header: VEAVATLS.pls 115.4 2004/07/27 00:06:51 rvishnuv ship $ */
3 --{
4 /*====================== vea_tp_layers_sv =========================*/
5 /*========================================================================
6 PURPOSE:
7
8 NOTES: To run the script:
9
10 sql> start VEAVATLS.pls
11
12 HISTORY
13 Created N PARIKH 09/09/99 10:00 AM
14
15 =========================================================================*/
16 --
17 --
18 --
19 --
20 g_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
21 --
22 --
23 PROCEDURE
24 delete_rows
25 (
26 p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
27 p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
28 p_tp_layer_name IN vea_tp_layers.name%TYPE,
29 p_application_short_name IN vea_packages.application_short_name%TYPE
30 );
31 --
32 --
33 PROCEDURE
34 deleteUnlicensedLayers
35 (
36 p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE
37 );
38 --
39 --
40 FUNCTION
41 get_tp_layer_id
42 (
43 p_tp_layer_name IN vea_tp_layers.name%TYPE
44 )
45 RETURN vea_tp_layers.tp_layer_id%TYPE;
46 --
47 --
48 /*========================================================================
49
50 PROCEDURE NAME: getId
51
52 PURPOSE: Returns TP Layer ID for the specifed TP Layer name
53
54 ========================================================================*/
55 FUNCTION
56 getId
57 (
58 p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
59 p_tp_layer_name IN vea_tp_layers.name%TYPE
60 )
61 RETURN vea_tp_layers.tp_layer_id%TYPE;
62 --
63 --
64 PROCEDURE
65 process
66 (
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69 p_commit IN VARCHAR2 := FND_API.G_FALSE,
70 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
75 p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
76 p_name IN vea_tp_layers.name%TYPE,
77 p_description IN vea_tp_layers.description%TYPE,
78 p_active_flag IN vea_tp_layers.active_flag%TYPE,
79 p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
80 );
81 --
82 --
83 --
84 --
85 --}
86 END VEA_TP_LAYERS_SV;