APPS.XLA_MPA_JLT_ASSGNS_F_PVT dependencies on XLA_MPA_JLT_ASSGNS

Line 1: PACKAGE BODY XLA_MPA_JLT_ASSGNS_F_PVT AS

1: PACKAGE BODY XLA_MPA_JLT_ASSGNS_F_PVT AS
2: /* $Header: xlathmjl.pkb 120.0 2005/06/24 01:28:16 eklau noship $ */
3:
4: --=============================================================================
5: -- *********** Local Trace Routine **********

Line 15: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.XLA_MPA_JLT_ASSGNS_F_PVT';

11: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13:
14: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
15: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.XLA_MPA_JLT_ASSGNS_F_PVT';
16:
17: g_log_level NUMBER;
18: g_log_enabled BOOLEAN;
19:

Line 40: (p_location => 'XLA_MPA_JLT_ASSGNS_F_PVT.trace');

36: RAISE;
37:
38: WHEN OTHERS THEN
39: xla_exceptions_pkg.raise_message
40: (p_location => 'XLA_MPA_JLT_ASSGNS_F_PVT.trace');
41: END trace;
42:
43:
44:

Line 69: from xla_mpa_jlt_assgns

65: ) IS
66:
67: Cursor C is
68: Select rowid
69: from xla_mpa_jlt_assgns
70: where amb_context_code = x_amb_context_code
71: and application_id = x_application_id
72: and event_type_code = x_event_type_code
73: and line_definition_owner_code = x_line_definition_owner_code

Line 94: INSERT INTO XLA_MPA_JLT_ASSGNS (

90: p_module => l_log_module,
91: p_level => C_LEVEL_PROCEDURE);
92: End If;
93:
94: INSERT INTO XLA_MPA_JLT_ASSGNS (
95: AMB_CONTEXT_CODE,
96: APPLICATION_ID,
97: EVENT_CLASS_CODE,
98: EVENT_TYPE_CODE,

Line 186: UPDATE XLA_MPA_JLT_ASSGNS

182: p_module => l_log_module,
183: p_level => C_LEVEL_PROCEDURE);
184: END IF;
185:
186: UPDATE XLA_MPA_JLT_ASSGNS
187: SET inherit_desc_flag = x_inherit_desc_flag,
188: description_type_code = x_description_type_code,
189: description_code = x_description_code,
190: last_update_date = x_last_update_date,

Line 234: from xla_mpa_jlt_assgns

230: ) IS
231:
232: Cursor C is
233: Select *
234: from xla_mpa_jlt_assgns
235: where amb_context_code = x_amb_context_code
236: and application_id = x_application_id
237: and event_type_code = x_event_type_code
238: and line_definition_owner_code = x_line_definition_owner_code

Line 311: DELETE from XLA_MPA_JLT_ASSGNS

307: p_module => l_log_module,
308: p_level => C_LEVEL_PROCEDURE);
309: End If;
310:
311: DELETE from XLA_MPA_JLT_ASSGNS
312: where amb_context_code = x_amb_context_code
313: and application_id = x_application_id
314: and event_type_code = x_event_type_code
315: and line_definition_owner_code = x_line_definition_owner_code

Line 352: END XLA_MPA_JLT_ASSGNS_F_PVT;

348: IF NOT g_log_enabled THEN
349: g_log_level := C_LEVEL_LOG_DISABLED;
350: END IF;
351:
352: END XLA_MPA_JLT_ASSGNS_F_PVT;