eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIMS_HISTORY_PVT dependencies on OZF_CLAIMS_HISTORY

Line 1: PACKAGE BODY OZF_claims_history_PVT as

1: PACKAGE BODY OZF_claims_history_PVT as
2: /* $Header: ozfvchib.pls 120.1 2005/09/15 22:40:06 appldev ship $ */
3: -- Start of Comments
4: -- Package name : OZF_claims_history_PVT
5: -- Purpose :

Line 4: -- Package name : OZF_claims_history_PVT

1: PACKAGE BODY OZF_claims_history_PVT as
2: /* $Header: ozfvchib.pls 120.1 2005/09/15 22:40:06 appldev ship $ */
3: -- Start of Comments
4: -- Package name : OZF_claims_history_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_claims_history_PVT';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_claims_history_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvchib.pls';
12:
13: G_UPDATE_EVENT CONSTANT VARCHAR2(30) := 'UPDATE';
14: G_LINE_EVENT CONSTANT VARCHAR2(30) := 'LINE';

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 1020: -- Invoke table handler(OZF_claims_history_PKG.Insert_Row)

1016: END IF;
1017:
1018: l_org_id := p_claims_history_rec.org_id;
1019:
1020: -- Invoke table handler(OZF_claims_history_PKG.Insert_Row)
1021: BEGIN
1022: OZF_claims_history_PKG.Insert_Row(
1023: px_CLAIM_HISTORY_ID => l_claim_history_id,
1024: px_OBJECT_VERSION_NUMBER => l_object_version_number,

Line 1022: OZF_claims_history_PKG.Insert_Row(

1018: l_org_id := p_claims_history_rec.org_id;
1019:
1020: -- Invoke table handler(OZF_claims_history_PKG.Insert_Row)
1021: BEGIN
1022: OZF_claims_history_PKG.Insert_Row(
1023: px_CLAIM_HISTORY_ID => l_claim_history_id,
1024: px_OBJECT_VERSION_NUMBER => l_object_version_number,
1025: p_LAST_UPDATE_DATE => SYSDATE,
1026: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

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 1961: l_claims_history_rec OZF_claims_history_PVT.claims_history_rec_type;

1957: l_msg_data varchar2(2000);
1958: l_return_status varchar2(30);
1959: l_api_name varchar2(30) := 'Create_History';
1960:
1961: l_claims_history_rec OZF_claims_history_PVT.claims_history_rec_type;
1962: l_claim_history_id number := null;
1963:
1964: l_claim_lines_hist_rec OZF_claim_line_hist_PVT.claim_line_hist_rec_type;
1965: l_claim_line_history_id number;

Line 1988: --FROM ozf_claims_history

1984: WHERE claim_id = p_id;
1985:
1986: --CURSOR history_ids_csr(p_claim_id) IS
1987: --SELECT line_claim_history_id, task_claim_history_id
1988: --FROM ozf_claims_history
1989: --WHERE claim_id = p_claim_id
1990: --AND event_date = max(event_date);
1991:
1992: --CURSOR history_ids_csr(p_claim_id) IS

Line 1994: --FROM ozf_claims_history

1990: --AND event_date = max(event_date);
1991:
1992: --CURSOR history_ids_csr(p_claim_id) IS
1993: --SELECT line_claim_history_id
1994: --FROM ozf_claims_history
1995: --WHERE claim_id = p_claim_id
1996: --AND event_date = max(event_date);
1997:
1998: CURSOR claim_history_sequence_cur IS

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 2009: from ozf_claims_history

2005: where claim_id = pid;
2006:
2007: CURSOR c_claim_hist_id_count(p_id in number) is
2008: select count(*)
2009: from ozf_claims_history
2010: where claim_history_id =p_id;
2011: l_claim_hist_id_count number:=0;
2012:
2013: l_history_event varchar2(40);

Line 2189: OZF_claims_history_PVT.Create_claims_history(

2185: l_claims_history_rec.cstl_wf_item_key := l_claim_rec.cstl_wf_item_key;
2186: l_claims_history_rec.batch_type := l_claim_rec.batch_type;
2187:
2188:
2189: OZF_claims_history_PVT.Create_claims_history(
2190: P_Api_Version_Number => 1.0,
2191: P_Init_Msg_List => FND_API.G_FALSE,
2192: P_Commit => FND_API.G_FALSE,
2193: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

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 2405: -- Invoke table handler(OZF_claims_history_PKG.Delete_Row)

2401: FND_MESSAGE.Set_Token('TEXT',l_api_name||': Start');
2402: FND_MSG_PUB.Add;
2403: END IF;
2404:
2405: -- Invoke table handler(OZF_claims_history_PKG.Delete_Row)
2406: OPEN version_csr(p_claim_history_id);
2407: FETCH version_csr INTO l_object_version_number;
2408: CLOSE version_csr;
2409:

Line 2412: OZF_claims_history_PKG.Delete_Row(

2408: CLOSE version_csr;
2409:
2410: IF p_object_version_number = l_object_version_number THEN
2411: BEGIN
2412: OZF_claims_history_PKG.Delete_Row(
2413: p_CLAIM_HISTORY_ID => p_CLAIM_HISTORY_ID);
2414: EXCEPTION
2415: WHEN OTHERS THEN
2416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

Line 2608: -- Invoke table handler(OZF_claims_history_PKG.Update_Row)

2604: END IF;
2605: END IF;
2606:
2607:
2608: -- Invoke table handler(OZF_claims_history_PKG.Update_Row)
2609: Begin
2610: OZF_claims_history_PKG.Update_Row(
2611: p_CLAIM_HISTORY_ID => l_CLAIMS_HISTORY_rec.CLAIM_HISTORY_ID,
2612: p_OBJECT_VERSION_NUMBER => l_CLAIMS_HISTORY_rec.OBJECT_VERSION_NUMBER +1 ,

Line 2610: OZF_claims_history_PKG.Update_Row(

2606:
2607:
2608: -- Invoke table handler(OZF_claims_history_PKG.Update_Row)
2609: Begin
2610: OZF_claims_history_PKG.Update_Row(
2611: p_CLAIM_HISTORY_ID => l_CLAIMS_HISTORY_rec.CLAIM_HISTORY_ID,
2612: p_OBJECT_VERSION_NUMBER => l_CLAIMS_HISTORY_rec.OBJECT_VERSION_NUMBER +1 ,
2613: p_LAST_UPDATE_DATE => SYSDATE,
2614: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 2929: End OZF_claims_history_PVT;

2925: p_data => x_msg_data
2926: );
2927: End Validate_claims_history;
2928:
2929: End OZF_claims_history_PVT;