APPS.OZF_CLAIMS_INT_PVT dependencies on OZF_CLAIMS_ALL

Line 2301: -- This procedure purges records from ozf_claims_all and ozf_claim_lines_all tables

2297: ---------------------------------------------------------------------
2298: -- PROCEDURE: cleanup_claims
2299: --
2300: -- PURPOSE:
2301: -- This procedure purges records from ozf_claims_all and ozf_claim_lines_all tables
2302: -- for a given claim_id.
2303: --
2304: -- PARAMETERS:
2305: -- IN:

Line 2325: delete from ozf_claims_all where claim_id = p_claim_id;

2321: OZF_UTILITY_PVT.debug_message('Private API: Clean up Claims');
2322: END IF;
2323: x_return_status := FND_API.G_RET_STS_SUCCESS;
2324:
2325: delete from ozf_claims_all where claim_id = p_claim_id;
2326: delete from ozf_claim_lines_all where claim_id = p_claim_id;
2327:
2328: EXCEPTION
2329: WHEN OTHERS THEN

Line 2342: -- and inserts claims to ozf_claims_all table.

2338: -- PROCEDURE: Start_Replicate
2339: --
2340: -- PURPOSE:
2341: -- This procedure reads information from ozf_claims_int_all table
2342: -- and inserts claims to ozf_claims_all table.
2343: --
2344: -- PARAMETERS:
2345: --
2346: -- OUT:

Line 2389: FROM ozf_claims_all

2385: WHERE cust_trx_type_id = p_id;
2386:
2387: CURSOR claim_number_csr(p_id in number) IS
2388: SELECT claim_number
2389: FROM ozf_claims_all
2390: WHERE claim_id = p_id;
2391: l_claim_number VARCHAR2(30);
2392:
2393: --Multiorg Changes