APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_XLA_CLAIM_HEADERS

Line 2310: SELECT OZF_XLA_CLAIM_HEADERS_S.NEXTVAL

2306: AND cln.claim_id = p_claim_id;
2307:
2308:
2309: CURSOR c_xla_claims_header_seq IS
2310: SELECT OZF_XLA_CLAIM_HEADERS_S.NEXTVAL
2311: FROM DUAL;
2312:
2313: --//ER 12985686
2314: CURSOR c_get_entity_type_code(cv_event_type_code IN VARCHAR2) IS

Line 2323: FROM ozf_xla_claim_headers

2319:
2320: -- Fix for Bug#13542516
2321: CURSOR c_get_parent_event_id(p_claim_id IN NUMBER) IS
2322: SELECT event_id,xla_claim_header_id
2323: FROM ozf_xla_claim_headers
2324: WHERE claim_id = p_claim_id
2325: AND event_type_code <> 'CLAIM_SETTLEMENT_REVERSAL'
2326: order by event_id desc;
2327:

Line 2486: UPDATE ozf_xla_claim_headers

2482: OZF_Utility_PVT.debug_message('l_parent_header_id : '||l_parent_header_id);
2483: END IF;
2484:
2485: --update parent's reversal_event_id with the reversal event
2486: UPDATE ozf_xla_claim_headers
2487: SET related_event_id = l_xla_event_id
2488: WHERE xla_claim_header_id = l_parent_header_id;
2489:
2490: l_reversal_flag := 'Y';

Line 2502: INSERT INTO OZF_XLA_CLAIM_HEADERS

2498: OPEN c_xla_claims_header_seq;
2499: FETCH c_xla_claims_header_seq INTO l_xla_claim_hed_seq;
2500: CLOSE c_xla_claims_header_seq;
2501:
2502: INSERT INTO OZF_XLA_CLAIM_HEADERS
2503: (XLA_CLAIM_HEADER_ID
2504: ,EVENT_TYPE_CODE
2505: ,ENTITY_CODE
2506: ,EVENT_ID