APPS.XLA_MPA_JLT_ADR_ASSGNS_F_PVT dependencies on XLA_MPA_JLT_ADR_ASSGNS

Line 1: PACKAGE BODY XLA_MPA_JLT_ADR_ASSGNS_F_PVT AS

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

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

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

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

Line 70: from xla_mpa_jlt_adr_assgns

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

Line 95: INSERT INTO XLA_MPA_JLT_ADR_ASSGNS (

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

Line 193: UPDATE XLA_MPA_JLT_ADR_ASSGNS

189: p_module => l_log_module,
190: p_level => C_LEVEL_PROCEDURE);
191: END IF;
192:
193: UPDATE XLA_MPA_JLT_ADR_ASSGNS
194: SET segment_rule_appl_id = x_segment_rule_appl_id,
195: segment_rule_type_code = x_segment_rule_type_code,
196: segment_rule_code = x_segment_rule_code,
197: inherit_adr_flag = x_inherit_adr_flag,

Line 245: from xla_mpa_jlt_adr_assgns

241: ) IS
242:
243: Cursor C is
244: Select *
245: from xla_mpa_jlt_adr_assgns
246: where amb_context_code = x_amb_context_code
247: and application_id = x_application_id
248: and event_type_code = x_event_type_code
249: and line_definition_owner_code = x_line_definition_owner_code

Line 327: DELETE XLA_MPA_JLT_ADR_ASSGNS

323: p_level => C_LEVEL_PROCEDURE);
324: End If;
325:
326:
327: DELETE XLA_MPA_JLT_ADR_ASSGNS
328: where amb_context_code = x_amb_context_code
329: and application_id = x_application_id
330: and event_type_code = x_event_type_code
331: and line_definition_owner_code = x_line_definition_owner_code

Line 353: END XLA_MPA_JLT_ADR_ASSGNS_F_PVT;

349:
350: END Delete_Row;
351:
352:
353: END XLA_MPA_JLT_ADR_ASSGNS_F_PVT;