[Home] [Help]
PACKAGE: APPS.VEA_PACKAGES_SV
Source
1 PACKAGE VEA_PACKAGES_SV AUTHID CURRENT_USER as
2 /* $Header: VEAVAPKS.pls 115.13 2004/07/27 00:06:05 rvishnuv ship $ */
3 --{
4 /*======================== vea_packages_sv =============================*/
5 /*========================================================================
6 PURPOSE:
7
8 NOTES: To run the script:
9
10 sql> start VEAVAPKS.pls
11
12 HISTORY
13 Created N PARIKH 09/09/99 10:00 AM
14
15 =========================================================================*/
16 --
17 --
18 g_package_id NUMBER;
19 g_tp_layer_id NUMBER;
20 --
21 --
22 PROCEDURE
23 deleteUnreferencedPackages;
24 --
25 --
26 PROCEDURE
27 delete_rows
28 (
29 p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
30 p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
31 p_application_short_name IN vea_packages.application_short_name%TYPE,
32 x_package_count OUT NOCOPY NUMBER
33 );
34 --
35 --
36 PROCEDURE
37 updateVersionNumber
38 (
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41 p_commit IN VARCHAR2 := FND_API.G_FALSE,
42 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
47 p_package_id IN vea_packages.package_id%TYPE,
48 x_version_number OUT NOCOPY VARCHAR2,
49 p_user_name IN VARCHAR2
50 );
51 --
52 --
53 PROCEDURE
54 updateVersionNumber
55 (
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58 p_commit IN VARCHAR2 := FND_API.G_FALSE,
59 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_application_short_name IN vea_packages.application_short_name%TYPE,
64 p_specification_filename IN vea_packages.specification_filename%TYPE,
65 x_version_number OUT NOCOPY VARCHAR2,
66 p_user_name IN VARCHAR2
67 );
68 --
69 --
70 FUNCTION
71 getId
72 (
73 p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
74 p_client_server_flag IN vea_packages.client_server_flag%TYPE,
75 p_name IN vea_packages.name%TYPE,
76 p_application_short_name IN vea_packages.application_short_name%TYPE
77 )
78 RETURN NUMBER;
79 --
80 --
81 PROCEDURE
82 process
83 (
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_id OUT NOCOPY vea_packages.package_id%TYPE,
92 p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
93 p_client_server_flag IN vea_packages.client_server_flag%TYPE,
94 p_generate_flag IN vea_packages.generate_flag%TYPE,
95 p_tpa_flag IN vea_packages.tpa_flag%TYPE,
96 p_name IN vea_packages.name%TYPE,
97 p_specification_filename IN vea_packages.specification_filename%TYPE,
98 p_body_filename IN vea_packages.body_filename%TYPE,
99 p_label IN vea_packages.label%TYPE,
100 p_version_number IN vea_packages.version_number%TYPE,
101 p_description IN vea_packages.description%TYPE,
102 p_application_short_name IN vea_packages.application_short_name%TYPE,
103 p_tp_layer_id IN vea_packages.tp_layer_id%TYPE,
104 p_id IN vea_packages.package_id%TYPE := NULL
105 );
106 --
107 --
108 --
109 --
110 --}
111 END VEA_PACKAGES_SV;