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_RELEASE_DETAILS_SV dependencies on VEA_RELEASE_DETAILS

Line 1: PACKAGE BODY VEA_RELEASE_DETAILS_SV as

1: PACKAGE BODY VEA_RELEASE_DETAILS_SV as
2: /* $Header: VEAVARDB.pls 115.9 2004/07/27 00:08:16 rvishnuv ship $ */
3: --{
4: /*====================== vea_release_details_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_release_details_sv =========================/

1: PACKAGE BODY VEA_RELEASE_DETAILS_SV as
2: /* $Header: VEAVARDB.pls 115.9 2004/07/27 00:08:16 rvishnuv ship $ */
3: --{
4: /*====================== vea_release_details_sv =========================*/
5: /*========================================================================
6: PURPOSE:
7:
8: NOTES: To run the script:

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

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

Line 30: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
31: p_release_id IN vea_release_details.release_id%TYPE,
32: p_file_name IN vea_release_details.file_name%TYPE,
33: p_version_number IN vea_release_details.version_number%TYPE,
34: p_application_short_name IN vea_release_details.application_short_name%TYPE,

Line 31: p_release_id IN vea_release_details.release_id%TYPE,

27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
31: p_release_id IN vea_release_details.release_id%TYPE,
32: p_file_name IN vea_release_details.file_name%TYPE,
33: p_version_number IN vea_release_details.version_number%TYPE,
34: p_application_short_name IN vea_release_details.application_short_name%TYPE,
35: p_description IN vea_release_details.description%TYPE,

Line 32: p_file_name IN vea_release_details.file_name%TYPE,

28: insert_row
29: (
30: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
31: p_release_id IN vea_release_details.release_id%TYPE,
32: p_file_name IN vea_release_details.file_name%TYPE,
33: p_version_number IN vea_release_details.version_number%TYPE,
34: p_application_short_name IN vea_release_details.application_short_name%TYPE,
35: p_description IN vea_release_details.description%TYPE,
36: p_aru_number IN vea_release_details.aru_number%TYPE,

Line 33: p_version_number IN vea_release_details.version_number%TYPE,

29: (
30: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
31: p_release_id IN vea_release_details.release_id%TYPE,
32: p_file_name IN vea_release_details.file_name%TYPE,
33: p_version_number IN vea_release_details.version_number%TYPE,
34: p_application_short_name IN vea_release_details.application_short_name%TYPE,
35: p_description IN vea_release_details.description%TYPE,
36: p_aru_number IN vea_release_details.aru_number%TYPE,
37: p_bug_number IN vea_release_details.bug_number%TYPE,

Line 34: p_application_short_name IN vea_release_details.application_short_name%TYPE,

30: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
31: p_release_id IN vea_release_details.release_id%TYPE,
32: p_file_name IN vea_release_details.file_name%TYPE,
33: p_version_number IN vea_release_details.version_number%TYPE,
34: p_application_short_name IN vea_release_details.application_short_name%TYPE,
35: p_description IN vea_release_details.description%TYPE,
36: p_aru_number IN vea_release_details.aru_number%TYPE,
37: p_bug_number IN vea_release_details.bug_number%TYPE,
38: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,

Line 35: p_description IN vea_release_details.description%TYPE,

31: p_release_id IN vea_release_details.release_id%TYPE,
32: p_file_name IN vea_release_details.file_name%TYPE,
33: p_version_number IN vea_release_details.version_number%TYPE,
34: p_application_short_name IN vea_release_details.application_short_name%TYPE,
35: p_description IN vea_release_details.description%TYPE,
36: p_aru_number IN vea_release_details.aru_number%TYPE,
37: p_bug_number IN vea_release_details.bug_number%TYPE,
38: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
39: p_file_path IN vea_release_details.file_path%TYPE

Line 36: p_aru_number IN vea_release_details.aru_number%TYPE,

32: p_file_name IN vea_release_details.file_name%TYPE,
33: p_version_number IN vea_release_details.version_number%TYPE,
34: p_application_short_name IN vea_release_details.application_short_name%TYPE,
35: p_description IN vea_release_details.description%TYPE,
36: p_aru_number IN vea_release_details.aru_number%TYPE,
37: p_bug_number IN vea_release_details.bug_number%TYPE,
38: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
39: p_file_path IN vea_release_details.file_path%TYPE
40: )

Line 37: p_bug_number IN vea_release_details.bug_number%TYPE,

33: p_version_number IN vea_release_details.version_number%TYPE,
34: p_application_short_name IN vea_release_details.application_short_name%TYPE,
35: p_description IN vea_release_details.description%TYPE,
36: p_aru_number IN vea_release_details.aru_number%TYPE,
37: p_bug_number IN vea_release_details.bug_number%TYPE,
38: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
39: p_file_path IN vea_release_details.file_path%TYPE
40: )
41: IS

Line 38: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,

34: p_application_short_name IN vea_release_details.application_short_name%TYPE,
35: p_description IN vea_release_details.description%TYPE,
36: p_aru_number IN vea_release_details.aru_number%TYPE,
37: p_bug_number IN vea_release_details.bug_number%TYPE,
38: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
39: p_file_path IN vea_release_details.file_path%TYPE
40: )
41: IS
42: --{

Line 39: p_file_path IN vea_release_details.file_path%TYPE

35: p_description IN vea_release_details.description%TYPE,
36: p_aru_number IN vea_release_details.aru_number%TYPE,
37: p_bug_number IN vea_release_details.bug_number%TYPE,
38: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
39: p_file_path IN vea_release_details.file_path%TYPE
40: )
41: IS
42: --{
43: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 54: INSERT INTO vea_release_details

50: BEGIN
51: --{
52: l_location := '0010';
53: --
54: INSERT INTO vea_release_details
55: (
56: layer_provider_code, release_id,
57: file_name, version_number,
58: application_short_name,

Line 105: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,

101: ========================================================================*/
102: PROCEDURE
103: update_row
104: (
105: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
106: p_release_id IN vea_release_details.release_id%TYPE,
107: p_file_name IN vea_release_details.file_name%TYPE,
108: p_version_number IN vea_release_details.version_number%TYPE,
109: p_application_short_name IN vea_release_details.application_short_name%TYPE,

Line 106: p_release_id IN vea_release_details.release_id%TYPE,

102: PROCEDURE
103: update_row
104: (
105: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
106: p_release_id IN vea_release_details.release_id%TYPE,
107: p_file_name IN vea_release_details.file_name%TYPE,
108: p_version_number IN vea_release_details.version_number%TYPE,
109: p_application_short_name IN vea_release_details.application_short_name%TYPE,
110: p_description IN vea_release_details.description%TYPE,

Line 107: p_file_name IN vea_release_details.file_name%TYPE,

103: update_row
104: (
105: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
106: p_release_id IN vea_release_details.release_id%TYPE,
107: p_file_name IN vea_release_details.file_name%TYPE,
108: p_version_number IN vea_release_details.version_number%TYPE,
109: p_application_short_name IN vea_release_details.application_short_name%TYPE,
110: p_description IN vea_release_details.description%TYPE,
111: p_aru_number IN vea_release_details.aru_number%TYPE,

Line 108: p_version_number IN vea_release_details.version_number%TYPE,

104: (
105: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
106: p_release_id IN vea_release_details.release_id%TYPE,
107: p_file_name IN vea_release_details.file_name%TYPE,
108: p_version_number IN vea_release_details.version_number%TYPE,
109: p_application_short_name IN vea_release_details.application_short_name%TYPE,
110: p_description IN vea_release_details.description%TYPE,
111: p_aru_number IN vea_release_details.aru_number%TYPE,
112: p_bug_number IN vea_release_details.bug_number%TYPE,

Line 109: p_application_short_name IN vea_release_details.application_short_name%TYPE,

105: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
106: p_release_id IN vea_release_details.release_id%TYPE,
107: p_file_name IN vea_release_details.file_name%TYPE,
108: p_version_number IN vea_release_details.version_number%TYPE,
109: p_application_short_name IN vea_release_details.application_short_name%TYPE,
110: p_description IN vea_release_details.description%TYPE,
111: p_aru_number IN vea_release_details.aru_number%TYPE,
112: p_bug_number IN vea_release_details.bug_number%TYPE,
113: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,

Line 110: p_description IN vea_release_details.description%TYPE,

106: p_release_id IN vea_release_details.release_id%TYPE,
107: p_file_name IN vea_release_details.file_name%TYPE,
108: p_version_number IN vea_release_details.version_number%TYPE,
109: p_application_short_name IN vea_release_details.application_short_name%TYPE,
110: p_description IN vea_release_details.description%TYPE,
111: p_aru_number IN vea_release_details.aru_number%TYPE,
112: p_bug_number IN vea_release_details.bug_number%TYPE,
113: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
114: p_file_path IN vea_release_details.file_path%TYPE

Line 111: p_aru_number IN vea_release_details.aru_number%TYPE,

107: p_file_name IN vea_release_details.file_name%TYPE,
108: p_version_number IN vea_release_details.version_number%TYPE,
109: p_application_short_name IN vea_release_details.application_short_name%TYPE,
110: p_description IN vea_release_details.description%TYPE,
111: p_aru_number IN vea_release_details.aru_number%TYPE,
112: p_bug_number IN vea_release_details.bug_number%TYPE,
113: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
114: p_file_path IN vea_release_details.file_path%TYPE
115: )

Line 112: p_bug_number IN vea_release_details.bug_number%TYPE,

108: p_version_number IN vea_release_details.version_number%TYPE,
109: p_application_short_name IN vea_release_details.application_short_name%TYPE,
110: p_description IN vea_release_details.description%TYPE,
111: p_aru_number IN vea_release_details.aru_number%TYPE,
112: p_bug_number IN vea_release_details.bug_number%TYPE,
113: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
114: p_file_path IN vea_release_details.file_path%TYPE
115: )
116: IS

Line 113: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,

109: p_application_short_name IN vea_release_details.application_short_name%TYPE,
110: p_description IN vea_release_details.description%TYPE,
111: p_aru_number IN vea_release_details.aru_number%TYPE,
112: p_bug_number IN vea_release_details.bug_number%TYPE,
113: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
114: p_file_path IN vea_release_details.file_path%TYPE
115: )
116: IS
117: --{

Line 114: p_file_path IN vea_release_details.file_path%TYPE

110: p_description IN vea_release_details.description%TYPE,
111: p_aru_number IN vea_release_details.aru_number%TYPE,
112: p_bug_number IN vea_release_details.bug_number%TYPE,
113: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
114: p_file_path IN vea_release_details.file_path%TYPE
115: )
116: IS
117: --{
118: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 129: UPDATE vea_release_details

125: BEGIN
126: --{
127: l_location := '0010';
128: --
129: UPDATE vea_release_details
130: SET version_number = p_version_number,
131: description = p_description,
132: aru_number = p_aru_number,
133: bug_number = p_bug_number,

Line 177: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,

173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
178: p_release_id IN vea_release_details.release_id%TYPE,
179: p_file_name IN vea_release_details.file_name%TYPE,
180: p_version_number IN vea_release_details.version_number%TYPE,
181: p_application_short_name IN vea_release_details.application_short_name%TYPE,

Line 178: p_release_id IN vea_release_details.release_id%TYPE,

174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
178: p_release_id IN vea_release_details.release_id%TYPE,
179: p_file_name IN vea_release_details.file_name%TYPE,
180: p_version_number IN vea_release_details.version_number%TYPE,
181: p_application_short_name IN vea_release_details.application_short_name%TYPE,
182: p_description IN vea_release_details.description%TYPE,

Line 179: p_file_name IN vea_release_details.file_name%TYPE,

175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
178: p_release_id IN vea_release_details.release_id%TYPE,
179: p_file_name IN vea_release_details.file_name%TYPE,
180: p_version_number IN vea_release_details.version_number%TYPE,
181: p_application_short_name IN vea_release_details.application_short_name%TYPE,
182: p_description IN vea_release_details.description%TYPE,
183: p_aru_number IN vea_release_details.aru_number%TYPE,

Line 180: p_version_number IN vea_release_details.version_number%TYPE,

176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
178: p_release_id IN vea_release_details.release_id%TYPE,
179: p_file_name IN vea_release_details.file_name%TYPE,
180: p_version_number IN vea_release_details.version_number%TYPE,
181: p_application_short_name IN vea_release_details.application_short_name%TYPE,
182: p_description IN vea_release_details.description%TYPE,
183: p_aru_number IN vea_release_details.aru_number%TYPE,
184: p_bug_number IN vea_release_details.bug_number%TYPE,

Line 181: p_application_short_name IN vea_release_details.application_short_name%TYPE,

177: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
178: p_release_id IN vea_release_details.release_id%TYPE,
179: p_file_name IN vea_release_details.file_name%TYPE,
180: p_version_number IN vea_release_details.version_number%TYPE,
181: p_application_short_name IN vea_release_details.application_short_name%TYPE,
182: p_description IN vea_release_details.description%TYPE,
183: p_aru_number IN vea_release_details.aru_number%TYPE,
184: p_bug_number IN vea_release_details.bug_number%TYPE,
185: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,

Line 182: p_description IN vea_release_details.description%TYPE,

178: p_release_id IN vea_release_details.release_id%TYPE,
179: p_file_name IN vea_release_details.file_name%TYPE,
180: p_version_number IN vea_release_details.version_number%TYPE,
181: p_application_short_name IN vea_release_details.application_short_name%TYPE,
182: p_description IN vea_release_details.description%TYPE,
183: p_aru_number IN vea_release_details.aru_number%TYPE,
184: p_bug_number IN vea_release_details.bug_number%TYPE,
185: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
186: p_file_path IN vea_release_details.file_path%TYPE

Line 183: p_aru_number IN vea_release_details.aru_number%TYPE,

179: p_file_name IN vea_release_details.file_name%TYPE,
180: p_version_number IN vea_release_details.version_number%TYPE,
181: p_application_short_name IN vea_release_details.application_short_name%TYPE,
182: p_description IN vea_release_details.description%TYPE,
183: p_aru_number IN vea_release_details.aru_number%TYPE,
184: p_bug_number IN vea_release_details.bug_number%TYPE,
185: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
186: p_file_path IN vea_release_details.file_path%TYPE
187: )

Line 184: p_bug_number IN vea_release_details.bug_number%TYPE,

180: p_version_number IN vea_release_details.version_number%TYPE,
181: p_application_short_name IN vea_release_details.application_short_name%TYPE,
182: p_description IN vea_release_details.description%TYPE,
183: p_aru_number IN vea_release_details.aru_number%TYPE,
184: p_bug_number IN vea_release_details.bug_number%TYPE,
185: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
186: p_file_path IN vea_release_details.file_path%TYPE
187: )
188: IS

Line 185: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,

181: p_application_short_name IN vea_release_details.application_short_name%TYPE,
182: p_description IN vea_release_details.description%TYPE,
183: p_aru_number IN vea_release_details.aru_number%TYPE,
184: p_bug_number IN vea_release_details.bug_number%TYPE,
185: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
186: p_file_path IN vea_release_details.file_path%TYPE
187: )
188: IS
189: --{

Line 186: p_file_path IN vea_release_details.file_path%TYPE

182: p_description IN vea_release_details.description%TYPE,
183: p_aru_number IN vea_release_details.aru_number%TYPE,
184: p_bug_number IN vea_release_details.bug_number%TYPE,
185: p_tp_layer_id IN vea_release_details.tp_layer_id%TYPE,
186: p_file_path IN vea_release_details.file_path%TYPE
187: )
188: IS
189: --{
190: l_api_name CONSTANT VARCHAR2(30) := 'process';

Line 199: l_release_id vea_release_details.release_id%TYPE;

195: l_location VARCHAR2(32767);
196: l_savepoint_name VARCHAR2(30);
197: l_layer_id vea_layers.layer_id%TYPE;
198: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
199: l_release_id vea_release_details.release_id%TYPE;
200: --
201: --
202: CURSOR layer_cur
203: (

Line 204: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,

200: --
201: --
202: CURSOR layer_cur
203: (
204: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
205: p_release_id IN vea_release_details.release_id%TYPE,
206: p_file_name IN vea_release_details.file_name%TYPE,
207: p_application_short_name IN vea_release_details.application_short_name%TYPE,
208: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE

Line 205: p_release_id IN vea_release_details.release_id%TYPE,

201: --
202: CURSOR layer_cur
203: (
204: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
205: p_release_id IN vea_release_details.release_id%TYPE,
206: p_file_name IN vea_release_details.file_name%TYPE,
207: p_application_short_name IN vea_release_details.application_short_name%TYPE,
208: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
209: )

Line 206: p_file_name IN vea_release_details.file_name%TYPE,

202: CURSOR layer_cur
203: (
204: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
205: p_release_id IN vea_release_details.release_id%TYPE,
206: p_file_name IN vea_release_details.file_name%TYPE,
207: p_application_short_name IN vea_release_details.application_short_name%TYPE,
208: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
209: )
210: IS

Line 207: p_application_short_name IN vea_release_details.application_short_name%TYPE,

203: (
204: p_layer_provider_code IN vea_release_details.layer_provider_code%TYPE,
205: p_release_id IN vea_release_details.release_id%TYPE,
206: p_file_name IN vea_release_details.file_name%TYPE,
207: p_application_short_name IN vea_release_details.application_short_name%TYPE,
208: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
209: )
210: IS
211: SELECT 1 layer_id,

Line 213: FROM vea_release_details

209: )
210: IS
211: SELECT 1 layer_id,
212: release_id
213: FROM vea_release_details
214: WHERE layer_provider_code = p_layer_provider_code
215: AND release_id = p_release_id
216: --AND tp_layer_id = p_tp_layer_id
217: AND file_name = p_file_name

Line 400: END VEA_RELEASE_DETAILS_SV;

396: --}
397: --}
398: END process;
399: --}
400: END VEA_RELEASE_DETAILS_SV;