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.GMO_OPER_CERT_TRANS_DBL dependencies on GMO_OPERATOR_CERT_TRANS

Line 5: g_table_name VARCHAR2 (80) DEFAULT 'gmo_operator_cert_trans';

1: PACKAGE BODY gmo_oper_cert_trans_dbl AS
2: /* $Header: GMOVGOCB.pls 120.2 2011/02/24 12:28:35 srpuri ship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'gmo_operator_cert_trans';
6:
7: /*============================================================================
8: | Copyright (c) 2001 Oracle Corporation
9: | TVP, Reading

Line 42: | Insert_Row will insert a row in gmo_operator_cert_trans

Line 46: | Insert_Row will insert a row in gmo_operator_cert_trans

42: | Insert_Row will insert a row in gmo_operator_cert_trans
43: |
44: |
45: | DESCRIPTION
46: | Insert_Row will insert a row in gmo_operator_cert_trans
47: |
48: |
49: |
50: | PARAMETERS

Line 51: | p_oper_cert_trans IN gmo_operator_cert_trans%ROWTYPE

47: |
48: |
49: |
50: | PARAMETERS
51: | p_oper_cert_trans IN gmo_operator_cert_trans%ROWTYPE
52: | x_oper_cert_trans IN OUT NOCOPY gmo_operator_cert_trans%ROWTYPE
53: |
54: | RETURNS
55: | BOOLEAN

Line 52: | x_oper_cert_trans IN OUT NOCOPY gmo_operator_cert_trans%ROWTYPE

Line 95: INSERT INTO gmo_operator_cert_trans

91:
92:
93:
94:
95: INSERT INTO gmo_operator_cert_trans
96: (operator_CERTIFICATE_ID
97: ,HEADER_ID
98: ,TRANSACTION_ID
99: ,USER_ID

Line 162: | Delete_Row will delete a row in gmo_operator_cert_trans

Line 166: | Delete_Row will delete a row in gmo_operator_cert_trans

162: | Delete_Row will delete a row in gmo_operator_cert_trans
163: |
164: |
165: | DESCRIPTION
166: | Delete_Row will delete a row in gmo_operator_cert_trans
167: |
168: |
169: |
170: | PARAMETERS

Line 171: | p_oper_cert_trans IN gmo_operator_cert_trans%ROWTYPE

167: |
168: |
169: |
170: | PARAMETERS
171: | p_oper_cert_trans IN gmo_operator_cert_trans%ROWTYPE
172: |
173: | RETURNS
174: | BOOLEAN
175: | HISTORY

Line 198: FROM gmo_operator_cert_trans

194: x_return_status := fnd_api.g_ret_sts_success;
195: IF p_oper_cert_ID IS NOT NULL THEN
196: SELECT 1
197: INTO l_dummy
198: FROM gmo_operator_cert_trans
199: WHERE operator_CERTIFICATE_ID = p_oper_cert_ID
200: FOR UPDATE NOWAIT;
201:
202: DELETE FROM gmo_operator_cert_trans

Line 202: DELETE FROM gmo_operator_cert_trans

198: FROM gmo_operator_cert_trans
199: WHERE operator_CERTIFICATE_ID = p_oper_cert_ID
200: FOR UPDATE NOWAIT;
201:
202: DELETE FROM gmo_operator_cert_trans
203: WHERE operator_CERTIFICATE_ID = p_oper_cert_ID ;
204:
205:
206: IF (SQL%NOTFOUND) THEN

Line 228: | Update_Row will update a row in gmo_operator_cert_trans

Line 232: | Update_Row will update a row in gmo_operator_cert_trans

228: | Update_Row will update a row in gmo_operator_cert_trans
229: |
230: |
231: | DESCRIPTION
232: | Update_Row will update a row in gmo_operator_cert_trans
233: |
234: |
235: |
236: | PARAMETERS

Line 237: | p_oper_cert_trans IN gmo_operator_cert_trans%ROWTYPE

233: |
234: |
235: |
236: | PARAMETERS
237: | p_oper_cert_trans IN gmo_operator_cert_trans%ROWTYPE
238: |
239: | RETURNS
240: | BOOLEAN
241: | HISTORY

Line 282: FROM gmo_operator_cert_trans

278:
279: IF p_operator_CERTIFICATE_ID IS NOT NULL THEN
280: SELECT 1
281: INTO l_dummy
282: FROM gmo_operator_cert_trans
283: WHERE operator_CERTIFICATE_ID = p_operator_CERTIFICATE_ID
284: FOR UPDATE NOWAIT;
285:
286: UPDATE gmo_operator_cert_trans

Line 286: UPDATE gmo_operator_cert_trans

282: FROM gmo_operator_cert_trans
283: WHERE operator_CERTIFICATE_ID = p_operator_CERTIFICATE_ID
284: FOR UPDATE NOWAIT;
285:
286: UPDATE gmo_operator_cert_trans
287: SET
288: TRANSACTION_ID = P_TRANSACTION_ID
289: ,comments = P_comments
290: ,OVERRIDER_ID = P_OVERRIDER_ID

Line 326: | Lock_Row will lock a row in gmo_operator_cert_trans

Line 330: | Lock_Row will lock a row in gmo_operator_cert_trans

326: | Lock_Row will lock a row in gmo_operator_cert_trans
327: |
328: |
329: | DESCRIPTION
330: | Lock_Row will lock a row in gmo_operator_cert_trans
331: |
332: |
333: |
334: | PARAMETERS

Line 335: | p_oper_cert_trans IN gmo_operator_cert_trans%ROWTYPE

331: |
332: |
333: |
334: | PARAMETERS
335: | p_oper_cert_trans IN gmo_operator_cert_trans%ROWTYPE
336: |
337: | RETURNS
338: | BOOLEAN
339: | HISTORY

Line 356: FROM gmo_operator_cert_trans

352: BEGIN
353: IF p_oper_cert_ID IS NOT NULL THEN
354: SELECT 1
355: INTO l_dummy
356: FROM gmo_operator_cert_trans
357: WHERE operator_CERTIFICATE_ID = p_oper_cert_ID
358: FOR UPDATE NOWAIT;
359: END IF;
360: