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 1226: FROM ozf_claims

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

Line 1236: FROM ozf_claims

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

Line 1250: FROM ozf_claims

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

Line 1269: FROM ozf_claims

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

Line 1276: FROM ozf_claims

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

Line 1891: FROM ozf_claims_all

1887:
1888: -- get Count for given claim_id
1889: CURSOR get_claim_count_csr (p_claim_id in number) IS
1890: SELECT count(*)
1891: FROM ozf_claims_all
1892: WHERE root_claim_id = p_claim_id;
1893:
1894: -- get existing claim details.
1895: CURSOR get_claim_detail_csr (p_claim_id in number) IS

Line 1899: FROM ozf_claims_all

1895: CURSOR get_claim_detail_csr (p_claim_id in number) IS
1896: SELECT status_code,amount,receipt_number,claim_class,
1897: amount_remaining+amount_settled amount_remaining,
1898: source_object_id
1899: FROM ozf_claims_all
1900: WHERE claim_id = p_claim_id;
1901:
1902: -- Added for Bug4872736
1903: CURSOR get_split_claim_detail_csr (p_claim_id in number) IS

Line 1907: FROM ozf_claims_all

1903: CURSOR get_split_claim_detail_csr (p_claim_id in number) IS
1904: SELECT claim_class,
1905: sum(amount_remaining+amount_settled) amount_remaining,
1906: source_object_id
1907: FROM ozf_claims_all
1908: WHERE root_claim_id = p_claim_id
1909: GROUP BY claim_class, source_object_id;
1910:
1911: -- get split claim details.

Line 1923: FROM ozf_claims_all

1919: amount,
1920: amount_adjusted,
1921: amount_remaining,
1922: amount_settled
1923: FROM ozf_claims_all
1924: WHERE root_claim_id = p_claim_id
1925: ORDER BY claim_id;
1926:
1927: -- get Claim_Class for claim_id

Line 1930: FROM ozf_claims_all

1926:
1927: -- get Claim_Class for claim_id
1928: CURSOR get_claim_class_csr(p_claim_id IN NUMBER) IS
1929: SELECT claim_class,reason_code_id,object_version_number,claim_type_id
1930: FROM ozf_claims_all
1931: WHERE claim_id = p_claim_id;
1932:
1933: -- get Newly created split claim_id and claim_number
1934: CURSOR get_split_claim_ids_csr(p_claim_id IN NUMBER) IS

Line 1936: FROM ozf_claims_all

1932:
1933: -- get Newly created split claim_id and claim_number
1934: CURSOR get_split_claim_ids_csr(p_claim_id IN NUMBER) IS
1935: SELECT claim_id,claim_number
1936: FROM ozf_claims_all
1937: WHERE root_claim_id = p_claim_id
1938: AND claim_id = (Select max(claim_id)
1939: from ozf_claims_all
1940: where root_claim_id = p_claim_id)

Line 1939: from ozf_claims_all

1935: SELECT claim_id,claim_number
1936: FROM ozf_claims_all
1937: WHERE root_claim_id = p_claim_id
1938: AND claim_id = (Select max(claim_id)
1939: from ozf_claims_all
1940: where root_claim_id = p_claim_id)
1941: AND trunc(creation_date) = trunc(sysdate);
1942:
1943: -- get Amount Due on Invoice

Line 1946: FROM ar_payment_schedules a, ozf_claims_all b

1942:
1943: -- get Amount Due on Invoice
1944: CURSOR get_invoice_amount_due_csr (p_claim_id in NUMBER) IS
1945: SELECT amount_due_original
1946: FROM ar_payment_schedules a, ozf_claims_all b
1947: WHERE customer_trx_id = b.source_object_id
1948: AND b.claim_id = p_claim_id;
1949:
1950: -- [BEGIN OF BUG 3775972 FIXING]

Line 2635: FROM ozf_claims

2631: CURSOR csr_claim_identifier(cv_source_object_id IN NUMBER) IS
2632: -- [BEGIN OF BUG 4130258 FIXING]
2633: -- SELECT claim_id
2634: SELECT root_claim_id
2635: FROM ozf_claims
2636: WHERE source_object_id = cv_source_object_id;
2637: -- ORDER BY claim_id DESC;
2638: -- [END OF BUG 4130258 FIXING]
2639:

Line 2643: FROM ozf_claims

2639:
2640: CURSOR csr_claim_object_version(cv_claim_id IN NUMBER) IS
2641: SELECT claim_number
2642: , object_version_number
2643: FROM ozf_claims
2644: WHERE claim_id = cv_claim_id;
2645:
2646: CURSOR csr_ar_receipt(cv_receipt_id IN NUMBER) IS
2647: SELECT receipt_number

Line 2657: FROM ozf_claims c

2653: , c.claim_number
2654: , c.object_version_number
2655: , c.reason_code_id
2656: , r.name
2657: FROM ozf_claims c
2658: , ozf_reason_codes_vl r
2659: WHERE c.claim_id = cv_claim_id
2660: AND c.reason_code_id = r.reason_code_id;
2661:

Line 2671: FROM ozf_claims

2667: claim_type_id ,
2668: reason_code_id ,
2669: currency_code ,
2670: cust_account_id
2671: FROM ozf_claims
2672: WHERE claim_id = cv_claim_id;
2673:
2674: l_object_version_number NUMBER;
2675: l_pvt_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;

Line 2696: FROM ozf_claims_all

2692: SELECT object_version_number,
2693: reason_code_id,
2694: claim_id,
2695: claim_number
2696: FROM ozf_claims_all
2697: WHERE claim_id = p_id;
2698:
2699: -- get claim_reason_name
2700: CURSOR claim_name_csr(p_reason_code_id in number) IS

Line 2708: FROM ozf_claims_all

2704:
2705: -- get object_version_number
2706: CURSOR claim_object_version_csr(p_id in number) IS
2707: SELECT object_version_number
2708: FROM ozf_claims_all
2709: WHERE claim_id = p_id;
2710:
2711: -- get minimum required data
2712: CURSOR claim_min_req_data_csr(p_id in number) IS

Line 2714: FROM ozf_claims_all

2710:
2711: -- get minimum required data
2712: CURSOR claim_min_req_data_csr(p_id in number) IS
2713: SELECT claim_number
2714: FROM ozf_claims_all
2715: WHERE claim_id = p_id;
2716:
2717: -- get claim_id, claim_number incase it is not passed by AR.
2718: CURSOR get_claim_identifier_csr(p_source_object_id in number) IS

Line 2720: FROM ozf_claims_all

2716:
2717: -- get claim_id, claim_number incase it is not passed by AR.
2718: CURSOR get_claim_identifier_csr(p_source_object_id in number) IS
2719: SELECT root_claim_id,claim_number
2720: FROM ozf_claims_all
2721: WHERE source_object_id = p_source_object_id
2722: AND root_claim_id = claim_id;
2723: --AND status_code <> 'CLOSED';
2724:

Line 3065: 'FROM ozf_claims '||

3061:
3062: BEGIN
3063:
3064: l_sql_stmt := 'SELECT root_claim_id, status_code '||
3065: 'FROM ozf_claims '||
3066: 'WHERE claim_id = :1 ';
3067:
3068: EXECUTE IMMEDIATE l_sql_stmt
3069: INTO l_root_claim_id

Line 3085: 'FROM ozf_claims '||

3081: -- for automated solution
3082: IF l_claim_mode = 'A' THEN
3083:
3084: l_sql_stmt := 'SELECT status_code, amount_remaining '||
3085: 'FROM ozf_claims '||
3086: 'WHERE root_claim_id = :1 ';
3087:
3088: OPEN split_claims_csr FOR l_sql_stmt USING p_claim_id;
3089: LOOP

Line 3141: 'FROM ozf_claims '||

3137:
3138: BEGIN
3139: IF p_customer_trx_id IS NOT NULL THEN
3140: l_sql_stmt := 'SELECT COUNT(claim_id) '||
3141: 'FROM ozf_claims '||
3142: 'WHERE source_object_id = :1 '||
3143: 'AND status_code <> ''CLOSED'' ';
3144:
3145: EXECUTE IMMEDIATE l_sql_stmt

Line 3151: 'FROM ozf_claims '||

3147: USING p_customer_trx_id;
3148:
3149: ELSIF p_customer_trx_id IS NULL AND p_receipt_id IS NOT NULL THEN
3150: l_sql_stmt := 'SELECT COUNT(claim_id) '||
3151: 'FROM ozf_claims '||
3152: 'WHERE receipt_id = :1 '||
3153: 'AND status_code <> ''CLOSED'' ';
3154:
3155: EXECUTE IMMEDIATE l_sql_stmt

Line 3197: SELECT claim_id, claim_number, customer_ref_number FROM ozf_claims

3193: )
3194: IS
3195:
3196: CURSOR csr_get_claim_dtls (cv_customer_trx_id IN NUMBER) IS
3197: SELECT claim_id, claim_number, customer_ref_number FROM ozf_claims
3198: WHERE source_object_id = cv_customer_trx_id
3199: AND claim_id = root_claim_id
3200: AND root_claim_id IS NOT NULL
3201: AND cust_account_id = (SELECT bill_to_customer_id from ra_customer_trx_all

Line 3207: 'FROM ozf_claims '||

3203:
3204: BEGIN
3205: /*
3206: l_sql_stmt := 'SELECT claim_id, claim_number, customer_ref_number '||
3207: 'FROM ozf_claims '||
3208: 'WHERE source_object_id = :1 '||
3209: 'AND claim_id = root_claim_id ';
3210:
3211: EXECUTE IMMEDIATE l_sql_stmt