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_SETTLEMENT_DOCS

Line 260: FROM ozf_settlement_docs_all

256: AND oc.claim_id = cv_claim_id;
257:
258: CURSOR csr_settle_doc_obj_ver(cv_settlement_doc_id IN NUMBER) IS
259: SELECT object_version_number
260: FROM ozf_settlement_docs_all
261: WHERE settlement_doc_id = cv_settlement_doc_id;
262:
263: --R12.1 Enhancement
264: CURSOR csr_on_acct_only(cv_claim_id IN NUMBER) IS

Line 1040: UPDATE ozf_settlement_docs_all stlmnt_docs

1036: -- This is because a check can be created and cancelled
1037: -- before canceling the invoice document.
1038: -- Fix for bug 4897546
1039: IF l_claim_rec.payment_method in ( 'CHECK','EFT','WIRE','AP_DEFAULT') THEN
1040: UPDATE ozf_settlement_docs_all stlmnt_docs
1041: SET payment_status = (SELECT SUBSTRB(lkp.displayed_field,1,30)
1042: FROM ap_lookup_codes lkp
1043: where lkp.lookup_type = 'CHECK STATE'
1044: and lkp.lookup_code IN (select status_lookup_code

Line 1458: FROM ozf_settlement_docs

1454: , settlement_amount
1455: , claim_id
1456: , claim_line_id
1457: , payment_method
1458: FROM ozf_settlement_docs
1459: WHERE claim_id = cv_claim_id;
1460:
1461: l_counter NUMBER := 1;
1462: l_total_rma_cr_amount NUMBER := 0;

Line 4034: FROM ozf_settlement_docs

4030: SELECT settlement_doc_id
4031: , object_version_number
4032: , settlement_amount
4033: , status_code
4034: FROM ozf_settlement_docs
4035: WHERE settlement_id = cv_settlement_id;
4036:
4037: l_settlement_doc_tbl settlement_doc_tbl_type;
4038: l_settlement_doc_rec settlement_doc_rec_type;

Line 4228: DELETE FROM ozf_settlement_docs_all

4224: END IF;
4225:
4226: IF l_claim_id_ver(i).payment_method IN ( 'CHECK','EFT','WIRE','AP_DEFAULT') THEN
4227: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Deleting settlement docs ' );
4228: DELETE FROM ozf_settlement_docs_all
4229: WHERE claim_id = l_claim_id_ver(i).claim_id;
4230: END IF;
4231: l_reopened_claims := l_reopened_claims + 1;
4232:

Line 4890: SELECT ozf_settlement_docs_all_s.NEXTVAL

4886: l_settlement_doc_rec settlement_doc_rec_type := p_settlement_doc_rec;
4887: l_id_count NUMBER;
4888:
4889: CURSOR c_settlement_doc_seq IS
4890: SELECT ozf_settlement_docs_all_s.NEXTVAL
4891: FROM DUAL;
4892:
4893: CURSOR c_id_exists(cv_id IN NUMBER) IS
4894: SELECT COUNT(settlement_doc_id)

Line 4895: FROM ozf_settlement_docs_all

4891: FROM DUAL;
4892:
4893: CURSOR c_id_exists(cv_id IN NUMBER) IS
4894: SELECT COUNT(settlement_doc_id)
4895: FROM ozf_settlement_docs_all
4896: WHERE settlement_doc_id = cv_id;
4897:
4898: CURSOR csr_claim_currency(cv_claim_id IN NUMBER) IS
4899: SELECT set_of_books_id,

Line 5012: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Insert_Row)

5008:
5009:
5010:
5011: BEGIN
5012: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Insert_Row)
5013: OZF_SETTLEMENT_DOCS_PKG.Insert_Row(
5014: px_settlement_doc_id => l_settlement_doc_rec.settlement_doc_id,
5015: px_object_version_number => l_settlement_doc_rec.object_version_number,
5016: p_last_update_date => SYSDATE,

Line 5013: OZF_SETTLEMENT_DOCS_PKG.Insert_Row(

5009:
5010:
5011: BEGIN
5012: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Insert_Row)
5013: OZF_SETTLEMENT_DOCS_PKG.Insert_Row(
5014: px_settlement_doc_id => l_settlement_doc_rec.settlement_doc_id,
5015: px_object_version_number => l_settlement_doc_rec.object_version_number,
5016: p_last_update_date => SYSDATE,
5017: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 5159: FROM ozf_settlement_docs_all

5155: l_org_id NUMBER;
5156:
5157: CURSOR csr_settle_obj_ver(cv_settle_doc_id IN NUMBER) IS
5158: SELECT object_version_number
5159: FROM ozf_settlement_docs_all
5160: WHERE settlement_doc_id = cv_settle_doc_id;
5161:
5162: CURSOR csr_claim_currency(cv_claim_id IN NUMBER) IS
5163: SELECT set_of_books_id,

Line 5292: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Update_Row)

5288: END IF;
5289:
5290: -------------------------- update --------------------
5291: BEGIN
5292: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Update_Row)
5293: OZF_SETTLEMENT_DOCS_PKG.Update_Row(
5294: p_settlement_doc_id => l_complete_doc_rec.settlement_doc_id,
5295: p_object_version_number => l_object_version_number,
5296: p_last_update_date => SYSDATE,

Line 5293: OZF_SETTLEMENT_DOCS_PKG.Update_Row(

5289:
5290: -------------------------- update --------------------
5291: BEGIN
5292: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Update_Row)
5293: OZF_SETTLEMENT_DOCS_PKG.Update_Row(
5294: p_settlement_doc_id => l_complete_doc_rec.settlement_doc_id,
5295: p_object_version_number => l_object_version_number,
5296: p_last_update_date => SYSDATE,
5297: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 5350: UPDATE ozf_settlement_docs_all SET

5346: END;
5347:
5348:
5349: /*
5350: UPDATE ozf_settlement_docs_all SET
5351: object_version_number = l_object_version_number,
5352: last_update_date = SYSDATE,
5353: last_updated_by = l_last_updated_by,
5354: last_update_login = l_last_update_login,

Line 5471: FROM ozf_settlement_docs_all

5467: l_object_version NUMBER;
5468:
5469: CURSOR csr_settle_obj_ver(cv_settle_doc_id IN NUMBER) IS
5470: SELECT object_version_number
5471: FROM ozf_settlement_docs_all
5472: WHERE settlement_doc_id = cv_settle_doc_id;
5473:
5474: BEGIN
5475: --------------------- initialize -----------------------

Line 5509: OZF_SETTLEMENT_DOCS_PKG.Delete_Row(

5505: END IF;
5506:
5507: IF p_object_version_number = l_object_version THEN
5508: BEGIN
5509: OZF_SETTLEMENT_DOCS_PKG.Delete_Row(
5510: p_settlement_doc_id => p_settlement_doc_id
5511: );
5512: EXCEPTION
5513: WHEN OTHERS THEN

Line 5529: DELETE FROM ozf_settlement_docs_all

5525: RAISE FND_API.g_exc_error;
5526: END IF;
5527:
5528: /*
5529: DELETE FROM ozf_settlement_docs_all
5530: WHERE settlement_doc_id = p_settlement_doc_id
5531: AND object_version_number = p_object_version_number;
5532:
5533: IF (SQL%NOTFOUND) THEN

Line 5618: FROM ozf_settlement_docs_all

5614: l_settlement_doc_id NUMBER;
5615:
5616: CURSOR c_Settlement_Doc IS
5617: SELECT settlement_doc_id
5618: FROM ozf_settlement_docs_all
5619: WHERE settlement_doc_id = p_settlement_doc_id
5620: AND object_version_number = p_object_version
5621: FOR UPDATE NOWAIT;
5622:

Line 5736: 'OZF_SETTLEMENT_DOCS_ALL',

5732: x_return_status := FND_API.g_ret_sts_success;
5733: /*
5734: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
5735: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
5736: 'OZF_SETTLEMENT_DOCS_ALL',
5737: 'SETTLEMENT_DOC_ID = ''' || p_settlement_doc_rec.SETTLEMENT_DOC_ID ||''''
5738: );
5739: ELSE
5740: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 5741: 'OZF_SETTLEMENT_DOCS_ALL',

5737: 'SETTLEMENT_DOC_ID = ''' || p_settlement_doc_rec.SETTLEMENT_DOC_ID ||''''
5738: );
5739: ELSE
5740: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
5741: 'OZF_SETTLEMENT_DOCS_ALL',
5742: 'SETTLEMENT_DOC_ID = ''' || p_settlement_doc_rec.SETTLEMENT_DOC_ID ||
5743: ''' AND SETTLEMENT_DOC_ID <> ' || p_settlement_doc_rec.SETTLEMENT_DOC_ID
5744: );
5745: END IF;

Line 5972: FROM ozf_settlement_docs_all

5968: l_return_status VARCHAR2(1);
5969:
5970: CURSOR c_complete IS
5971: SELECT *
5972: FROM ozf_settlement_docs_all
5973: WHERE settlement_doc_id = p_settlement_doc_rec.settlement_doc_id;
5974:
5975: l_settlement_doc_rec c_complete%ROWTYPE;
5976: