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 1429: FROM ozf_claims_history_all

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

Line 1437: FROM ozf_claims_history_all

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

Line 2001: SELECT ozf_claims_history_all_s.nextval

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

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

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

Line 2372: FROM ozf_claims_history_all

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

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

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

Line 2526: from ozf_claims_history_all

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