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: /*========================================================================
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:
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:
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
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
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;
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: --
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: --
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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: --
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: --
86: --
87: --
88: --
89: --}
90: END VEA_PROGRAM_UNITS_SV;