APPS.XLA_EVENT_CLASS_PREDECS_F_PKG dependencies on XLA_EVENT_CLASS_PREDECS

Line 1: PACKAGE BODY xla_event_class_predecs_f_pkg AS

1: PACKAGE BODY xla_event_class_predecs_f_pkg AS
2: /* $Header: xlatbecp.pkb 120.1 2005/04/20 20:19:56 dcshah noship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_event_class_predecs_f_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_event_class_predecs_f_pkg |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_event_class_predecs |
13: | |

Line 12: | Forms PL/SQL Wrapper for xla_event_class_predecs |

8: | PACKAGE NAME |
9: | xla_event_class_predecs_f_pkg |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_event_class_predecs |
13: | |
14: | HISTORY |
15: | 05/22/01 Dimple Shah Created |
16: | |

Line 41: FROM xla_event_class_predecs

37: IS
38:
39: CURSOR c IS
40: SELECT rowid
41: FROM xla_event_class_predecs
42: WHERE application_id = x_application_id
43: AND event_class_code = x_event_class_code
44: AND prior_event_class_code = x_prior_event_class_code;
45:

Line 49: INSERT INTO xla_event_class_predecs

45:
46: BEGIN
47: xla_utility_pkg.trace('> .insert_row' ,20);
48:
49: INSERT INTO xla_event_class_predecs
50: (creation_date
51: ,created_by
52: ,application_id
53: ,event_class_code

Line 97: DELETE FROM xla_event_class_predecs

93: IS
94:
95: BEGIN
96: xla_utility_pkg.trace('> .delete_row' ,20);
97: DELETE FROM xla_event_class_predecs
98: WHERE application_id = x_application_id
99: AND event_class_code = x_event_class_code
100: AND prior_event_class_code = x_prior_event_class_code;
101:

Line 126: FROM xla_event_class_predecs

122: CURSOR c IS
123: SELECT application_id
124: ,event_class_code
125: ,prior_event_class_code
126: FROM xla_event_class_predecs
127: WHERE application_id = x_application_id
128: AND event_class_code = x_event_class_code
129: AND prior_event_class_code = x_prior_event_class_code
130: FOR UPDATE OF application_id NOWAIT;

Line 209: FROM xla_event_class_predecs

205: BEGIN
206:
207: SELECT last_updated_by, last_update_date
208: INTO db_luby, db_ludate
209: FROM xla_event_class_predecs
210: WHERE application_id = l_application_id
211: AND event_class_code = p_event_class_code
212: AND prior_event_class_code = p_prior_event_class_code;
213:

Line 217: xla_event_class_predecs_f_pkg.insert_row

213:
214: EXCEPTION
215:
216: WHEN NO_DATA_FOUND THEN
217: xla_event_class_predecs_f_pkg.insert_row
218: (x_rowid => l_rowid
219: ,x_application_id => l_application_id
220: ,x_event_class_code => p_event_class_code
221: ,x_prior_event_class_code => p_prior_event_class_code

Line 235: (p_location => 'xla_event_class_predecs_f_pkg.load_row');

231: WHEN NO_DATA_FOUND THEN
232: null;
233: WHEN OTHERS THEN
234: xla_exceptions_pkg.raise_message
235: (p_location => 'xla_event_class_predecs_f_pkg.load_row');
236:
237: END load_row;
238:
239: end xla_event_class_predecs_f_pkg;

Line 239: end xla_event_class_predecs_f_pkg;

235: (p_location => 'xla_event_class_predecs_f_pkg.load_row');
236:
237: END load_row;
238:
239: end xla_event_class_predecs_f_pkg;