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.GMD_SPEC_RESULTS_PVT dependencies on GMD_SPEC_RESULTS

Line 1: PACKAGE BODY GMD_SPEC_RESULTS_PVT AS

1: PACKAGE BODY GMD_SPEC_RESULTS_PVT AS
2: /* $Header: GMDVSRSB.pls 115.4 2002/12/03 11:10:41 hverddin ship $ */
3:
4: -- Start of comments
5: --+==========================================================================+

Line 11: --| Package Name : GMD_SPEC_RESULTS_PVT |

7: --| Redwood Shores, CA, USA |
8: --| All rights reserved. |
9: --+==========================================================================+
10: --| File Name : GMDVSREB.pls |
11: --| Package Name : GMD_SPEC_RESULTS_PVT |
12: --| Type : Private |
13: --| |
14: --| Notes |
15: --| This package contains private layer APIs for Results |

Line 24: FUNCTION insert_row (p_spec_results IN GMD_SPEC_RESULTS%ROWTYPE)

20: --+==========================================================================+
21: -- End of comments
22:
23:
24: FUNCTION insert_row (p_spec_results IN GMD_SPEC_RESULTS%ROWTYPE)
25: RETURN BOOLEAN IS
26: BEGIN
27:
28: INSERT INTO GMD_SPEC_RESULTS

Line 28: INSERT INTO GMD_SPEC_RESULTS

24: FUNCTION insert_row (p_spec_results IN GMD_SPEC_RESULTS%ROWTYPE)
25: RETURN BOOLEAN IS
26: BEGIN
27:
28: INSERT INTO GMD_SPEC_RESULTS
29: (
30: EVENT_SPEC_DISP_ID
31: ,RESULT_ID
32: ,IN_SPEC_IND

Line 74: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'INSERT_ROW');

70: END IF;
71:
72: EXCEPTION
73: WHEN OTHERS THEN
74: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'INSERT_ROW');
75: RETURN FALSE;
76:
77: END insert_row;
78:

Line 100: FROM gmd_spec_results

96: IF p_event_spec_disp_id IS NOT NULL AND
97: p_result_id IS NOT NULL THEN
98: SELECT 1
99: INTO dummy
100: FROM gmd_spec_results
101: WHERE event_spec_disp_id = p_event_spec_disp_id
102: AND result_id = p_result_id
103: FOR UPDATE NOWAIT;
104:

Line 105: UPDATE gmd_spec_results

101: WHERE event_spec_disp_id = p_event_spec_disp_id
102: AND result_id = p_result_id
103: FOR UPDATE NOWAIT;
104:
105: UPDATE gmd_spec_results
106: SET delete_mark = 1
107: WHERE event_spec_disp_id = p_event_spec_disp_id
108: AND result_id = p_result_id
109: ;

Line 111: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');

107: WHERE event_spec_disp_id = p_event_spec_disp_id
108: AND result_id = p_result_id
109: ;
110: ELSE
111: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');
112: RETURN FALSE;
113: END IF;
114:
115: IF (SQL%FOUND) THEN

Line 118: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_RESULTS');

114:
115: IF (SQL%FOUND) THEN
116: RETURN TRUE;
117: ELSE
118: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_RESULTS');
119: RETURN FALSE;
120: END IF;
121:
122: EXCEPTION

Line 125: 'TABLE_NAME', 'GMD_SPEC_RESULTS',

121:
122: EXCEPTION
123: WHEN locked_by_other_user THEN
124: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
125: 'TABLE_NAME', 'GMD_SPEC_RESULTS',
126: 'RECORD','Result',
127: 'KEY', p_event_spec_disp_id);
128: RETURN FALSE;
129:

Line 131: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'DELETE_ROW');

127: 'KEY', p_event_spec_disp_id);
128: RETURN FALSE;
129:
130: WHEN OTHERS THEN
131: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'DELETE_ROW');
132: RETURN FALSE;
133:
134: END delete_row;
135:

Line 156: FROM gmd_spec_results

152: IF p_event_spec_disp_id IS NOT NULL AND
153: p_result_id IS NOT NULL THEN
154: SELECT 1
155: INTO dummy
156: FROM gmd_spec_results
157: WHERE event_spec_disp_id = p_event_spec_disp_id
158: AND result_id = p_result_id
159: FOR UPDATE NOWAIT;
160: ELSE

Line 161: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');

157: WHERE event_spec_disp_id = p_event_spec_disp_id
158: AND result_id = p_result_id
159: FOR UPDATE NOWAIT;
160: ELSE
161: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');
162: RETURN FALSE;
163: END IF;
164:
165: RETURN TRUE;

Line 170: 'TABLE_NAME', 'GMD_SPEC_RESULTS',

166:
167: EXCEPTION
168: WHEN locked_by_other_user THEN
169: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
170: 'TABLE_NAME', 'GMD_SPEC_RESULTS',
171: 'RECORD','Result',
172: 'KEY', p_event_spec_disp_id);
173: RETURN FALSE;
174:

Line 176: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'DELETE_ROW');

172: 'KEY', p_event_spec_disp_id);
173: RETURN FALSE;
174:
175: WHEN OTHERS THEN
176: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'DELETE_ROW');
177: RETURN FALSE;
178:
179: END lock_row;
180:

Line 184: p_spec_results IN gmd_spec_results%ROWTYPE

180:
181:
182:
183: FUNCTION fetch_row (
184: p_spec_results IN gmd_spec_results%ROWTYPE
185: , x_spec_results OUT NOCOPY gmd_spec_results%ROWTYPE
186: )
187: RETURN BOOLEAN
188: IS

Line 185: , x_spec_results OUT NOCOPY gmd_spec_results%ROWTYPE

181:
182:
183: FUNCTION fetch_row (
184: p_spec_results IN gmd_spec_results%ROWTYPE
185: , x_spec_results OUT NOCOPY gmd_spec_results%ROWTYPE
186: )
187: RETURN BOOLEAN
188: IS
189: BEGIN

Line 195: FROM gmd_spec_results

191: IF p_spec_results.event_spec_disp_id IS NOT NULL AND
192: p_spec_results.result_id IS NOT NULL THEN
193: SELECT *
194: INTO x_spec_results
195: FROM gmd_spec_results
196: WHERE event_spec_disp_id = p_spec_results.event_spec_disp_id
197: AND result_id = p_spec_results.result_id
198: ;
199: ELSE

Line 200: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');

196: WHERE event_spec_disp_id = p_spec_results.event_spec_disp_id
197: AND result_id = p_spec_results.result_id
198: ;
199: ELSE
200: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');
201: RETURN FALSE;
202: END IF;
203:
204: -- BUG 2690469

Line 212: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_RESULTS');

208:
209: EXCEPTION
210: WHEN NO_DATA_FOUND
211: THEN
212: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_RESULTS');
213: RETURN FALSE;
214: WHEN OTHERS
215: THEN
216: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'FETCH_ROW');

Line 216: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'FETCH_ROW');

212: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_RESULTS');
213: RETURN FALSE;
214: WHEN OTHERS
215: THEN
216: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'FETCH_ROW');
217: RETURN FALSE;
218:
219: END fetch_row;
220:

Line 221: END GMD_SPEC_RESULTS_PVT;

217: RETURN FALSE;
218:
219: END fetch_row;
220:
221: END GMD_SPEC_RESULTS_PVT;