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_VERSIONS_SV dependencies on VEA_VERSIONS

Line 1: PACKAGE BODY VEA_VERSIONS_SV as

1: PACKAGE BODY VEA_VERSIONS_SV as
2: /* $Header: VEAVAVRB.pls 115.3 2004/07/27 00:08:59 rvishnuv noship $ */
3: --{
4: /*====================== vea_versions_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_versions_sv =========================/

1: PACKAGE BODY VEA_VERSIONS_SV as
2: /* $Header: VEAVAVRB.pls 115.3 2004/07/27 00:08:59 rvishnuv noship $ */
3: --{
4: /*====================== vea_versions_sv =========================*/
5: /*========================================================================
6: PURPOSE:
7:
8: NOTES: To run the script:

Line 17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_VERSIONS_SV';

13: Created N PARIKH 09/09/99 10:00 AM
14:
15: =========================================================================*/
16:
17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_VERSIONS_SV';
18: --
19: --
20: /*========================================================================
21:

Line 30: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
31: p_release_id IN vea_versions.release_id%TYPE,
32: p_version_id IN vea_versions.version_id%TYPE,
33: p_version_number IN vea_versions.version_number%TYPE,
34: p_description IN vea_versions.description%TYPE

Line 31: p_release_id IN vea_versions.release_id%TYPE,

27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
31: p_release_id IN vea_versions.release_id%TYPE,
32: p_version_id IN vea_versions.version_id%TYPE,
33: p_version_number IN vea_versions.version_number%TYPE,
34: p_description IN vea_versions.description%TYPE
35: )

Line 32: p_version_id IN vea_versions.version_id%TYPE,

28: insert_row
29: (
30: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
31: p_release_id IN vea_versions.release_id%TYPE,
32: p_version_id IN vea_versions.version_id%TYPE,
33: p_version_number IN vea_versions.version_number%TYPE,
34: p_description IN vea_versions.description%TYPE
35: )
36: IS

Line 33: p_version_number IN vea_versions.version_number%TYPE,

29: (
30: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
31: p_release_id IN vea_versions.release_id%TYPE,
32: p_version_id IN vea_versions.version_id%TYPE,
33: p_version_number IN vea_versions.version_number%TYPE,
34: p_description IN vea_versions.description%TYPE
35: )
36: IS
37: --{

Line 34: p_description IN vea_versions.description%TYPE

30: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
31: p_release_id IN vea_versions.release_id%TYPE,
32: p_version_id IN vea_versions.version_id%TYPE,
33: p_version_number IN vea_versions.version_number%TYPE,
34: p_description IN vea_versions.description%TYPE
35: )
36: IS
37: --{
38: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 49: INSERT INTO vea_versions

45: BEGIN
46: --{
47: l_location := '0010';
48: --
49: INSERT INTO vea_versions
50: (
51: layer_provider_code, release_id,
52: version_id, version_number,
53: description,

Line 94: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,

90: ========================================================================*/
91: PROCEDURE
92: update_row
93: (
94: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
95: p_release_id IN vea_versions.release_id%TYPE,
96: p_version_id IN vea_versions.version_id%TYPE,
97: p_version_number IN vea_versions.version_number%TYPE,
98: p_description IN vea_versions.description%TYPE

Line 95: p_release_id IN vea_versions.release_id%TYPE,

91: PROCEDURE
92: update_row
93: (
94: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
95: p_release_id IN vea_versions.release_id%TYPE,
96: p_version_id IN vea_versions.version_id%TYPE,
97: p_version_number IN vea_versions.version_number%TYPE,
98: p_description IN vea_versions.description%TYPE
99: )

Line 96: p_version_id IN vea_versions.version_id%TYPE,

92: update_row
93: (
94: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
95: p_release_id IN vea_versions.release_id%TYPE,
96: p_version_id IN vea_versions.version_id%TYPE,
97: p_version_number IN vea_versions.version_number%TYPE,
98: p_description IN vea_versions.description%TYPE
99: )
100: IS

Line 97: p_version_number IN vea_versions.version_number%TYPE,

93: (
94: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
95: p_release_id IN vea_versions.release_id%TYPE,
96: p_version_id IN vea_versions.version_id%TYPE,
97: p_version_number IN vea_versions.version_number%TYPE,
98: p_description IN vea_versions.description%TYPE
99: )
100: IS
101: --{

Line 98: p_description IN vea_versions.description%TYPE

94: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
95: p_release_id IN vea_versions.release_id%TYPE,
96: p_version_id IN vea_versions.version_id%TYPE,
97: p_version_number IN vea_versions.version_number%TYPE,
98: p_description IN vea_versions.description%TYPE
99: )
100: IS
101: --{
102: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 113: UPDATE vea_versions

109: BEGIN
110: --{
111: l_location := '0010';
112: --
113: UPDATE vea_versions
114: SET version_number = p_version_number,
115: description = p_description,
116: last_updated_by = l_user_id,
117: last_update_date = SYSDATE,

Line 156: p_release_id IN vea_versions.release_id%TYPE,

152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_release_id IN vea_versions.release_id%TYPE,
157: p_version_id IN vea_versions.version_id%TYPE,
158: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
159: p_version_number IN vea_versions.version_number%TYPE,
160: p_description IN vea_versions.description%TYPE

Line 157: p_version_id IN vea_versions.version_id%TYPE,

153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_release_id IN vea_versions.release_id%TYPE,
157: p_version_id IN vea_versions.version_id%TYPE,
158: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
159: p_version_number IN vea_versions.version_number%TYPE,
160: p_description IN vea_versions.description%TYPE
161: )

Line 158: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,

154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_release_id IN vea_versions.release_id%TYPE,
157: p_version_id IN vea_versions.version_id%TYPE,
158: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
159: p_version_number IN vea_versions.version_number%TYPE,
160: p_description IN vea_versions.description%TYPE
161: )
162: IS

Line 159: p_version_number IN vea_versions.version_number%TYPE,

155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_release_id IN vea_versions.release_id%TYPE,
157: p_version_id IN vea_versions.version_id%TYPE,
158: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
159: p_version_number IN vea_versions.version_number%TYPE,
160: p_description IN vea_versions.description%TYPE
161: )
162: IS
163: --{

Line 160: p_description IN vea_versions.description%TYPE

156: p_release_id IN vea_versions.release_id%TYPE,
157: p_version_id IN vea_versions.version_id%TYPE,
158: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE,
159: p_version_number IN vea_versions.version_number%TYPE,
160: p_description IN vea_versions.description%TYPE
161: )
162: IS
163: --{
164: l_api_name CONSTANT VARCHAR2(30) := 'process';

Line 172: l_release_id vea_versions.release_id%TYPE;

168: --
169: l_location VARCHAR2(32767);
170: l_savepoint_name VARCHAR2(30);
171: l_layer_id vea_layers.layer_id%TYPE;
172: l_release_id vea_versions.release_id%TYPE;
173: l_version_id vea_versions.version_id%TYPE;
174: --
175: --
176: CURSOR layer_cur

Line 173: l_version_id vea_versions.version_id%TYPE;

169: l_location VARCHAR2(32767);
170: l_savepoint_name VARCHAR2(30);
171: l_layer_id vea_layers.layer_id%TYPE;
172: l_release_id vea_versions.release_id%TYPE;
173: l_version_id vea_versions.version_id%TYPE;
174: --
175: --
176: CURSOR layer_cur
177: (

Line 178: p_release_id IN vea_versions.release_id%TYPE,

174: --
175: --
176: CURSOR layer_cur
177: (
178: p_release_id IN vea_versions.release_id%TYPE,
179: p_version_id IN vea_versions.version_id%TYPE,
180: p_version_number IN vea_versions.version_number%TYPE,
181: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE
182: )

Line 179: p_version_id IN vea_versions.version_id%TYPE,

175: --
176: CURSOR layer_cur
177: (
178: p_release_id IN vea_versions.release_id%TYPE,
179: p_version_id IN vea_versions.version_id%TYPE,
180: p_version_number IN vea_versions.version_number%TYPE,
181: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE
182: )
183: IS

Line 180: p_version_number IN vea_versions.version_number%TYPE,

176: CURSOR layer_cur
177: (
178: p_release_id IN vea_versions.release_id%TYPE,
179: p_version_id IN vea_versions.version_id%TYPE,
180: p_version_number IN vea_versions.version_number%TYPE,
181: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE
182: )
183: IS
184: SELECT 1 layer_id,

Line 181: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE

177: (
178: p_release_id IN vea_versions.release_id%TYPE,
179: p_version_id IN vea_versions.version_id%TYPE,
180: p_version_number IN vea_versions.version_number%TYPE,
181: p_layer_provider_code IN vea_versions.layer_provider_code%TYPE
182: )
183: IS
184: SELECT 1 layer_id,
185: version_id

Line 186: FROM vea_versions

182: )
183: IS
184: SELECT 1 layer_id,
185: version_id
186: FROM vea_versions
187: WHERE layer_provider_code = p_layer_provider_code
188: AND release_id = p_release_id
189: AND version_id = p_version_id
190: AND version_number = p_version_number;

Line 359: END VEA_VERSIONS_SV;

355: --}
356: --}
357: END process;
358: --}
359: END VEA_VERSIONS_SV;