APPS.XLA_ENTITY_ID_MAPPINGS_F_PKG dependencies on XLA_ENTITY_ID_MAPPINGS

Line 1: PACKAGE BODY xla_entity_id_mappings_f_pkg AS

1: PACKAGE BODY xla_entity_id_mappings_f_pkg AS
2: /* $Header: xlatheim.pkb 120.2 2005/04/28 18:45:48 masada ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_entity_id_mappings_f_pkg |

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

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

8: | PACKAGE NAME |
9: | xla_entity_id_mappings_f_pkg |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_entity_id_mappings |
13: | |
14: | HISTORY |
15: | Generated from XLAUTB. |
16: | |

Line 30: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_entity_id_mappings_f_pkg';

26: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
27: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
28:
29: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
30: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_entity_id_mappings_f_pkg';
31:
32: g_log_level NUMBER;
33: g_log_enabled BOOLEAN;
34:

Line 55: (p_location => 'xla_entity_id_mappings_f_pkg.trace');

51: RAISE;
52:
53: WHEN OTHERS THEN
54: xla_exceptions_pkg.raise_message
55: (p_location => 'xla_entity_id_mappings_f_pkg.trace');
56: END trace;
57:
58:
59: /*======================================================================+

Line 86: FROM xla_entity_id_mappings

82: IS
83:
84: CURSOR c IS
85: SELECT rowid
86: FROM xla_entity_id_mappings
87: WHERE application_id = x_application_id
88: AND entity_code = x_entity_code
89: ;
90:

Line 105: INSERT INTO xla_entity_id_mappings

101: p_level => C_LEVEL_PROCEDURE);
102: END IF;
103:
104:
105: INSERT INTO xla_entity_id_mappings
106: (creation_date
107: ,created_by
108: ,application_id
109: ,entity_code

Line 186: FROM xla_entity_id_mappings

182: ,source_id_col_name_1
183: ,source_id_col_name_2
184: ,source_id_col_name_3
185: ,source_id_col_name_4
186: FROM xla_entity_id_mappings
187: WHERE application_id = x_application_id
188: AND entity_code = x_entity_code
189: FOR UPDATE OF application_id NOWAIT;
190:

Line 283: UPDATE xla_entity_id_mappings

279: p_module => l_log_module,
280: p_level => C_LEVEL_PROCEDURE);
281: END IF;
282:
283: UPDATE xla_entity_id_mappings
284: SET
285: last_update_date = x_last_update_date
286: ,transaction_id_col_name_1 = x_transaction_id_col_name_1
287: ,transaction_id_col_name_2 = x_transaction_id_col_name_2

Line 333: DELETE FROM xla_entity_id_mappings

329: p_module => l_log_module,
330: p_level => C_LEVEL_PROCEDURE);
331: END IF;
332:
333: DELETE FROM xla_entity_id_mappings
334: WHERE application_id = x_application_id
335: AND entity_code = x_entity_code;
336:
337:

Line 409: FROM xla_entity_id_mappings

405: BEGIN
406:
407: SELECT last_updated_by, last_update_date
408: INTO db_luby, db_ludate
409: FROM xla_entity_id_mappings
410: WHERE application_id = l_application_id
411: AND entity_code = p_entity_code;
412:
413: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, NULL)) THEN

Line 414: xla_entity_id_mappings_f_pkg.update_row

410: WHERE application_id = l_application_id
411: AND entity_code = p_entity_code;
412:
413: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, NULL)) THEN
414: xla_entity_id_mappings_f_pkg.update_row
415: (x_application_id => l_application_id
416: ,x_entity_code => p_entity_code
417: ,x_transaction_id_col_name_1 => p_transaction_id_col_name_1
418: ,x_transaction_id_col_name_2 => p_transaction_id_col_name_2

Line 433: xla_entity_id_mappings_f_pkg.insert_row

429: END IF;
430:
431: EXCEPTION
432: WHEN NO_DATA_FOUND THEN
433: xla_entity_id_mappings_f_pkg.insert_row
434: (x_rowid => l_rowid
435: ,x_application_id => l_application_id
436: ,x_entity_code => p_entity_code
437: ,x_transaction_id_col_name_1 => p_transaction_id_col_name_1

Line 464: (p_location => 'xla_entity_id_mappings_f_pkg.load_row');

460: WHEN NO_DATA_FOUND THEN
461: null;
462: WHEN OTHERS THEN
463: xla_exceptions_pkg.raise_message
464: (p_location => 'xla_entity_id_mappings_f_pkg.load_row');
465:
466: END load_row;
467:
468:

Line 486: end xla_entity_id_mappings_f_pkg;

482: g_log_level := C_LEVEL_LOG_DISABLED;
483: END IF;
484:
485:
486: end xla_entity_id_mappings_f_pkg;