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

238:
239: -- Find out claim object version number
240: CURSOR csr_claim_obj_ver_num(cv_claim_id IN NUMBER) IS
241: SELECT object_version_number
242: FROM ozf_claims
243: WHERE claim_id = cv_claim_id;
244:
245: -- Find out claim object version number
246: CURSOR csr_claim_credit_memo(cv_claim_id IN NUMBER) IS

Line 254: , ozf_claims oc

250: , sysdate
251: , (oc.amount_settled * -1)
252: , pay.status
253: FROM ar_payment_schedules pay
254: , ozf_claims oc
255: WHERE pay.customer_trx_id = oc.payment_reference_id
256: AND oc.claim_id = cv_claim_id;
257:
258: CURSOR csr_settle_doc_obj_ver(cv_settlement_doc_id IN NUMBER) IS

Line 267: FROM ozf_claims

263: --R12.1 Enhancement
264: CURSOR csr_on_acct_only(cv_claim_id IN NUMBER) IS
265: SELECT payment_method,
266: amount
267: FROM ozf_claims
268: WHERE claim_id = cv_claim_id;
269:
270: BEGIN
271: -------------------- initialize -----------------------

Line 824: UPDATE ozf_claims_all

820: OZF_Utility_PVT.debug_message('claim.tax_amount = '||p_claim_rec.tax_amount);
821: END IF;
822:
823: BEGIN
824: UPDATE ozf_claims_all
825: SET tax_amount = NVL(p_claim_rec.tax_amount,0)
826: , acctd_tax_amount = NVL(l_acctd_tax_amount,0)
827: , amount_settled = p_claim_rec.amount_settled
828: , acctd_amount_settled = l_acctd_amount_settled

Line 984: UPDATE ozf_claims

980: -- Note: payment_reference_number is not set to null since this information is used to build
981: -- the next invoice number for check settlement. When the claim status is Open, the payment
982: -- information is not displayed.
983:
984: UPDATE ozf_claims
985: SET status_code = 'OPEN',
986: user_status_id = ozf_utility_pvt.get_default_user_status( 'OZF_CLAIM_STATUS', 'OPEN'),
987: amount_remaining = NVL(amount_remaining,0) + amount_settled,
988: acctd_amount_remaining = NVL(acctd_amount_remaining,0)+acctd_amount_settled,

Line 1185: FROM ozf_claims

1181: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1182:
1183: CURSOR csr_get_claim_details(cv_claim_id IN NUMBER) IS
1184: SELECT payment_method
1185: FROM ozf_claims
1186: WHERE claim_id = cv_claim_id;
1187:
1188: CURSOR csr_inv_settlement( cv_claim_id IN VARCHAR2)IS
1189: SELECT --pay.invoice_payment_id --"settlement_id"

Line 1203: , ozf_claims_all oc

1199: , inv.invoice_amount
1200: FROM ap_invoice_payments_all pay
1201: , ap_checks_all chk
1202: , ap_invoices_all inv
1203: , ozf_claims_all oc
1204: WHERE pay.check_id = chk.check_id
1205: AND inv.invoice_id = pay.invoice_id
1206: AND oc.claim_id = cv_claim_id
1207: AND oc.payment_reference_number = inv.invoice_num

Line 1227: , ozf_claims_all oc

1223: , 'AP_DEBIT' --"payment_method"
1224: , NULL
1225: , inv.invoice_amount
1226: FROM ap_invoices_all inv
1227: , ozf_claims_all oc
1228: WHERE oc.claim_id = cv_claim_id
1229: AND oc.payment_reference_number = inv.invoice_num
1230: AND oc.vendor_id = inv.vendor_id
1231: AND oc.vendor_site_id = inv.vendor_site_id;

Line 1599: FROM ozf_claims_all oc,

1595: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1596:
1597: CURSOR csr_custom_status_id(p_claim_id IN NUMBER, p_status_code IN VARCHAR2) IS
1598: SELECT close_status_id
1599: FROM ozf_claims_all oc,
1600: ams_user_statuses_vl us
1601: WHERE oc.claim_id = p_claim_id
1602: AND oc.close_status_id = us.user_status_id
1603: AND us.system_status_type = 'OZF_CLAIM_STATUS'

Line 1613: FROM ozf_claims_all

1609: --R12.1 Enhancement : Price Protection
1610: CURSOR csr_claim_rec(p_claim_id IN NUMBER) IS
1611: SELECT source_object_class,
1612: created_by
1613: FROM ozf_claims_all
1614: WHERE claim_id = p_claim_id;
1615:
1616: CURSOR csr_claim_lines(cv_claim_id IN NUMBER) IS
1617: SELECT ln.claim_line_id

Line 1751: UPDATE ozf_claims_all

1747: CLOSE csr_user_status_id;
1748: END IF;
1749:
1750: BEGIN
1751: UPDATE ozf_claims_all
1752: SET payment_status = p_payment_status
1753: , status_code = p_status_code
1754: , user_status_id = l_claim_rec.user_status_id
1755: WHERE claim_id = p_claim_id;

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

2767:
2768: FND_DSQL.init;
2769:
2770: FND_DSQL.add_text('SELECT claim_id, claim_number, object_version_number, claim_class, amount_remaining, amount_settled, source_object_id, payment_method ');
2771: FND_DSQL.add_text('FROM ozf_claims ');
2772: FND_DSQL.add_text('WHERE status_code = ''PENDING_CLOSE'' ');
2773:
2774: i := p_payment_method_tbl.FIRST;
2775: IF i IS NOT NULL THEN

Line 2860: FROM ozf_claims_all

2856: AND payment_status = 'PAID';
2857:
2858: CURSOR csr_claim_lock(cv_claim_id IN NUMBER) IS
2859: SELECT claim_id
2860: FROM ozf_claims_all
2861: WHERE claim_id = cv_claim_id
2862: FOR UPDATE NOWAIT;
2863:
2864: l_claim_lock_rec csr_claim_lock%ROWTYPE;

Line 2904: ozf_claims_all

2900:
2901: CURSOR csr_rma_status(cv_claim_id IN NUMBER) IS
2902: SELECT flow_status_code
2903: FROM oe_order_headers_all,
2904: ozf_claims_all
2905: WHERE claim_id = cv_claim_id
2906: AND payment_reference_id = header_id;
2907:
2908: l_rma_status VARCHAR2(30);

Line 3113: UPDATE ozf_claims_all

3109: FETCH csr_paid_claim_line INTO l_paid_claim_line;
3110: CLOSE csr_paid_claim_line;
3111:
3112: IF l_total_claim_line = NVL(l_paid_claim_line, 0) THEN
3113: UPDATE ozf_claims_all
3114: SET payment_status = 'INTERFACED'
3115: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3116: END IF; */
3117:

Line 3120: UPDATE ozf_claims_all

3116: END IF; */
3117:
3118: -- Added for Bug4953844
3119: IF l_settlement_doc_tbl.COUNT <> 0 THEN
3120: UPDATE ozf_claims_all
3121: SET payment_status = 'INTERFACED'
3122: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3123:
3124: UPDATE ozf_claim_lines_all

Line 3395: FROM ozf_claims_all

3391: WHERE claim_id = cv_claim_id;
3392:
3393: CURSOR csr_claim_lock(cv_claim_id IN NUMBER) IS
3394: SELECT *
3395: FROM ozf_claims_all
3396: WHERE claim_id = cv_claim_id
3397: FOR UPDATE NOWAIT;
3398:
3399: l_claim_lock_rec csr_claim_lock%ROWTYPE;

Line 4068: ozf_claims_all oc

4064: CURSOR csr_inv_status(cv_claim_id IN NUMBER) IS
4065: SELECT invoice_id,
4066: cancelled_date
4067: FROM ap_invoices_all ap,
4068: ozf_claims_all oc
4069: WHERE claim_id = cv_claim_id
4070: AND invoice_num = oc.payment_reference_number
4071: AND ap.vendor_id = oc.vendor_id
4072: AND ap.vendor_site_id = oc.vendor_site_id;

Line 4905: FROM ozf_claims_all

4901: exchange_rate_date,
4902: exchange_rate_type,
4903: exchange_rate,
4904: org_id
4905: FROM ozf_claims_all
4906: WHERE claim_id = cv_claim_id;
4907: l_claim_rec csr_claim_currency%ROWTYPE;
4908: l_exchange_rate NUMBER;
4909:

Line 5169: FROM ozf_claims_all

5165: exchange_rate_date,
5166: exchange_rate_type,
5167: exchange_rate,
5168: org_id
5169: FROM ozf_claims_all
5170: WHERE claim_id = cv_claim_id;
5171: l_claim_rec csr_claim_currency%ROWTYPE;
5172: l_exchange_rate NUMBER;
5173: