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_EVENT_SPEC_DISP_PVT dependencies on GMD_EVENT_SPEC_DISP

Line 1: PACKAGE BODY GMD_EVENT_SPEC_DISP_PVT AS

1: PACKAGE BODY GMD_EVENT_SPEC_DISP_PVT AS
2: /* $Header: GMDVESDB.pls 115.3 2002/11/04 10:35:41 kxhunt ship $ */
3:
4: -- Start of comments
5: --+==========================================================================+

Line 11: --| Package Name : GMD_EVENT_SPEC_DISP_PVT |

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

Line 25: p_event_spec_disp IN GMD_EVENT_SPEC_DISP%ROWTYPE

21: -- End of comments
22:
23:
24: FUNCTION insert_row (
25: p_event_spec_disp IN GMD_EVENT_SPEC_DISP%ROWTYPE
26: , x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
27: )
28: RETURN BOOLEAN IS
29: BEGIN

Line 26: , x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE

22:
23:
24: FUNCTION insert_row (
25: p_event_spec_disp IN GMD_EVENT_SPEC_DISP%ROWTYPE
26: , x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
27: )
28: RETURN BOOLEAN IS
29: BEGIN
30:

Line 33: INSERT INTO GMD_EVENT_SPEC_DISP

29: BEGIN
30:
31: x_event_spec_disp := p_event_spec_disp;
32:
33: INSERT INTO GMD_EVENT_SPEC_DISP
34: (
35: EVENT_SPEC_DISP_ID
36: ,SAMPLING_EVENT_ID
37: ,SPEC_ID

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

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

Line 95: FROM gmd_event_spec_disp

91: BEGIN
92: IF p_event_spec_disp_id IS NOT NULL THEN
93: SELECT 1
94: INTO dummy
95: FROM gmd_event_spec_disp
96: WHERE event_spec_disp_id = p_event_spec_disp_id
97: FOR UPDATE NOWAIT;
98:
99: DELETE gmd_event_spec_disp

Line 99: DELETE gmd_event_spec_disp

95: FROM gmd_event_spec_disp
96: WHERE event_spec_disp_id = p_event_spec_disp_id
97: FOR UPDATE NOWAIT;
98:
99: DELETE gmd_event_spec_disp
100: WHERE event_spec_disp_id = p_event_spec_disp_id
101: ;
102: ELSE
103: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');

Line 103: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');

99: DELETE gmd_event_spec_disp
100: WHERE event_spec_disp_id = p_event_spec_disp_id
101: ;
102: ELSE
103: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');
104: RETURN FALSE;
105: END IF;
106:
107: IF (SQL%FOUND) THEN

Line 110: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');

106:
107: IF (SQL%FOUND) THEN
108: RETURN TRUE;
109: ELSE
110: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');
111: RETURN FALSE;
112: END IF;
113:
114: EXCEPTION

Line 117: 'TABLE_NAME', 'GMD_EVENT_SPEC_DISP',

113:
114: EXCEPTION
115: WHEN locked_by_other_user THEN
116: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
117: 'TABLE_NAME', 'GMD_EVENT_SPEC_DISP',
118: 'RECORD','Result',
119: 'KEY', p_event_spec_disp_id);
120: RETURN FALSE;
121:

Line 123: fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'DELETE_ROW');

119: 'KEY', p_event_spec_disp_id);
120: RETURN FALSE;
121:
122: WHEN OTHERS THEN
123: fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'DELETE_ROW');
124: RETURN FALSE;
125:
126: END delete_row;
127:

Line 143: FROM gmd_event_spec_disp

139: BEGIN
140: IF p_event_spec_disp_id IS NOT NULL THEN
141: SELECT 1
142: INTO dummy
143: FROM gmd_event_spec_disp
144: WHERE event_spec_disp_id = p_event_spec_disp_id
145: FOR UPDATE NOWAIT;
146: ELSE
147: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');

Line 147: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');

143: FROM gmd_event_spec_disp
144: WHERE event_spec_disp_id = p_event_spec_disp_id
145: FOR UPDATE NOWAIT;
146: ELSE
147: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');
148: RETURN FALSE;
149: END IF;
150:
151: RETURN TRUE;

Line 156: 'TABLE_NAME', 'GMD_EVENT_SPEC_DISP',

152:
153: EXCEPTION
154: WHEN locked_by_other_user THEN
155: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
156: 'TABLE_NAME', 'GMD_EVENT_SPEC_DISP',
157: 'RECORD','Result',
158: 'KEY', p_event_spec_disp_id);
159: RETURN FALSE;
160:

Line 162: fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'DELETE_ROW');

158: 'KEY', p_event_spec_disp_id);
159: RETURN FALSE;
160:
161: WHEN OTHERS THEN
162: fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'DELETE_ROW');
163: RETURN FALSE;
164:
165: END lock_row;
166:

Line 170: p_event_spec_disp IN gmd_event_spec_disp%ROWTYPE

166:
167:
168:
169: FUNCTION fetch_row (
170: p_event_spec_disp IN gmd_event_spec_disp%ROWTYPE
171: , x_event_spec_disp OUT NOCOPY gmd_event_spec_disp%ROWTYPE
172: )
173: RETURN BOOLEAN
174: IS

Line 171: , x_event_spec_disp OUT NOCOPY gmd_event_spec_disp%ROWTYPE

167:
168:
169: FUNCTION fetch_row (
170: p_event_spec_disp IN gmd_event_spec_disp%ROWTYPE
171: , x_event_spec_disp OUT NOCOPY gmd_event_spec_disp%ROWTYPE
172: )
173: RETURN BOOLEAN
174: IS
175: BEGIN

Line 180: FROM gmd_event_spec_disp

176:
177: IF (p_event_spec_disp.event_spec_disp_id IS NOT NULL) THEN
178: SELECT *
179: INTO x_event_spec_disp
180: FROM gmd_event_spec_disp
181: WHERE event_spec_disp_id = p_event_spec_disp.event_spec_disp_id
182: ;
183: ELSE
184: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');

Line 184: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');

180: FROM gmd_event_spec_disp
181: WHERE event_spec_disp_id = p_event_spec_disp.event_spec_disp_id
182: ;
183: ELSE
184: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');
185: RETURN FALSE;
186: END IF;
187:
188: RETURN TRUE;

Line 193: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');

189:
190: EXCEPTION
191: WHEN NO_DATA_FOUND
192: THEN
193: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');
194: RETURN FALSE;
195: WHEN OTHERS
196: THEN
197: fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'FETCH_ROW');

Line 197: fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'FETCH_ROW');

193: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_EVENT_SPEC_DISP');
194: RETURN FALSE;
195: WHEN OTHERS
196: THEN
197: fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'FETCH_ROW');
198: RETURN FALSE;
199:
200: END fetch_row;
201:

Line 202: END GMD_EVENT_SPEC_DISP_PVT;

198: RETURN FALSE;
199:
200: END fetch_row;
201:
202: END GMD_EVENT_SPEC_DISP_PVT;