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

Line 248: FROM ozf_claims

244: , status_code
245: , receipt_number
246: , claim_class
247: , split_from_claim_id
248: FROM ozf_claims
249: WHERE split_from_claim_id IS NULL
250: AND root_claim_id = p_claim_id
251: ORDER BY claim_id desc;
252:

Line 255: FROM ozf_claims

251: ORDER BY claim_id desc;
252:
253: CURSOR child_claim_csr(p_claim_id in number) IS
254: SELECT SUM(amount)
255: FROM ozf_claims
256: WHERE split_from_claim_id = p_claim_id;
257:
258: l_change_in_amount NUMBER;
259: l_tot_child_amt NUMBER;

Line 520: FROM ozf_claims c

516: CURSOR csr_get_claim_info(cv_claim_id IN NUMBER) IS
517: SELECT c.claim_number
518: , c.reason_code_id
519: , r.name
520: FROM ozf_claims c
521: , ozf_reason_codes_vl r
522: WHERE c.claim_id = cv_claim_id
523: AND c.reason_code_id = r.reason_code_id;
524:

Line 983: FROM ozf_claims

979: , receipt_number
980: , claim_class
981: , appr_wf_item_key
982: , split_from_claim_id
983: FROM ozf_claims
984: WHERE root_claim_id = p_claim_id
985: ORDER BY claim_id desc;
986:
987: l_is_overpayment BOOLEAN := FALSE;

Line 1229: FROM ozf_claims

1225:
1226: -- get Count for given claim_id
1227: CURSOR get_claim_count_csr (p_claim_id in number) IS
1228: SELECT count(claim_id)
1229: FROM ozf_claims
1230: WHERE root_claim_id = p_claim_id;
1231:
1232: -- get existing claim details.
1233: CURSOR get_claim_detail_csr (p_claim_id in number) IS

Line 1239: FROM ozf_claims

1235: , amount
1236: , receipt_number
1237: , claim_class
1238: , source_object_id
1239: FROM ozf_claims
1240: WHERE claim_id = p_claim_id;
1241:
1242: -- get existing claim details.
1243: CURSOR split_claim_csr(p_claim_id in number) IS

Line 1253: FROM ozf_claims

1249: , amount_remaining
1250: , amount_settled
1251: , receipt_number
1252: , status_code
1253: FROM ozf_claims
1254: WHERE root_claim_id = p_claim_id
1255: AND status_code <> 'CLOSED'
1256: ORDER BY claim_id;
1257:

Line 1272: FROM ozf_claims

1268: , status_code
1269: , receipt_number
1270: , claim_class
1271: , split_from_claim_id
1272: FROM ozf_claims
1273: WHERE split_from_claim_id IS NULL
1274: AND root_claim_id = p_claim_id
1275: ORDER BY claim_id desc;
1276:

Line 1279: FROM ozf_claims

1275: ORDER BY claim_id desc;
1276:
1277: CURSOR child_claim_csr(p_claim_id in number) IS
1278: SELECT SUM(amount)
1279: FROM ozf_claims
1280: WHERE split_from_claim_id = p_claim_id;
1281:
1282: l_change_in_amount NUMBER;
1283: l_tot_child_amt NUMBER;

Line 1907: FROM ozf_claims_all

1903:
1904: -- get Count for given claim_id
1905: CURSOR get_claim_count_csr (p_claim_id in number) IS
1906: SELECT count(*)
1907: FROM ozf_claims_all
1908: WHERE root_claim_id = p_claim_id;
1909:
1910: -- get existing claim details.
1911: CURSOR get_claim_detail_csr (p_claim_id in number) IS

Line 1915: FROM ozf_claims_all

1911: CURSOR get_claim_detail_csr (p_claim_id in number) IS
1912: SELECT status_code,amount,receipt_number,claim_class,
1913: amount_remaining+amount_settled amount_remaining,
1914: source_object_id
1915: FROM ozf_claims_all
1916: WHERE claim_id = p_claim_id;
1917:
1918: -- Added for Bug4872736
1919: CURSOR get_split_claim_detail_csr (p_claim_id in number) IS

Line 1923: FROM ozf_claims_all

1919: CURSOR get_split_claim_detail_csr (p_claim_id in number) IS
1920: SELECT claim_class,
1921: sum(amount_remaining+amount_settled) amount_remaining,
1922: source_object_id
1923: FROM ozf_claims_all
1924: WHERE root_claim_id = p_claim_id
1925: GROUP BY claim_class, source_object_id;
1926:
1927: -- get split claim details.

Line 1939: FROM ozf_claims_all

1935: amount,
1936: amount_adjusted,
1937: amount_remaining,
1938: amount_settled
1939: FROM ozf_claims_all
1940: WHERE root_claim_id = p_claim_id
1941: ORDER BY claim_id;
1942:
1943: -- get Claim_Class for claim_id

Line 1946: FROM ozf_claims_all

1942:
1943: -- get Claim_Class for claim_id
1944: CURSOR get_claim_class_csr(p_claim_id IN NUMBER) IS
1945: SELECT claim_class,reason_code_id,object_version_number,claim_type_id
1946: FROM ozf_claims_all
1947: WHERE claim_id = p_claim_id;
1948:
1949: -- get Newly created split claim_id and claim_number
1950: CURSOR get_split_claim_ids_csr(p_claim_id IN NUMBER) IS

Line 1952: FROM ozf_claims_all

1948:
1949: -- get Newly created split claim_id and claim_number
1950: CURSOR get_split_claim_ids_csr(p_claim_id IN NUMBER) IS
1951: SELECT claim_id,claim_number
1952: FROM ozf_claims_all
1953: WHERE root_claim_id = p_claim_id
1954: AND claim_id = (Select max(claim_id)
1955: from ozf_claims_all
1956: where root_claim_id = p_claim_id)

Line 1955: from ozf_claims_all

1951: SELECT claim_id,claim_number
1952: FROM ozf_claims_all
1953: WHERE root_claim_id = p_claim_id
1954: AND claim_id = (Select max(claim_id)
1955: from ozf_claims_all
1956: where root_claim_id = p_claim_id)
1957: AND trunc(creation_date) = trunc(sysdate);
1958:
1959: -- get Amount Due on Invoice

Line 1962: FROM ar_payment_schedules a, ozf_claims_all b

1958:
1959: -- get Amount Due on Invoice
1960: CURSOR get_invoice_amount_due_csr (p_claim_id in NUMBER) IS
1961: SELECT amount_due_original
1962: FROM ar_payment_schedules a, ozf_claims_all b
1963: WHERE customer_trx_id = b.source_object_id
1964: AND b.claim_id = p_claim_id;
1965:
1966: -- [BEGIN OF BUG 3775972 FIXING]

Line 2659: FROM ozf_claims

2655: CURSOR csr_claim_identifier(cv_source_object_id IN NUMBER) IS
2656: -- [BEGIN OF BUG 4130258 FIXING]
2657: -- SELECT claim_id
2658: SELECT root_claim_id
2659: FROM ozf_claims
2660: WHERE source_object_id = cv_source_object_id;
2661: -- ORDER BY claim_id DESC;
2662: -- [END OF BUG 4130258 FIXING]
2663:

Line 2667: FROM ozf_claims

2663:
2664: CURSOR csr_claim_object_version(cv_claim_id IN NUMBER) IS
2665: SELECT claim_number
2666: , object_version_number
2667: FROM ozf_claims
2668: WHERE claim_id = cv_claim_id;
2669:
2670: CURSOR csr_ar_receipt(cv_receipt_id IN NUMBER) IS
2671: SELECT receipt_number

Line 2681: FROM ozf_claims c

2677: , c.claim_number
2678: , c.object_version_number
2679: , c.reason_code_id
2680: , r.name
2681: FROM ozf_claims c
2682: , ozf_reason_codes_vl r
2683: WHERE c.claim_id = cv_claim_id
2684: AND c.reason_code_id = r.reason_code_id;
2685:

Line 2695: FROM ozf_claims

2691: claim_type_id ,
2692: reason_code_id ,
2693: currency_code ,
2694: cust_account_id
2695: FROM ozf_claims
2696: WHERE claim_id = cv_claim_id;
2697:
2698: l_object_version_number NUMBER;
2699: l_pvt_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;

Line 2720: FROM ozf_claims_all

2716: SELECT object_version_number,
2717: reason_code_id,
2718: claim_id,
2719: claim_number
2720: FROM ozf_claims_all
2721: WHERE claim_id = p_id;
2722:
2723: -- get claim_reason_name
2724: CURSOR claim_name_csr(p_reason_code_id in number) IS

Line 2732: FROM ozf_claims_all

2728:
2729: -- get object_version_number
2730: CURSOR claim_object_version_csr(p_id in number) IS
2731: SELECT object_version_number
2732: FROM ozf_claims_all
2733: WHERE claim_id = p_id;
2734:
2735: -- get minimum required data
2736: CURSOR claim_min_req_data_csr(p_id in number) IS

Line 2738: FROM ozf_claims_all

2734:
2735: -- get minimum required data
2736: CURSOR claim_min_req_data_csr(p_id in number) IS
2737: SELECT claim_number
2738: FROM ozf_claims_all
2739: WHERE claim_id = p_id;
2740:
2741: -- get claim_id, claim_number incase it is not passed by AR.
2742: CURSOR get_claim_identifier_csr(p_source_object_id in number) IS

Line 2744: FROM ozf_claims_all

2740:
2741: -- get claim_id, claim_number incase it is not passed by AR.
2742: CURSOR get_claim_identifier_csr(p_source_object_id in number) IS
2743: SELECT root_claim_id,claim_number
2744: FROM ozf_claims_all
2745: WHERE source_object_id = p_source_object_id
2746: AND root_claim_id = claim_id;
2747: --AND status_code <> 'CLOSED';
2748:

Line 3114: 'FROM ozf_claims '||

3110:
3111: BEGIN
3112:
3113: l_sql_stmt := 'SELECT root_claim_id, status_code '||
3114: 'FROM ozf_claims '||
3115: 'WHERE claim_id = :1 ';
3116:
3117: EXECUTE IMMEDIATE l_sql_stmt
3118: INTO l_root_claim_id

Line 3134: 'FROM ozf_claims '||

3130: -- for automated solution
3131: IF l_claim_mode = 'A' THEN
3132:
3133: l_sql_stmt := 'SELECT status_code, amount_remaining '||
3134: 'FROM ozf_claims '||
3135: 'WHERE root_claim_id = :1 ';
3136:
3137: OPEN split_claims_csr FOR l_sql_stmt USING p_claim_id;
3138: LOOP

Line 3190: 'FROM ozf_claims '||

3186:
3187: BEGIN
3188: IF p_customer_trx_id IS NOT NULL THEN
3189: l_sql_stmt := 'SELECT COUNT(claim_id) '||
3190: 'FROM ozf_claims '||
3191: 'WHERE source_object_id = :1 '||
3192: 'AND status_code <> ''CLOSED'' ';
3193:
3194: EXECUTE IMMEDIATE l_sql_stmt

Line 3200: 'FROM ozf_claims '||

3196: USING p_customer_trx_id;
3197:
3198: ELSIF p_customer_trx_id IS NULL AND p_receipt_id IS NOT NULL THEN
3199: l_sql_stmt := 'SELECT COUNT(claim_id) '||
3200: 'FROM ozf_claims '||
3201: 'WHERE receipt_id = :1 '||
3202: 'AND status_code <> ''CLOSED'' ';
3203:
3204: EXECUTE IMMEDIATE l_sql_stmt

Line 3246: SELECT claim_id, claim_number, customer_ref_number FROM ozf_claims

3242: )
3243: IS
3244:
3245: CURSOR csr_get_claim_dtls (cv_customer_trx_id IN NUMBER) IS
3246: SELECT claim_id, claim_number, customer_ref_number FROM ozf_claims
3247: WHERE source_object_id = cv_customer_trx_id
3248: AND claim_id = root_claim_id
3249: AND root_claim_id IS NOT NULL
3250: AND cust_account_id = (SELECT bill_to_customer_id from ra_customer_trx_all

Line 3256: 'FROM ozf_claims '||

3252:
3253: BEGIN
3254: /*
3255: l_sql_stmt := 'SELECT claim_id, claim_number, customer_ref_number '||
3256: 'FROM ozf_claims '||
3257: 'WHERE source_object_id = :1 '||
3258: 'AND claim_id = root_claim_id ';
3259:
3260: EXECUTE IMMEDIATE l_sql_stmt