APPS.DPP_CLAIMS_PVT dependencies on OZF_CLAIMS

Line 193: FROM ozf_claims_all

189: WHERE inventory_item_id = p_item_id;
190:
191: CURSOR get_claim_number_csr(p_claim_id NUMBER) IS
192: SELECT claim_number
193: FROM ozf_claims_all
194: WHERE claim_id = p_claim_id;
195:
196: CURSOR get_customer_dtl_csr(p_cust_account_id NUMBER) IS
197: SELECT account_name,

Line 639: FROM ozf_claims

635: l_object_version_number := NULL;
636:
637: SELECT Object_version_number
638: INTO l_object_version_number
639: FROM ozf_claims
640: WHERE claim_id = l_x_claim_id;
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 777: FROM ozf_claims

773: --Retrieve the object version number
774: BEGIN
775: SELECT Object_version_number
776: INTO l_object_version_number
777: FROM ozf_claims
778: WHERE claim_id = l_x_claim_id;
779: EXCEPTION
780: WHEN NO_DATA_FOUND THEN
781: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 989: FROM ozf_claims

985: --Retrieve the object version number
986: BEGIN
987: SELECT Object_version_number
988: INTO l_object_version_number
989: FROM ozf_claims
990: WHERE claim_id = l_x_claim_id;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1387: FROM ozf_claims_all

1383: SELECT Object_version_number,
1384: cust_account_id
1385: INTO l_object_version_number,
1386: l_cust_account_id
1387: FROM ozf_claims_all
1388: WHERE claim_id = l_txn_hdr_rec.claim_id;
1389: EXCEPTION
1390: WHEN NO_DATA_FOUND THEN
1391: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1537: FROM ozf_claims

1533: --Retrieve the object version number
1534: BEGIN
1535: SELECT Object_version_number
1536: INTO l_object_version_number
1537: FROM ozf_claims
1538: WHERE claim_id = l_txn_hdr_rec.claim_id;
1539: EXCEPTION
1540: WHEN NO_DATA_FOUND THEN
1541: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1593: FROM ozf_claims_all

1589: --Output XML Generation Code
1590: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'txnnumber,
1591: claim_number claimnumber,'
1592: ||l_reason||'reason
1593: FROM ozf_claims_all
1594: WHERE claim_id = '||l_txn_hdr_rec.claim_id);
1595: dbms_xmlquery.setRowTag(l_queryCtx
1596: ,'ROOT'
1597: );