[Home] [Help]
1041: END IF;
1042: END IF;
1043:
1044: --
1045: -- Update xla_transaction_entities if ledger entity id is updated
1046: --
1047: IF (l_info.legal_entity_id <> p_legal_entity_id) THEN
1048: UPDATE xla_transaction_entities
1049: SET legal_entity_id = p_legal_entity_id
1044: --
1045: -- Update xla_transaction_entities if ledger entity id is updated
1046: --
1047: IF (l_info.legal_entity_id <> p_legal_entity_id) THEN
1048: UPDATE xla_transaction_entities
1049: SET legal_entity_id = p_legal_entity_id
1050: WHERE application_id = p_application_id -- 4928660
1051: AND entity_id = l_info.entity_id;
1052: END IF;
1071: -- Bug 11743330/10132068 UNDO draft if not Secondary Manual created through UI
1072:
1073: SELECT count(1)
1074: INTO l_sla_manual
1075: FROM xla_transaction_entities xte
1076: ,xla_ledger_relationships_v xlr
1077: WHERE xte.application_id=l_info.application_id
1078: AND xte.entity_id=l_info.entity_id
1079: AND xte.entity_code = 'MANUAL'
1231: ,h.funds_status_code funds_status_code
1232: ,h.packet_id packet_id
1233: ,h.entity_id entity_id
1234: FROM xla_ae_headers h
1235: ,xla_transaction_entities e
1236: WHERE e.application_id = p_application_id
1237: AND e.entity_id = h.entity_id
1238: AND h.application_id = p_application_id
1239: AND h.event_id = p_event_id
2449: --
2450: IF (l_info.balance_type_code <> 'B') THEN
2451: SELECT count(1)
2452: INTO l_sla_manual
2453: FROM xla_transaction_entities xte
2454: , xla_ledger_relationships_v xlr
2455: WHERE xte.application_id=l_info.application_id
2456: AND xte.entity_id=l_info.entity_id
2457: AND xte.entity_code = 'MANUAL'
3241: ,xah.attribute14
3242: ,xah.attribute15
3243: FROM xla_ae_headers xah
3244: ,xla_events xe
3245: ,xla_transaction_entities xte
3246: WHERE xte.entity_id = xah.entity_id
3247: AND xte.application_id = xah.application_id
3248: AND xe.event_id = xah.event_id
3249: AND xe.application_id = xah.application_id