DBA Data[Home] [Help]

APPS.XLA_FSAH_INT_PVT dependencies on XLA_TRANSACTION_ENTITIES

Line 206: xla_transaction_entities xte

202: xah.attribute10, xah.attribute11, xah.attribute12,
203: xah.attribute13, xah.attribute14, xah.attribute15
204: FROM xla_ae_headers xah,
205: xla_events xe,
206: xla_transaction_entities xte
207: WHERE xte.entity_id = xah.entity_id
208: AND xte.application_id = xah.application_id
209: AND xe.event_id = xah.event_id
210: AND xe.application_id = xah.application_id

Line 879: xla_transaction_entities e,

875: xe.budgetary_control_flag
876: FROM xla_gl_ledgers_v xgl,
877: xla_ae_headers xah,
878: xla_subledgers xsu,
879: xla_transaction_entities e,
880: xla_events xe
881: WHERE xgl.ledger_id = xah.ledger_id
882: AND xsu.application_id = xah.application_id
883: AND xah.event_id = p_event_id

Line 1140: --DBMS_OUTPUT.put_line ('Before Updating the xla_transaction_entities');

1136: p_module => l_log_module
1137: );
1138: END IF;
1139:
1140: --DBMS_OUTPUT.put_line ('Before Updating the xla_transaction_entities');
1141:
1142: IF (c_level_procedure >= g_log_level)
1143: THEN
1144: TRACE (p_msg => 'Before Updating the xla_transaction_entities',

Line 1144: TRACE (p_msg => 'Before Updating the xla_transaction_entities',

1140: --DBMS_OUTPUT.put_line ('Before Updating the xla_transaction_entities');
1141:
1142: IF (c_level_procedure >= g_log_level)
1143: THEN
1144: TRACE (p_msg => 'Before Updating the xla_transaction_entities',
1145: p_level => c_level_procedure,
1146: p_module => l_log_module
1147: );
1148: END IF;

Line 1152: UPDATE xla_transaction_entities

1148: END IF;
1149:
1150: xla_security_pkg.set_security_context (602);
1151:
1152: UPDATE xla_transaction_entities
1153: SET (entity_code, source_id_int_1, source_id_char_1,
1154: security_id_int_1, security_id_int_2, security_id_int_3,
1155: security_id_char_1, security_id_char_2, security_id_char_3,
1156: source_id_int_2, source_id_char_2, source_id_int_3,

Line 1180: FROM xla_transaction_entities

1176: -- LEGAL_ENTITY_ID
1177: -- LEDGER_ID
1178: , SYSDATE, fnd_global.user_id, SYSDATE,
1179: fnd_global.user_id, fnd_global.user_id
1180: FROM xla_transaction_entities
1181: WHERE application_id = p_application_id
1182: AND entity_id = l_entity_id)
1183: WHERE application_id = p_application_id AND entity_id = x_new_entity_id;
1184:

Line 1187: TRACE (p_msg => 'After Updating the the xla_transaction_entities',

1183: WHERE application_id = p_application_id AND entity_id = x_new_entity_id;
1184:
1185: IF (c_level_procedure >= g_log_level)
1186: THEN
1187: TRACE (p_msg => 'After Updating the the xla_transaction_entities',
1188: p_level => c_level_procedure,
1189: p_module => l_log_module
1190: );
1191: END IF;

Line 1193: --DBMS_OUTPUT.put_line ('After Updating the xla_transaction_entities');

1189: p_module => l_log_module
1190: );
1191: END IF;
1192:
1193: --DBMS_OUTPUT.put_line ('After Updating the xla_transaction_entities');
1194: ------------------------------------------------------------------------------
1195: -- HEADERS TABLE UPDATE
1196: ------------------------------------------------------------------------------
1197: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_headers');

Line 1579: xla_transaction_entities xte

1575: SELECT xte.security_id_int_1
1576: INTO l_security_id_int_1
1577: FROM xla_ae_headers xah,
1578: xla_events xe,
1579: xla_transaction_entities xte
1580: WHERE xah.ae_header_id = p_ae_header_id
1581: AND xah.event_id = xe.event_id
1582: AND xah.application_id = xe.application_id
1583: AND xe.application_id = xte.application_id