[Home] [Help]
PACKAGE: APPS.VEA_PROGRAM_UNITS_SV
Source
1 PACKAGE VEA_PROGRAM_UNITS_SV AUTHID CURRENT_USER as
2 /* $Header: VEAVAPUS.pls 115.9 2004/07/27 00:07:28 rvishnuv ship $ */
3 --{
4 /*====================== vea_program_units_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 --
19 --
20 g_program_unit_id NUMBER;
21 --
22 --
23 PROCEDURE
24 delete_rows
25 (
26 p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
27 p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
28 p_package_id IN vea_packages.package_id%TYPE,
29 p_application_short_name IN vea_packages.application_short_name%TYPE,
30 x_program_unit_count OUT NOCOPY NUMBER,
31 x_tps_program_unit_count OUT NOCOPY NUMBER
32 );
33 --
34 --
35 /*========================================================================
36
37 PROCEDURE NAME: deleteUnreferencedProgramUnits
38
39 PURPOSE:
40
41 ========================================================================*/
42 PROCEDURE
43 deleteUnreferencedProgramUnits
44 (
45 p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
46 p_program_unit_id IN vea_program_units.program_unit_id%TYPE,
47 p_tpa_program_unit_id IN vea_program_units.tpa_program_unit_id%TYPE
48 );
49
50 FUNCTION
51 getId
52 (
53 p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
54 p_package_id IN vea_program_units.package_id%TYPE,
55 p_name IN vea_program_units.name%TYPE
56 )
57 RETURN NUMBER;
58 --
59 --
60 PROCEDURE
61 process
62 (
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65 p_commit IN VARCHAR2 := FND_API.G_FALSE,
66 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 x_id OUT NOCOPY vea_program_units.program_unit_id%TYPE,
71 p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
72 p_package_id IN vea_program_units.program_unit_id%TYPE,
73 p_program_unit_type IN vea_program_units.program_unit_type%TYPE,
74 p_public_flag IN vea_program_units.public_flag%TYPE,
75 p_customizable_flag IN vea_program_units.customizable_flag%TYPE,
76 p_tps_flag IN vea_program_units.tps_flag%TYPE,
77 p_name IN vea_program_units.name%TYPE,
78 p_label IN vea_program_units.label%TYPE,
79 p_return_type IN vea_program_units.return_type%TYPE,
80 p_tpa_program_unit_id IN vea_program_units.tpa_program_unit_id%TYPE,
81 p_description IN vea_program_units.description%TYPE,
82 p_id IN vea_program_units.program_unit_id%TYPE := NULL,
83 p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
84 );
85 --
86 --
87 --
88 --
89 --}
90 END VEA_PROGRAM_UNITS_SV;