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_ALL

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 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 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 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 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 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;