APPS.OZF_CLAIMS_HISTORY_PVT dependencies on OZF_CLAIMS_HISTORY_ALL

Line 63: SELECT * FROM ozf_claims_history_all

59: ,x_return_status OUT NOCOPY varchar2
60: )
61: IS
62: CURSOR c_claim_history_csr (p_id in NUMBER) IS
63: SELECT * FROM ozf_claims_history_all
64: WHERE claim_history_id = p_id;
65:
66: l_claim_history_rec c_claim_history_csr%ROWTYPE;
67: l_api_name varchar2(30) := 'Complete_Claim_History_Rec';

Line 919: -- This procedure inserts a record in ozf_claims_history_all table by calling

915: -- PROCEDURE
916: -- Create_Claims_History
917: --
918: -- PURPOSE
919: -- This procedure inserts a record in ozf_claims_history_all table by calling
920: -- the table handler package.
921: --
922: -- PARAMETERS
923: -- p_CLAIMS_HISTORY_Rec: The record that you want to insert.

Line 1427: FROM ozf_claims_history_all

1423: related_site_use_id,
1424: relationship_type,
1425: vendor_id,
1426: vendor_site_id
1427: FROM ozf_claims_history_all
1428: WHERE claim_id = p_id
1429: order by claim_history_id desc;
1430:
1431: l_claim_rec claim_rec_csr%rowtype;

Line 1435: FROM ozf_claims_history_all

1431: l_claim_rec claim_rec_csr%rowtype;
1432:
1433: CURSOR history_exists_csr(p_id in number) IS
1434: SELECT claim_history_id
1435: FROM ozf_claims_history_all
1436: WHERE claim_id = p_id;
1437:
1438: l_api_name varchar2(30):='Check_Create_history';
1439: l_status_changed boolean := false;

Line 1999: SELECT ozf_claims_history_all_s.nextval

1995: --WHERE claim_id = p_claim_id
1996: --AND event_date = max(event_date);
1997:
1998: CURSOR claim_history_sequence_cur IS
1999: SELECT ozf_claims_history_all_s.nextval
2000: FROM dual;
2001:
2002: CURSOR check_csr (pid in number)is
2003: select history_event, history_event_description

Line 2342: -- This procedure deletes a record in ozf_claims_history_all table by calling

2338: -- PROCEDURE
2339: -- Delete_Claims_History
2340: --
2341: -- PURPOSE
2342: -- This procedure deletes a record in ozf_claims_history_all table by calling
2343: -- the table handler package.
2344: --
2345: -- PARAMETERS
2346: -- p_CLAIMS_HISTORY_Rec: The record that you want to delete.

Line 2370: FROM ozf_claims_history_all

2366: l_object_version_number NUMBER;
2367:
2368: CURSOR version_csr (p_claim_history_id in number)IS
2369: SELECT object_version_number
2370: FROM ozf_claims_history_all
2371: WHERE claim_history_id = p_claim_history_id;
2372:
2373: BEGIN
2374: -- Standard Start of API savepoint

Line 2491: -- This procedure updates a record in ozf_claims_history_all table by calling

2487: -- PROCEDURE
2488: -- Update_Claims_History
2489: --
2490: -- PURPOSE
2491: -- This procedure updates a record in ozf_claims_history_all table by calling
2492: -- the table handler package.
2493: --
2494: -- PARAMETERS
2495: -- p_CLAIMS_HISTORY_Rec: The record that you want to update.

Line 2524: from ozf_claims_history_all

2520: l_claims_history_rec claims_history_rec_type;
2521:
2522: CURSOR object_version_number_csr (p_id in number) is
2523: select object_version_number
2524: from ozf_claims_history_all
2525: where claim_history_id = p_id;
2526:
2527:
2528: BEGIN