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 209: FROM ozf_claims_all

205:
206: IS
207: CURSOR Claim_Number_csr(p_claim_id in number) IS
208: SELECT claim_number
209: FROM ozf_claims_all
210: WHERE claim_id = p_claim_id;
211:
212: CURSOR Number_of_Split_csr(p_split_from_claim_id in number) IS
213: SELECT count(claim_id)

Line 214: FROM ozf_claims_all

210: WHERE claim_id = p_claim_id;
211:
212: CURSOR Number_of_Split_csr(p_split_from_claim_id in number) IS
213: SELECT count(claim_id)
214: FROM ozf_claims_all
215: WHERE split_from_claim_id = p_split_from_claim_id;
216:
217: CURSOR c_seq_csr IS
218: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)

Line 228: FROM ozf_claims_all

224: WHERE custom_setup_id = p_id;
225:
226: CURSOR claim_number_count_csr(p_claim_number in varchar2) IS
227: SELECT count(claim_number)
228: FROM ozf_claims_all
229: WHERE upper(claim_number) = p_claim_number;
230: --AMITAMKU fix for bug 15874396
231: CURSOR original_claim(p_claim_number in varchar2) IS
232: SELECT claim_number

Line 233: FROM ozf_claims_all

229: WHERE upper(claim_number) = p_claim_number;
230: --AMITAMKU fix for bug 15874396
231: CURSOR original_claim(p_claim_number in varchar2) IS
232: SELECT claim_number
233: FROM ozf_claims_all
234: WHERE split_from_claim_id IS NULL
235: CONNECT BY PRIOR split_from_claim_id = claim_id
236: START WITH claim_id = p_claim_number;
237:

Line 2051: FROM ozf_claims_all

2047: and rownum =1;
2048:
2049: CURSOR csr_customer_for_claim(cv_claim_id IN NUMBER) IS
2050: SELECT cust_account_id
2051: FROM ozf_claims_all
2052: WHERE claim_id = cv_claim_id;
2053:
2054: l_acc_cust_account_id NUMBER;
2055: l_claim_cust_account_id NUMBER;

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

2234: -- check_amount
2235: --
2236: -- PURPOSE
2237: -- This procedure checks whether there is a need to change the
2238: -- amount field in the ozf_claims_all table.
2239: --
2240: -- PARAMETERS
2241: -- p_claim in claim_rec_type,
2242: -- p_mode in varchar2

Line 2269: FROM ozf_claims_all

2265: amount,
2266: amount_adjusted,
2267: amount_settled,
2268: cust_account_id
2269: FROM ozf_claims_all
2270: WHERE claim_id = p_id;
2271:
2272: l_info amount_csr%rowtype;
2273:

Line 2421: FROM ozf_claims_all

2417: l_claim_id NUMBER;
2418:
2419: CURSOR get_claim_id_csr(p_id in number) IS
2420: SELECT count(claim_id)
2421: FROM ozf_claims_all
2422: WHERE claim_id = p_id;
2423:
2424: CURSOR get_claim_id_num_csr(p_num in varchar2) IS
2425: SELECT count(claim_id)

Line 2426: FROM ozf_claims_all

2422: WHERE claim_id = p_id;
2423:
2424: CURSOR get_claim_id_num_csr(p_num in varchar2) IS
2425: SELECT count(claim_id)
2426: FROM ozf_claims_all
2427: WHERE claim_number = p_num;
2428:
2429: CURSOR get_count_csr(p_number in varchar2,
2430: p_claim_id in number) IS

Line 2432: FROM ozf_claims_all

2428:
2429: CURSOR get_count_csr(p_number in varchar2,
2430: p_claim_id in number) IS
2431: SELECT count(claim_id)
2432: FROM ozf_claims_all
2433: WHERE claim_number = p_number
2434: AND claim_id = p_claim_id;
2435:
2436: l_count number:=0;

Line 2617: FROM ozf_claims_all

2613: exchange_rate_type,
2614: exchange_rate,
2615: amount,
2616: cust_account_id
2617: FROM ozf_claims_all
2618: WHERE claim_id = p_id;
2619:
2620: l_deduction_info deduction_info_csr%rowtype;
2621:

Line 2692: SELECT * FROM ozf_claims_all

2688: ,x_return_status OUT NOCOPY varchar2
2689: )
2690: IS
2691: CURSOR c_claim (cv_claim_id NUMBER) IS
2692: SELECT * FROM ozf_claims_all
2693: WHERE CLAIM_ID = cv_claim_id;
2694:
2695: l_claim_rec c_claim%ROWTYPE;
2696:

Line 3731: SELECT ozf_claims_all_s.nextval FROM dual;

3727:
3728: l_auto_assign_flag varchar2(1);
3729:
3730: CURSOR claim_id_csr IS
3731: SELECT ozf_claims_all_s.nextval FROM dual;
3732:
3733: CURSOR trade_profile_csr(p_customer_account_id in number) IS
3734: SELECT vendor_id, vendor_site_id
3735: FROM ozf_cust_trd_prfls

Line 3752: FROM ozf_claims_all

3748: FROM dual; */
3749:
3750: CURSOR claim_number_count_csr(p_claim_number in varchar2) IS
3751: SELECT count(claim_number)
3752: FROM ozf_claims_all
3753: WHERE upper(claim_number) = p_claim_number;
3754: l_temp_claim_number varchar2(30);
3755:
3756: l_count number:=0;

Line 3760: from ozf_claims

3756: l_count number:=0;
3757:
3758: CURSOR claim_id_count_csr(p_id in number) is
3759: select count(*)
3760: from ozf_claims
3761: where claim_id =p_id;
3762:
3763: l_claim_id_count number:=0;
3764:

Line 4658: OZF_claims_PKG.Insert_Row(

4654: ozf_utility_PVT.debug_message('Before Insert : l_claim.offer_id:'||l_claim.offer_id);
4655: END IF;
4656:
4657: BEGIN
4658: OZF_claims_PKG.Insert_Row(
4659: px_CLAIM_ID => l_claim_id,
4660: px_OBJECT_VERSION_NUMBER => l_object_version_number,
4661: p_LAST_UPDATE_DATE => SYSDATE,
4662: p_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),

Line 4995: from ozf_claims_all claim, ozf_claim_types_all_vl type, ozf_reason_codes_all_vl reason,

4991: claim.deduction_attribute1 ClaimDedAttr15,
4992: type.name ClaimType,
4993: reason.name ClaimReason,
4994: claim.org_id
4995: from ozf_claims_all claim, ozf_claim_types_all_vl type, ozf_reason_codes_all_vl reason,
4996: hz_cust_accounts cust, ozf_sys_parameters_all ozfsys
4997: where
4998: type.claim_type_id = claim.claim_type_id AND
4999: reason.reason_code_id = ozfsys.reason_code_id AND

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

5200: -- view_name/table_name ozf_claim_lines_b jtf_tasks_v
5201: -- name VARCHAR2(240) line_number Task_number
5202: --type VARCHAR2(30) LINE TASK
5203: --status VARCHAR2(30) NEW Task_status
5204: --owner VARCHAR2(240) ozf_claims_v.owner_id owner
5205: --deletable_flag VARCHAR2(1) Y
5206:
5207:
5208: ---------------------------------------------------------------------

Line 5230: FROM ozf_claims_v

5226: l_msg_count number;
5227:
5228: CURSOR claim_info_csr (p_id in number) IS
5229: SELECT object_version_number, owner_id, status_code
5230: FROM ozf_claims_v
5231: WHERE claim_id = p_id;
5232: l_object_version_number number;
5233: l_status_code varchar2(30);
5234: l_owner_id number;

Line 5501: FROM ozf_claims_all

5497: l_claim_line_hist_id number;
5498:
5499: CURSOR claim_info_csr (p_id in number) IS
5500: SELECT object_version_number, status_code
5501: FROM ozf_claims_all
5502: WHERE claim_id = p_id;
5503: l_object_version_number number;
5504: l_status_code varchar2(30);
5505:

Line 5535: from ozf_claims_history_all

5531:
5532: -- Fix for 5048675
5533: CURSOR claim_history_id_csr(p_id in number) is
5534: select claim_history_id, object_version_number
5535: from ozf_claims_history_all
5536: where claim_id = p_id;
5537:
5538: CURSOR claim_line_his_id_csr(p_id in number) is
5539: select claim_line_history_id, object_version_number

Line 5615: OZF_claims_history_PVT.Delete_claims_history(

5611: LOOP
5612: FETCH claim_history_id_csr into l_claim_history_id, l_object_version_number;
5613: EXIT When claim_history_id_csr%NOTFOUND;
5614:
5615: OZF_claims_history_PVT.Delete_claims_history(
5616: P_Api_Version_Number => l_api_version
5617: ,P_Init_Msg_List => FND_API.g_false
5618: ,P_Commit => FND_API.g_false
5619: ,p_validation_level => FND_API.g_valid_level_full

Line 5691: OZF_claims_PKG.Delete_Row(p_object_id);

5687: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5688: RAISE FND_API.g_exc_unexpected_error;
5689: END IF;
5690:
5691: OZF_claims_PKG.Delete_Row(p_object_id);
5692: ELSE
5693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5694: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_DEL_CLAIM');
5695: FND_MSG_PUB.add;

Line 5787: FROM ozf_claims_all

5783: l_return_status varchar2(3);
5784:
5785: CURSOR reason_csr(p_id in number) IS
5786: SELECT reason_code_id, task_template_group_id
5787: FROM ozf_claims_all
5788: WHERE claim_id = p_id;
5789:
5790: BEGIN
5791: -- Initialize API return status to sucess

Line 5889: from ozf_claims_all

5885: l_claim_history_id NUMBER := null;
5886: l_status_code varchar2(30);
5887: CURSOR user_status_id_csr(p_id in number) is
5888: select user_status_id
5889: from ozf_claims_all
5890: where claim_id = p_id;
5891:
5892: l_user_status_id number;
5893: BEGIN

Line 5941: OZF_claims_history_PVT.Check_Create_History(

5937: -- If the status_code is not new, then I will to create_claim_history
5938: --Comment out the below line (uday) since we will be creating the history
5939: -- at the time of claim creation also.
5940: --IF l_status_code <> G_INIT_STATUS THEN
5941: OZF_claims_history_PVT.Check_Create_History(
5942: p_claim => p_claim,
5943: p_event => p_event,
5944: x_history_event => l_history_event,
5945: x_history_event_description => l_history_event_description,

Line 5957: OZF_claims_history_PVT.Create_History(

5953: END IF;
5954:
5955: IF (l_needed_to_create = 'Y') THEN
5956: -- CREATE history
5957: OZF_claims_history_PVT.Create_History(
5958: p_claim_id => p_claim.claim_id,
5959: p_history_event => l_history_event,
5960: p_history_event_description => l_history_event_description,
5961: x_claim_history_id => l_claim_history_id,

Line 6101: from ozf_claims_all

6097: where claim_id = p_id;
6098:
6099: CURSOR object_version_number_csr (p_id in number) is
6100: select object_version_number
6101: from ozf_claims_all
6102: where claim_id = p_id;
6103:
6104: CURSOR tasks_csr(p_claim_id in number,
6105: p_completed_flag in varchar2) IS

Line 6121: FROM ozf_claims_history_all

6117: l_uncompleted_tasks_tbl tasks_csr_Tbl_Type;
6118:
6119: CURSOR claim_history_tbl_csr(p_claim_id in number) IS
6120: SELECT claim_history_id, object_version_number
6121: FROM ozf_claims_history_all
6122: WHERE task_source_object_id = p_claim_id
6123: AND task_source_object_type_code = G_CLAIM_TYPE
6124: AND claim_id = p_claim_id;
6125:

Line 6130: l_claim_history_rec OZF_claims_history_PVT.claims_history_Rec_Type;

6126: TYPE CLAIMS_HISTORY_Tbl_Type IS TABLE OF CLAIM_HISTORY_tbl_csr%rowtype
6127: INDEX BY BINARY_INTEGER;
6128: l_claim_history_tbl CLAIMS_HISTORY_Tbl_Type;
6129:
6130: l_claim_history_rec OZF_claims_history_PVT.claims_history_Rec_Type;
6131:
6132:
6133: -- Fix for Bug 8924230
6134: -- Added For Rule Based Settlement

Line 6149: FROM ozf_claims_all

6145: pre_auth_deduction_number,
6146: offer_id,
6147: amount,
6148: payment_status --ninarasi fix for bug 13395562
6149: FROM ozf_claims_all
6150: WHERE claim_id = p_id;
6151:
6152: -- Added for Rule Based Settlement
6153: l_old_offer_id NUMBER;

Line 6190: FROM ozf_claims_all

6186: l_sales_rep_id NUMBER;
6187:
6188: CURSOR user_status_id_csr (p_id in number) IS
6189: SELECT user_status_id
6190: FROM ozf_claims_all
6191: WHERE claim_id = p_id;
6192:
6193: CURSOR status_code_csr (p_id in number) IS
6194: SELECT status_code

Line 6195: FROM ozf_claims_all

6191: WHERE claim_id = p_id;
6192:
6193: CURSOR status_code_csr (p_id in number) IS
6194: SELECT status_code
6195: FROM ozf_claims_all
6196: WHERE claim_id = p_id;
6197:
6198: -- fix for bug 5042046
6199: CURSOR auto_assign_flag_csr IS

Line 6221: FROM ozf_claims_all

6217: l_resource_id number;
6218:
6219: CURSOR tax_amount_csr(p_id in number) IS
6220: SELECT tax_amount
6221: FROM ozf_claims_all
6222: WHERE claim_id = p_id;
6223:
6224: l_tax_amount number;
6225:

Line 6268: FROM ozf_claims_all

6264:
6265: CURSOR csr_user_status_info(p_claim_id in number) is
6266: SELECT open_status_id,
6267: close_status_id
6268: FROM ozf_claims_all
6269: WHERE claim_id = p_claim_id;
6270:
6271: /*
6272: --Bug# 7319828 fixed by ateotia(+)

Line 6286: ozf_claims_all

6282: SELECT
6283: exchange_rate,
6284: exchange_rate_type
6285: FROM
6286: ozf_claims_all
6287: WHERE
6288: claim_id = cv_claim_id;
6289:
6290: l_claim_old_rec csr_claim_old_rec%ROWTYPE;

Line 6301: FROM ozf_claims_all cla,

6297:
6298: CURSOR claim_line_count_csr(p_claim_id in number
6299: ) IS
6300: SELECT count(cln.claim_id)
6301: FROM ozf_claims_all cla,
6302: ozf_claim_lines_all cln
6303: WHERE cla.claim_id = cln.claim_id
6304: AND cla.claim_id = p_claim_id;
6305:

Line 6323: FROM ozf_claims_all

6319: WHERE claim_id = p_id;
6320:
6321: /*CURSOR claim_hrd_invoice_csr(cv_claim_id in number) IS
6322: SELECT source_object_id
6323: FROM ozf_claims_all
6324: WHERE claim_id = cv_claim_id;
6325: */
6326:
6327: CURSOR claim_invoice_csr(cv_claim_id in number) IS

Line 6329: FROM ozf_claim_lines_all cln, ozf_claims_all cla

6325: */
6326:
6327: CURSOR claim_invoice_csr(cv_claim_id in number) IS
6328: SELECT count(*)
6329: FROM ozf_claim_lines_all cln, ozf_claims_all cla
6330: WHERE cla.claim_id = cln.claim_id
6331: AND cla.source_object_id = cln.source_object_id
6332: AND cla.claim_id = cv_claim_id
6333: GROUP BY cln.source_object_id;

Line 7402: update ozf_claims_all set status_code = 'OPEN'

7398:
7399: -- Added For ER#9453443
7400: IF(l_claim.offer_id IS NOT NULL AND G_INIT_STATUS = 'NEW') THEN
7401:
7402: update ozf_claims_all set status_code = 'OPEN'
7403: where claim_id = l_claim.claim_id;
7404:
7405: END IF;
7406:

Line 7649: OZF_claims_PKG.Update_Row(

7645: END IF;
7646: -- End Bug: 2732290 -----------------------------------------------------------
7647:
7648: BEGIN
7649: OZF_claims_PKG.Update_Row(
7650: p_CLAIM_ID => l_claim.CLAIM_ID,
7651: p_OBJECT_VERSION_NUMBER => l_object_version_number,
7652: p_LAST_UPDATE_DATE => SYSDATE,
7653: p_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),

Line 7814: UPDATE ozf_claims_all

7810: END;
7811: l_rec_num := 1;
7812:
7813: IF l_user_sel_status_code_id IS NOT NULL THEN
7814: UPDATE ozf_claims_all
7815: SET close_status_id = l_user_sel_status_code_id
7816: WHERE claim_id = l_claim.claim_id;
7817: END IF;
7818:

Line 7849: UPDATE ozf_claims_all

7845: CLOSE status_code_csr;
7846:
7847: -- Update the claim with the user selected Close status id
7848: IF l_curr_status_code = 'CLOSED' THEN
7849: UPDATE ozf_claims_all
7850: SET user_status_id = close_status_id
7851: WHERE claim_id = l_claim.claim_id
7852: AND close_status_id IS NOT NULL;
7853: END IF;

Line 7969: update ozf_claims_history_all

7965: END IF;
7966: END IF;
7967: /*
7968: -- Temp solution for update the claim history
7969: update ozf_claims_history_all
7970: set task_source_object_id = l_claim_history_id,
7971: task_source_object_type_code = G_CLAIM_HISTORY_TYPE
7972: where task_source_object_id = l_claim.claim_id
7973: and task_source_object_id = G_OBJECT_TYPE

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

7985: END LOOP;
7986: CLOSE claim_history_tbl_csr;
7987:
7988: For i in 1..l_claim_history_tbl.count LOOP
7989: -- l_claim_history_rec := OZF_claims_history_PVT.claims_history_rec_type;
7990: l_claim_history_rec.object_version_number := l_claim_history_tbl(i).object_version_number;
7991: l_claim_history_rec.claim_history_id := l_claim_history_tbl(i).claim_history_id;
7992: l_claim_history_rec.task_source_object_id := l_claim_history_id;
7993: l_claim_history_rec.task_source_object_type_code := G_CLAIM_HISTORY_TYPE;

Line 7995: OZF_claims_history_PVT.Update_claims_history(

7991: l_claim_history_rec.claim_history_id := l_claim_history_tbl(i).claim_history_id;
7992: l_claim_history_rec.task_source_object_id := l_claim_history_id;
7993: l_claim_history_rec.task_source_object_type_code := G_CLAIM_HISTORY_TYPE;
7994:
7995: OZF_claims_history_PVT.Update_claims_history(
7996: P_Api_Version_Number => 1.0,
7997: P_Init_Msg_List => FND_API.G_FALSE,
7998: P_Commit => FND_API.G_FALSE,
7999: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 8155: from ozf_claims_all claim, hz_cust_accounts cust

8151: claim.deduction_attribute1 ClaimDedAttr12,
8152: claim.deduction_attribute1 ClaimDedAttr13,
8153: claim.deduction_attribute1 ClaimDedAttr14,
8154: claim.deduction_attribute1 ClaimDedAttr15
8155: from ozf_claims_all claim, hz_cust_accounts cust
8156: Where
8157: claim.cust_account_id = cust.cust_account_id AND
8158: claim.claim_id = ' || l_claim.claim_id);
8159:

Line 8202: from ozf_claims_all claim, hz_cust_accounts cust

8198: claim.deduction_attribute1 ClaimDedAttr13,
8199: claim.deduction_attribute1 ClaimDedAttr14,
8200: claim.deduction_attribute1 ClaimDedAttr15,
8201: claim.org_id
8202: from ozf_claims_all claim, hz_cust_accounts cust
8203: Where
8204: claim.cust_account_id = cust.cust_account_id AND
8205: claim.claim_id = ' || l_claim.claim_id);
8206: END IF;

Line 8266: from ozf_claims_all claim, hz_cust_accounts cust

8262: claim.deduction_attribute1 ClaimDedAttr13,
8263: claim.deduction_attribute1 ClaimDedAttr14,
8264: claim.deduction_attribute1 ClaimDedAttr15,
8265: claim.org_id
8266: from ozf_claims_all claim, hz_cust_accounts cust
8267: Where
8268: claim.cust_account_id = cust.cust_account_id AND
8269: claim.claim_id = ' || l_claim.claim_id);
8270: