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_CLAIM_PVT dependencies on OZF_CLAIMS

Line 202: FROM ozf_claims_all

198:
199: IS
200: CURSOR Claim_Number_csr(p_claim_id in number) IS
201: SELECT claim_number
202: FROM ozf_claims_all
203: WHERE claim_id = p_claim_id;
204:
205: CURSOR Number_of_Split_csr(p_split_from_claim_id in number) IS
206: SELECT count(claim_id)

Line 207: FROM ozf_claims_all

203: WHERE claim_id = p_claim_id;
204:
205: CURSOR Number_of_Split_csr(p_split_from_claim_id in number) IS
206: SELECT count(claim_id)
207: FROM ozf_claims_all
208: WHERE split_from_claim_id = p_split_from_claim_id;
209:
210: CURSOR c_seq_csr IS
211: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)

Line 221: FROM ozf_claims_all

217: WHERE custom_setup_id = p_id;
218:
219: CURSOR claim_number_count_csr(p_claim_number in varchar2) IS
220: SELECT count(claim_number)
221: FROM ozf_claims_all
222: WHERE upper(claim_number) = p_claim_number;
223:
224: l_count number := -1;
225:

Line 1927: -- amount field in the ozf_claims_all table.

1923: -- check_amount
1924: --
1925: -- PURPOSE
1926: -- This procedure checks whether there is a need to change the
1927: -- amount field in the ozf_claims_all table.
1928: --
1929: -- PARAMETERS
1930: -- p_claim in claim_rec_type,
1931: -- p_mode in varchar2

Line 1957: FROM ozf_claims_all

1953: amount,
1954: amount_adjusted,
1955: amount_settled,
1956: cust_account_id
1957: FROM ozf_claims_all
1958: WHERE claim_id = p_id;
1959:
1960: l_info amount_csr%rowtype;
1961:

Line 2089: FROM ozf_claims_all

2085: l_claim_id NUMBER;
2086:
2087: CURSOR get_claim_id_csr(p_id in number) IS
2088: SELECT count(claim_id)
2089: FROM ozf_claims_all
2090: WHERE claim_id = p_id;
2091:
2092: CURSOR get_claim_id_num_csr(p_num in varchar2) IS
2093: SELECT count(claim_id)

Line 2094: FROM ozf_claims_all

2090: WHERE claim_id = p_id;
2091:
2092: CURSOR get_claim_id_num_csr(p_num in varchar2) IS
2093: SELECT count(claim_id)
2094: FROM ozf_claims_all
2095: WHERE claim_number = p_num;
2096:
2097: CURSOR get_count_csr(p_number in varchar2,
2098: p_claim_id in number) IS

Line 2100: FROM ozf_claims_all

2096:
2097: CURSOR get_count_csr(p_number in varchar2,
2098: p_claim_id in number) IS
2099: SELECT count(claim_id)
2100: FROM ozf_claims_all
2101: WHERE claim_number = p_number
2102: AND claim_id = p_claim_id;
2103:
2104: l_count number:=0;

Line 2285: FROM ozf_claims_all

2281: exchange_rate_type,
2282: exchange_rate,
2283: amount,
2284: cust_account_id
2285: FROM ozf_claims_all
2286: WHERE claim_id = p_id;
2287:
2288: l_deduction_info deduction_info_csr%rowtype;
2289:

Line 2360: SELECT * FROM ozf_claims_all

2356: ,x_return_status OUT NOCOPY varchar2
2357: )
2358: IS
2359: CURSOR c_claim (cv_claim_id NUMBER) IS
2360: SELECT * FROM ozf_claims_all
2361: WHERE CLAIM_ID = cv_claim_id;
2362:
2363: l_claim_rec c_claim%ROWTYPE;
2364:

Line 3350: SELECT ozf_claims_all_s.nextval FROM dual;

3346:
3347: l_auto_assign_flag varchar2(1);
3348:
3349: CURSOR claim_id_csr IS
3350: SELECT ozf_claims_all_s.nextval FROM dual;
3351:
3352: CURSOR trade_profile_csr(p_customer_account_id in number) IS
3353: SELECT vendor_id, vendor_site_id
3354: FROM ozf_cust_trd_prfls

Line 3371: FROM ozf_claims_all

3367: FROM dual; */
3368:
3369: CURSOR claim_number_count_csr(p_claim_number in varchar2) IS
3370: SELECT count(claim_number)
3371: FROM ozf_claims_all
3372: WHERE upper(claim_number) = p_claim_number;
3373: l_temp_claim_number varchar2(30);
3374:
3375: l_count number:=0;

Line 3379: from ozf_claims

3375: l_count number:=0;
3376:
3377: CURSOR claim_id_count_csr(p_id in number) is
3378: select count(*)
3379: from ozf_claims
3380: where claim_id =p_id;
3381:
3382: l_claim_id_count number:=0;
3383:

Line 4023: OZF_claims_PKG.Insert_Row(

4019:
4020: -- End Bug:2781186 ---------------------------------------------------------------------------
4021:
4022: BEGIN
4023: OZF_claims_PKG.Insert_Row(
4024: px_CLAIM_ID => l_claim_id,
4025: px_OBJECT_VERSION_NUMBER => l_object_version_number,
4026: p_LAST_UPDATE_DATE => SYSDATE,
4027: p_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),

Line 4359: --owner VARCHAR2(240) ozf_claims_v.owner_id owner

4355: -- view_name/table_name ozf_claim_lines_b jtf_tasks_v
4356: -- name VARCHAR2(240) line_number Task_number
4357: --type VARCHAR2(30) LINE TASK
4358: --status VARCHAR2(30) NEW Task_status
4359: --owner VARCHAR2(240) ozf_claims_v.owner_id owner
4360: --deletable_flag VARCHAR2(1) Y
4361:
4362:
4363: ---------------------------------------------------------------------

Line 4385: FROM ozf_claims_v

4381: l_msg_count number;
4382:
4383: CURSOR claim_info_csr (p_id in number) IS
4384: SELECT object_version_number, owner_id, status_code
4385: FROM ozf_claims_v
4386: WHERE claim_id = p_id;
4387: l_object_version_number number;
4388: l_status_code varchar2(30);
4389: l_owner_id number;

Line 4633: FROM ozf_claims_all

4629: l_claim_line_hist_id number;
4630:
4631: CURSOR claim_info_csr (p_id in number) IS
4632: SELECT object_version_number, status_code
4633: FROM ozf_claims_all
4634: WHERE claim_id = p_id;
4635: l_object_version_number number;
4636: l_status_code varchar2(30);
4637:

Line 4659: from ozf_claims_history_all

4655:
4656: -- Fix for 5048675
4657: CURSOR claim_history_id_csr(p_id in number) is
4658: select claim_history_id, object_version_number
4659: from ozf_claims_history_all
4660: where claim_id = p_id;
4661:
4662: CURSOR claim_line_his_id_csr(p_id in number) is
4663: select claim_line_history_id, object_version_number

Line 4739: OZF_claims_history_PVT.Delete_claims_history(

4735: LOOP
4736: FETCH claim_history_id_csr into l_claim_history_id, l_object_version_number;
4737: EXIT When claim_history_id_csr%NOTFOUND;
4738:
4739: OZF_claims_history_PVT.Delete_claims_history(
4740: P_Api_Version_Number => l_api_version
4741: ,P_Init_Msg_List => FND_API.g_false
4742: ,P_Commit => FND_API.g_false
4743: ,p_validation_level => FND_API.g_valid_level_full

Line 4815: OZF_claims_PKG.Delete_Row(p_object_id);

4811: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4812: RAISE FND_API.g_exc_unexpected_error;
4813: END IF;
4814:
4815: OZF_claims_PKG.Delete_Row(p_object_id);
4816: ELSE
4817: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4818: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_DEL_CLAIM');
4819: FND_MSG_PUB.add;

Line 4911: FROM ozf_claims_all

4907: l_return_status varchar2(3);
4908:
4909: CURSOR reason_csr(p_id in number) IS
4910: SELECT reason_code_id, task_template_group_id
4911: FROM ozf_claims_all
4912: WHERE claim_id = p_id;
4913:
4914: BEGIN
4915: -- Initialize API return status to sucess

Line 5013: from ozf_claims_all

5009: l_claim_history_id NUMBER := null;
5010: l_status_code varchar2(30);
5011: CURSOR user_status_id_csr(p_id in number) is
5012: select user_status_id
5013: from ozf_claims_all
5014: where claim_id = p_id;
5015:
5016: l_user_status_id number;
5017: BEGIN

Line 5065: OZF_claims_history_PVT.Check_Create_History(

5061: -- If the status_code is not new, then I will to create_claim_history
5062: --Comment out the below line (uday) since we will be creating the history
5063: -- at the time of claim creation also.
5064: --IF l_status_code <> G_INIT_STATUS THEN
5065: OZF_claims_history_PVT.Check_Create_History(
5066: p_claim => p_claim,
5067: p_event => p_event,
5068: x_history_event => l_history_event,
5069: x_history_event_description => l_history_event_description,

Line 5081: OZF_claims_history_PVT.Create_History(

5077: END IF;
5078:
5079: IF (l_needed_to_create = 'Y') THEN
5080: -- CREATE history
5081: OZF_claims_history_PVT.Create_History(
5082: p_claim_id => p_claim.claim_id,
5083: p_history_event => l_history_event,
5084: p_history_event_description => l_history_event_description,
5085: x_claim_history_id => l_claim_history_id,

Line 5223: from ozf_claims_all

5219: where claim_id = p_id;
5220:
5221: CURSOR object_version_number_csr (p_id in number) is
5222: select object_version_number
5223: from ozf_claims_all
5224: where claim_id = p_id;
5225:
5226: CURSOR tasks_csr(p_claim_id in number,
5227: p_completed_flag in varchar2) IS

Line 5243: FROM ozf_claims_history_all

5239: l_uncompleted_tasks_tbl tasks_csr_Tbl_Type;
5240:
5241: CURSOR claim_history_tbl_csr(p_claim_id in number) IS
5242: SELECT claim_history_id, object_version_number
5243: FROM ozf_claims_history_all
5244: WHERE task_source_object_id = p_claim_id
5245: AND task_source_object_type_code = G_CLAIM_TYPE
5246: AND claim_id = p_claim_id;
5247:

Line 5252: l_claim_history_rec OZF_claims_history_PVT.claims_history_Rec_Type;

5248: TYPE CLAIMS_HISTORY_Tbl_Type IS TABLE OF CLAIM_HISTORY_tbl_csr%rowtype
5249: INDEX BY BINARY_INTEGER;
5250: l_claim_history_tbl CLAIMS_HISTORY_Tbl_Type;
5251:
5252: l_claim_history_rec OZF_claims_history_PVT.claims_history_Rec_Type;
5253:
5254:
5255: CURSOR old_info_csr (p_id in number) IS
5256: SELECT user_status_id,

Line 5265: FROM ozf_claims_all

5261: owner_id,
5262: customer_ref_number,
5263: customer_ref_normalized,
5264: write_off_flag
5265: FROM ozf_claims_all
5266: WHERE claim_id = p_id;
5267: l_old_status_code varchar2(30);
5268: l_prev_status_code varchar2(30);
5269: l_old_user_status_id number;

Line 5300: FROM ozf_claims_all

5296: l_sales_rep_id NUMBER;
5297:
5298: CURSOR user_status_id_csr (p_id in number) IS
5299: SELECT user_status_id
5300: FROM ozf_claims_all
5301: WHERE claim_id = p_id;
5302:
5303: CURSOR status_code_csr (p_id in number) IS
5304: SELECT status_code

Line 5305: FROM ozf_claims_all

5301: WHERE claim_id = p_id;
5302:
5303: CURSOR status_code_csr (p_id in number) IS
5304: SELECT status_code
5305: FROM ozf_claims_all
5306: WHERE claim_id = p_id;
5307:
5308: -- fix for bug 5042046
5309: CURSOR auto_assign_flag_csr IS

Line 5331: FROM ozf_claims_all

5327: l_resource_id number;
5328:
5329: CURSOR tax_amount_csr(p_id in number) IS
5330: SELECT tax_amount
5331: FROM ozf_claims_all
5332: WHERE claim_id = p_id;
5333:
5334: l_tax_amount number;
5335:

Line 5378: FROM ozf_claims_all

5374:
5375: CURSOR csr_user_status_info(p_claim_id in number) is
5376: SELECT open_status_id,
5377: close_status_id
5378: FROM ozf_claims_all
5379: WHERE claim_id = p_claim_id;
5380: --
5381: BEGIN
5382: -- Standard begin of API savepoint

Line 6207: OZF_claims_PKG.Update_Row(

6203: END IF;
6204: -- End Bug: 2732290 -----------------------------------------------------------
6205:
6206: BEGIN
6207: OZF_claims_PKG.Update_Row(
6208: p_CLAIM_ID => l_claim.CLAIM_ID,
6209: p_OBJECT_VERSION_NUMBER => l_object_version_number,
6210: p_LAST_UPDATE_DATE => SYSDATE,
6211: p_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),

Line 6363: UPDATE ozf_claims_all

6359: END;
6360: l_rec_num := 1;
6361:
6362: IF l_user_sel_status_code_id IS NOT NULL THEN
6363: UPDATE ozf_claims_all
6364: SET close_status_id = l_user_sel_status_code_id
6365: WHERE claim_id = l_claim.claim_id;
6366: END IF;
6367:

Line 6398: UPDATE ozf_claims_all

6394: CLOSE status_code_csr;
6395:
6396: -- Update the claim with the user selected Close status id
6397: IF l_curr_status_code = 'CLOSED' THEN
6398: UPDATE ozf_claims_all
6399: SET user_status_id = close_status_id
6400: WHERE claim_id = l_claim.claim_id
6401: AND close_status_id IS NOT NULL;
6402: END IF;

Line 6518: update ozf_claims_history_all

6514: END IF;
6515: END IF;
6516: /*
6517: -- Temp solution for update the claim history
6518: update ozf_claims_history_all
6519: set task_source_object_id = l_claim_history_id,
6520: task_source_object_type_code = G_CLAIM_HISTORY_TYPE
6521: where task_source_object_id = l_claim.claim_id
6522: and task_source_object_id = G_OBJECT_TYPE

Line 6538: -- l_claim_history_rec := OZF_claims_history_PVT.claims_history_rec_type;

6534: END LOOP;
6535: CLOSE claim_history_tbl_csr;
6536:
6537: For i in 1..l_claim_history_tbl.count LOOP
6538: -- l_claim_history_rec := OZF_claims_history_PVT.claims_history_rec_type;
6539: l_claim_history_rec.object_version_number := l_claim_history_tbl(i).object_version_number;
6540: l_claim_history_rec.claim_history_id := l_claim_history_tbl(i).claim_history_id;
6541: l_claim_history_rec.task_source_object_id := l_claim_history_id;
6542: l_claim_history_rec.task_source_object_type_code := G_CLAIM_HISTORY_TYPE;

Line 6544: OZF_claims_history_PVT.Update_claims_history(

6540: l_claim_history_rec.claim_history_id := l_claim_history_tbl(i).claim_history_id;
6541: l_claim_history_rec.task_source_object_id := l_claim_history_id;
6542: l_claim_history_rec.task_source_object_type_code := G_CLAIM_HISTORY_TYPE;
6543:
6544: OZF_claims_history_PVT.Update_claims_history(
6545: P_Api_Version_Number => 1.0,
6546: P_Init_Msg_List => FND_API.G_FALSE,
6547: P_Commit => FND_API.G_FALSE,
6548: p_validation_level => FND_API.G_VALID_LEVEL_FULL,