APPS.DPP_CLAIMS_PVT dependencies on OZF_CLAIMS

Line 199: FROM ozf_claims_all

195: WHERE inventory_item_id = p_item_id;
196:
197: CURSOR get_claim_number_csr(p_claim_id NUMBER) IS
198: SELECT claim_number
199: FROM ozf_claims_all
200: WHERE claim_id = p_claim_id;
201:
202: CURSOR get_customer_dtl_csr(p_cust_account_id NUMBER) IS
203: SELECT account_name,

Line 652: FROM ozf_claims

648: l_object_version_number := NULL;
649:
650: SELECT Object_version_number
651: INTO l_object_version_number
652: FROM ozf_claims
653: WHERE claim_id = l_x_claim_id;
654: EXCEPTION
655: WHEN NO_DATA_FOUND THEN
656: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 791: FROM ozf_claims

787: --Retrieve the object version number
788: BEGIN
789: SELECT Object_version_number
790: INTO l_object_version_number
791: FROM ozf_claims
792: WHERE claim_id = l_x_claim_id;
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1005: FROM ozf_claims

1001: --Retrieve the object version number
1002: BEGIN
1003: SELECT Object_version_number
1004: INTO l_object_version_number
1005: FROM ozf_claims
1006: WHERE claim_id = l_x_claim_id;
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1402: FROM ozf_claims_all

1398: SELECT Object_version_number,
1399: cust_account_id
1400: INTO l_object_version_number,
1401: l_cust_account_id
1402: FROM ozf_claims_all
1403: WHERE claim_id = l_txn_hdr_rec.claim_id;
1404: EXCEPTION
1405: WHEN NO_DATA_FOUND THEN
1406: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1550: FROM ozf_claims

1546: --Retrieve the object version number
1547: BEGIN
1548: SELECT Object_version_number
1549: INTO l_object_version_number
1550: FROM ozf_claims
1551: WHERE claim_id = l_txn_hdr_rec.claim_id;
1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1606: FROM ozf_claims_all

1602: --Output XML Generation Code
1603: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'txnnumber,
1604: claim_number claimnumber,'
1605: ||l_reason||'reason
1606: FROM ozf_claims_all
1607: WHERE claim_id = '||l_txn_hdr_rec.claim_id);
1608: dbms_xmlquery.setRowTag(l_queryCtx
1609: ,'ROOT'
1610: );