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.2.12020000.3 2013/02/01 17:15:26 bkunjan 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.2.12020000.3 2013/02/01 17:15:26 bkunjan 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 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 1963: l_claims_history_rec OZF_claims_history_PVT.claims_history_rec_type;

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

Line 1990: --FROM ozf_claims_history

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

Line 1996: --FROM ozf_claims_history

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

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

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

Line 2198: OZF_claims_history_PVT.Create_claims_history(

2194: l_claims_history_rec.cstl_wf_item_key := l_claim_rec.cstl_wf_item_key;
2195: l_claims_history_rec.batch_type := l_claim_rec.batch_type;
2196:
2197:
2198: OZF_claims_history_PVT.Create_claims_history(
2199: P_Api_Version_Number => 1.0,
2200: P_Init_Msg_List => FND_API.G_FALSE,
2201: P_Commit => FND_API.G_FALSE,
2202: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

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

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

Line 2414: OZF_claims_history_PKG.Delete_Row(

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

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

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

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

Line 2612: OZF_claims_history_PKG.Update_Row(

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

Line 2931: End OZF_claims_history_PVT;

2927: p_data => x_msg_data
2928: );
2929: End Validate_claims_history;
2930:
2931: End OZF_claims_history_PVT;