[Home] [Help]
PACKAGE: APPS.VEA_LAYERPROVIDERS_SV
Source
1 PACKAGE VEA_LAYERPROVIDERS_SV AUTHID CURRENT_USER as
2 /* $Header: VEAVALPS.pls 115.4 2002/12/12 02:20:41 heali noship $ */
3 --{
4 /*======================== vea_layerproviders_sv =======================*/
5 /*========================================================================
6 PURPOSE:
7
8 NOTES: To run the script:
9
10 sql> start VEAVALPS.pls
11
12 HISTORY
13 Created MOHANA NARAYAN 06/05/2000 10:00 AM
14
15 =========================================================================*/
16 --
17 --
18 PROCEDURE
19 delete_rows
20 (
21 p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
22 p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE DEFAULT NULL
23 );
24 --
25 --
26 PROCEDURE
27 insert_row
28 (
29 p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
30 p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
31 p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
32 p_description IN vea_layer_providers.description%TYPE
33 );
34 --
35 --
36 PROCEDURE
37 update_row
38 (
39 p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
40 p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
41 p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
42 p_description IN vea_layer_providers.description%TYPE
43 );
44 --
45 --
46 PROCEDURE
47 validate
48 (
49 p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
50 p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
51 );
52 --
53 --
54 PROCEDURE
55 validateUniqueCodes
56 (
57 p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
58 p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
59 );
60 --
61 --
62 FUNCTION
63 getLayerProviderCode
64 (
65 p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
66 ) RETURN VARCHAR2;
67 --
68 --
69 FUNCTION
70 getLayerProviderName
71 (
72 p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE
73 ) RETURN VARCHAR2;
74 --
75 --
76 PROCEDURE
77 process
78 (
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
87 p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
88 p_description IN vea_layer_providers.description%TYPE
89 );
90 --
91 --
92 --
93 --
94 --}
95 END VEA_LAYERPROVIDERS_SV;