eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.VEA_PACKAGES_SV dependencies on VEA_PACKAGES

Line 1: PACKAGE VEA_PACKAGES_SV AUTHID CURRENT_USER as

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: /*========================================================================

Line 4: /======================== vea_packages_sv =============================/

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:

Line 31: p_application_short_name IN vea_packages.application_short_name%TYPE,

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: --

Line 46: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

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: );

Line 47: p_package_id IN vea_packages.package_id%TYPE,

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: --

Line 63: p_application_short_name IN vea_packages.application_short_name%TYPE,

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: );

Line 64: p_specification_filename IN vea_packages.specification_filename%TYPE,

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: --

Line 73: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

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: )

Line 74: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

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;

Line 75: p_name IN vea_packages.name%TYPE,

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: --

Line 76: p_application_short_name IN vea_packages.application_short_name%TYPE

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: --

Line 91: x_id OUT NOCOPY vea_packages.package_id%TYPE,

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,

Line 92: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

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,

Line 93: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

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,

Line 94: p_generate_flag IN vea_packages.generate_flag%TYPE,

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,

Line 95: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

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,

Line 96: p_name IN vea_packages.name%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,

Line 97: p_specification_filename IN vea_packages.specification_filename%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,

Line 98: p_body_filename IN vea_packages.body_filename%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,

Line 99: p_label IN vea_packages.label%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,

Line 100: p_version_number IN vea_packages.version_number%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

Line 101: p_description IN vea_packages.description%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: );

Line 102: p_application_short_name IN vea_packages.application_short_name%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: --

Line 103: p_tp_layer_id IN vea_packages.tp_layer_id%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: --

Line 104: p_id IN vea_packages.package_id%TYPE := NULL

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: --

Line 111: END VEA_PACKAGES_SV;

107: --
108: --
109: --
110: --}
111: END VEA_PACKAGES_SV;