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

Line 76: FROM ozf_claims_all

72: l_api_version_number CONSTANT NUMBER := 1.0;
73:
74: CURSOR csr_claim_class(cv_claim_id IN NUMBER) IS
75: SELECT claim_class
76: FROM ozf_claims_all
77: WHERE claim_id = cv_claim_id;
78:
79: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
80: SELECT name

Line 389: FROM ozf_claims

385:
386: -- Find out claim object version number
387: CURSOR csr_claim_obj_ver_num(cv_claim_id IN NUMBER) IS
388: SELECT object_version_number
389: FROM ozf_claims
390: WHERE claim_id = cv_claim_id;
391:
392: -- Find out claim object version number
393: CURSOR csr_claim_credit_memo(cv_claim_id IN NUMBER) IS

Line 401: , ozf_claims oc

397: , sysdate
398: , (oc.amount_settled * -1)
399: , pay.status
400: FROM ar_payment_schedules pay
401: , ozf_claims oc
402: WHERE pay.customer_trx_id = oc.payment_reference_id
403: AND oc.claim_id = cv_claim_id;
404:
405: CURSOR csr_settle_doc_obj_ver(cv_settlement_doc_id IN NUMBER) IS

Line 414: FROM ozf_claims

410: --R12.1 Enhancement
411: CURSOR csr_on_acct_only(cv_claim_id IN NUMBER) IS
412: SELECT payment_method,
413: amount
414: FROM ozf_claims
415: WHERE claim_id = cv_claim_id;
416:
417: -- Added for Bug 14126231
418: CURSOR csr_claim_class(cv_claim_id IN NUMBER) IS

Line 420: FROM ozf_claims_all

416:
417: -- Added for Bug 14126231
418: CURSOR csr_claim_class(cv_claim_id IN NUMBER) IS
419: SELECT claim_class
420: FROM ozf_claims_all
421: WHERE claim_id = cv_claim_id;
422:
423: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
424: SELECT name

Line 1059: UPDATE ozf_claims_all

1055: OZF_Utility_PVT.debug_message('claim.tax_amount = '||p_claim_rec.tax_amount);
1056: END IF;
1057:
1058: BEGIN
1059: UPDATE ozf_claims_all
1060: SET tax_amount = NVL(p_claim_rec.tax_amount,0)
1061: , acctd_tax_amount = NVL(l_acctd_tax_amount,0)
1062: , amount_settled = p_claim_rec.amount_settled
1063: , acctd_amount_settled = l_acctd_amount_settled

Line 1219: UPDATE ozf_claims

1215: -- Note: payment_reference_number is not set to null since this information is used to build
1216: -- the next invoice number for check settlement. When the claim status is Open, the payment
1217: -- information is not displayed.
1218:
1219: UPDATE ozf_claims
1220: SET status_code = 'OPEN',
1221: user_status_id = ozf_utility_pvt.get_default_user_status( 'OZF_CLAIM_STATUS', 'OPEN'),
1222: amount_remaining = NVL(amount_remaining,0) + amount_settled,
1223: acctd_amount_remaining = NVL(acctd_amount_remaining,0)+acctd_amount_settled,

Line 1435: FROM ozf_claims

1431: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1432:
1433: CURSOR csr_get_claim_details(cv_claim_id IN NUMBER) IS
1434: SELECT payment_method,payment_reference_number
1435: FROM ozf_claims
1436: WHERE claim_id = cv_claim_id;
1437:
1438: CURSOR csr_inv_settlement( cv_claim_id IN VARCHAR2)IS
1439: SELECT --pay.invoice_payment_id --"settlement_id"

Line 1453: , ozf_claims_all oc

1449: , inv.invoice_amount
1450: FROM ap_invoice_payments_all pay
1451: , ap_checks_all chk
1452: , ap_invoices_all inv
1453: , ozf_claims_all oc
1454: WHERE pay.check_id = chk.check_id
1455: AND inv.invoice_id = pay.invoice_id
1456: AND oc.claim_id = TO_NUMBER(inv.reference_key1) --//Fix for bug 13557215
1457: AND oc.claim_id = cv_claim_id

Line 1478: , ozf_claims_all oc

1474: , 'AP_DEBIT' --"payment_method"
1475: , NULL
1476: , inv.invoice_amount
1477: FROM ap_invoices_all inv
1478: , ozf_claims_all oc
1479: WHERE oc.claim_id = cv_claim_id
1480: --AND oc.payment_reference_number = inv.invoice_num --//Fix for Bug 13976621
1481: AND oc.claim_id = TO_NUMBER(inv.reference_key1) --//Fix for bug 13557215
1482: AND oc.vendor_id = inv.vendor_id

Line 1489: FROM ozf_claims_all oc

1485:
1486:
1487: CURSOR csr_get_inv_number(cv_claim_id IN NUMBER) IS
1488: SELECT inv.invoice_num
1489: FROM ozf_claims_all oc
1490: ,ap_invoices_all inv
1491: WHERE oc.claim_id = TO_NUMBER(inv.reference_key1)
1492: --AND oc.payment_reference_number = inv.invoice_num --//Fix for Bug 13976621
1493: AND oc.claim_id = cv_claim_id;

Line 1520: UPDATE ozf_claims_all

1516: FETCH csr_get_inv_number INTO l_invoice_number;
1517: CLOSE csr_get_inv_number;
1518:
1519: IF l_pay_ref_number <> l_invoice_number THEN
1520: UPDATE ozf_claims_all
1521: SET payment_reference_number = l_invoice_number
1522: WHERE claim_id = p_claim_id;
1523: END IF;
1524: --//End

Line 1656: FROM ozf_claims_all

1652:
1653: -- Added for Bug 14126231
1654: CURSOR csr_claim_class(cv_claim_id IN NUMBER) IS
1655: SELECT claim_class, payment_method
1656: FROM ozf_claims_all
1657: WHERE claim_id = cv_claim_id;
1658:
1659: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
1660: SELECT name

Line 1914: FROM ozf_claims_all

1910: l_parameter_list_update wf_parameter_list_t;
1911:
1912: CURSOR csr_claim_payment_stat(p_claim_id IN NUMBER) IS
1913: SELECT payment_status
1914: FROM ozf_claims_all
1915: where claim_id= p_claim_id;
1916:
1917: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1918: SELECT user_status_id

Line 1959: FROM ozf_claims_all oc,

1955: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1956:
1957: CURSOR csr_custom_status_id(p_claim_id IN NUMBER, p_status_code IN VARCHAR2) IS
1958: SELECT close_status_id
1959: FROM ozf_claims_all oc,
1960: ams_user_statuses_vl us
1961: WHERE oc.claim_id = p_claim_id
1962: AND oc.close_status_id = us.user_status_id
1963: AND us.system_status_type = 'OZF_CLAIM_STATUS'

Line 1973: FROM ozf_claims_all

1969: --R12.1 Enhancement : Price Protection
1970: CURSOR csr_claim_rec(p_claim_id IN NUMBER) IS
1971: SELECT source_object_class,
1972: created_by
1973: FROM ozf_claims_all
1974: WHERE claim_id = p_claim_id;
1975:
1976: CURSOR csr_claim_lines(cv_claim_id IN NUMBER) IS
1977: SELECT ln.claim_line_id

Line 2076: FROM ozf_claims_all

2072: ,cust_account_id
2073: ,claim_class
2074: ,payment_method
2075: ,split_from_claim_id
2076: FROM ozf_claims_all
2077: WHERE claim_id=cv_claim_id;
2078:
2079: BEGIN
2080: --------------------- initialize -----------------------

Line 2127: UPDATE ozf_claims_all

2123: FETCH csr_claim_payment_stat INTO l_payment_status;
2124: CLOSE csr_claim_payment_stat;
2125:
2126: BEGIN
2127: UPDATE ozf_claims_all
2128: SET payment_status = p_payment_status
2129: , status_code = p_status_code
2130: , user_status_id = l_claim_rec.user_status_id
2131: , last_update_date = SYSDATE -- hbandi added this line of code for resolving the Bug # 9793391 .

Line 2255: OZF_claims_history_PVT.Check_Create_History(

2251:
2252: --//Bugfix : 8428220 - Claim History Creation Check
2253: IF (p_status_code ='CLOSED' AND l_payment_status ='INTERFACED') THEN
2254:
2255: OZF_claims_history_PVT.Check_Create_History(
2256: p_claim => l_claim_rec,
2257: p_event => 'UPDATE',
2258: x_history_event => l_history_event,
2259: x_history_event_description => l_history_event_description,

Line 2272: OZF_claims_history_PVT.Create_History(

2268: END IF;
2269:
2270: IF (l_needed_to_create = 'Y') THEN
2271: -- CREATE history
2272: OZF_claims_history_PVT.Create_History(
2273: p_claim_id => p_claim_id,
2274: p_history_event => l_history_event,
2275: p_history_event_description => l_history_event_description,
2276: x_claim_history_id => l_claim_history_id,

Line 2374: from ozf_claims_all claim, hz_cust_accounts cust

2370: claim.deduction_attribute1 ClaimDedAttr13,
2371: claim.deduction_attribute1 ClaimDedAttr14,
2372: claim.deduction_attribute1 ClaimDedAttr15,
2373: claim.org_id
2374: from ozf_claims_all claim, hz_cust_accounts cust
2375: Where
2376: claim.cust_account_id = cust.cust_account_id AND
2377: claim.claim_id = ' || l_claim_rec.claim_id);
2378:

Line 3243: FND_DSQL.add_text('FROM ozf_claims ');

3239:
3240: FND_DSQL.init;
3241:
3242: FND_DSQL.add_text('SELECT claim_id, claim_number, object_version_number, claim_class, amount_remaining, amount_settled, source_object_id, payment_method ');
3243: FND_DSQL.add_text('FROM ozf_claims ');
3244: FND_DSQL.add_text('WHERE status_code = ''PENDING_CLOSE'' ');
3245:
3246: i := p_payment_method_tbl.FIRST;
3247: IF i IS NOT NULL THEN

Line 3332: FROM ozf_claims_all

3328: AND payment_status = 'PAID';
3329:
3330: CURSOR csr_claim_lock(cv_claim_id IN NUMBER) IS
3331: SELECT claim_id
3332: FROM ozf_claims_all
3333: WHERE claim_id = cv_claim_id
3334: FOR UPDATE NOWAIT;
3335:
3336: l_claim_lock_rec csr_claim_lock%ROWTYPE;

Line 3376: ozf_claims_all

3372:
3373: CURSOR csr_rma_status(cv_claim_id IN NUMBER) IS
3374: SELECT flow_status_code
3375: FROM oe_order_headers_all,
3376: ozf_claims_all
3377: WHERE claim_id = cv_claim_id
3378: AND payment_reference_id = header_id;
3379:
3380: l_rma_status VARCHAR2(30);

Line 3585: UPDATE ozf_claims_all

3581: FETCH csr_paid_claim_line INTO l_paid_claim_line;
3582: CLOSE csr_paid_claim_line;
3583:
3584: IF l_total_claim_line = NVL(l_paid_claim_line, 0) THEN
3585: UPDATE ozf_claims_all
3586: SET payment_status = 'INTERFACED'
3587: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3588: END IF; */
3589:

Line 3592: UPDATE ozf_claims_all

3588: END IF; */
3589:
3590: -- Added for Bug4953844
3591: IF l_settlement_doc_tbl.COUNT <> 0 THEN
3592: UPDATE ozf_claims_all
3593: SET payment_status = 'INTERFACED'
3594: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3595:
3596: UPDATE ozf_claim_lines_all

Line 3867: FROM ozf_claims_all

3863: WHERE claim_id = cv_claim_id;
3864:
3865: CURSOR csr_claim_lock(cv_claim_id IN NUMBER) IS
3866: SELECT *
3867: FROM ozf_claims_all
3868: WHERE claim_id = cv_claim_id
3869: FOR UPDATE NOWAIT;
3870:
3871: l_claim_lock_rec csr_claim_lock%ROWTYPE;

Line 4553: ozf_claims_all oc

4549: CURSOR csr_inv_status(cv_claim_id IN NUMBER) IS
4550: SELECT invoice_id,
4551: cancelled_date
4552: FROM ap_invoices_all ap,
4553: ozf_claims_all oc
4554: WHERE claim_id = cv_claim_id
4555: --AND invoice_num = oc.payment_reference_number --//Fix for bug 13976621
4556: AND TO_NUMBER(ap.reference_key1) = oc.claim_id --//Fix for bug 13557215
4557: AND ap.vendor_id = oc.vendor_id

Line 5394: FROM ozf_claims_all

5390: exchange_rate_date,
5391: exchange_rate_type,
5392: exchange_rate,
5393: org_id
5394: FROM ozf_claims_all
5395: WHERE claim_id = cv_claim_id;
5396: l_claim_rec csr_claim_currency%ROWTYPE;
5397: l_exchange_rate NUMBER;
5398:

Line 5681: FROM ozf_claims_all

5677: exchange_rate_date,
5678: exchange_rate_type,
5679: exchange_rate,
5680: org_id
5681: FROM ozf_claims_all
5682: WHERE claim_id = cv_claim_id;
5683: l_claim_rec csr_claim_currency%ROWTYPE;
5684: l_exchange_rate NUMBER;
5685: