APPS.XLA_MPA_JLT_AC_ASSGNS_F_PVT dependencies on XLA_MPA_JLT_AC_ASSGNS

Line 1: PACKAGE BODY XLA_MPA_JLT_AC_ASSGNS_F_PVT AS

1: PACKAGE BODY XLA_MPA_JLT_AC_ASSGNS_F_PVT AS
2: /* $Header: xlathmac.pkb 120.0 2005/06/24 01:29:05 eklau noship $ */
3:
4: --=============================================================================
5: -- *********** Local Trace Routine **********

Line 15: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.XLA_MPA_JLT_AC_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_AC_ASSGNS_F_PVT';
16:
17: g_log_level NUMBER;
18: g_log_enabled BOOLEAN;
19:

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

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

Line 68: from xla_mpa_jlt_ac_assgns

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

Line 95: INSERT INTO XLA_MPA_JLT_AC_ASSGNS (

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

Line 250: UPDATE XLA_MPA_JLT_AC_ASSGNS

246: p_module => l_log_module,
247: p_level => C_LEVEL_PROCEDURE);
248: END IF;
249:
250: UPDATE XLA_MPA_JLT_AC_ASSGNS
251: SET mpa_inherit_ac_flag = x_mpa_inherit_ac_flag,
252: last_update_date = x_last_update_date,
253: object_version_number = object_version_number + 1,
254: last_updated_by = x_last_updated_by,

Line 310: DELETE XLA_MPA_JLT_AC_ASSGNS

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

Line 353: END XLA_MPA_JLT_AC_ASSGNS_F_PVT;

349: g_log_level := C_LEVEL_LOG_DISABLED;
350: END IF;
351:
352:
353: END XLA_MPA_JLT_AC_ASSGNS_F_PVT;