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 407: FROM ozf_settlement_docs_all

403: AND oc.claim_id = cv_claim_id;
404:
405: CURSOR csr_settle_doc_obj_ver(cv_settlement_doc_id IN NUMBER) IS
406: SELECT object_version_number
407: FROM ozf_settlement_docs_all
408: WHERE settlement_doc_id = cv_settlement_doc_id;
409:
410: --R12.1 Enhancement
411: CURSOR csr_on_acct_only(cv_claim_id IN NUMBER) IS

Line 1275: UPDATE ozf_settlement_docs_all stlmnt_docs

1271: -- This is because a check can be created and cancelled
1272: -- before canceling the invoice document.
1273: -- Fix for bug 4897546
1274: IF l_claim_rec.payment_method in ( 'CHECK','EFT','WIRE','AP_DEFAULT') THEN
1275: UPDATE ozf_settlement_docs_all stlmnt_docs
1276: SET payment_status = (SELECT SUBSTRB(lkp.displayed_field,1,30)
1277: FROM ap_lookup_codes lkp
1278: where lkp.lookup_type = 'CHECK STATE'
1279: and lkp.lookup_code IN (select status_lookup_code

Line 1807: FROM ozf_settlement_docs

1803: , settlement_amount
1804: , claim_id
1805: , claim_line_id
1806: , payment_method
1807: FROM ozf_settlement_docs
1808: WHERE claim_id = cv_claim_id;
1809:
1810: l_counter NUMBER := 1;
1811: l_total_rma_cr_amount NUMBER := 0;

Line 4518: FROM ozf_settlement_docs

4514: SELECT settlement_doc_id
4515: , object_version_number
4516: , settlement_amount
4517: , status_code
4518: FROM ozf_settlement_docs
4519: WHERE settlement_id = cv_settlement_id
4520: AND claim_id = cv_claim_id;
4521:
4522: l_settlement_doc_tbl settlement_doc_tbl_type;

Line 4715: DELETE FROM ozf_settlement_docs_all

4711: END IF;
4712:
4713: IF l_claim_id_ver(i).payment_method IN ( 'CHECK','EFT','WIRE','AP_DEFAULT') THEN
4714: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Deleting settlement docs ' );
4715: DELETE FROM ozf_settlement_docs_all
4716: WHERE claim_id = l_claim_id_ver(i).claim_id;
4717: END IF;
4718: l_reopened_claims := l_reopened_claims + 1;
4719:

Line 5379: SELECT ozf_settlement_docs_all_s.NEXTVAL

5375: l_settlement_doc_rec settlement_doc_rec_type := p_settlement_doc_rec;
5376: l_id_count NUMBER;
5377:
5378: CURSOR c_settlement_doc_seq IS
5379: SELECT ozf_settlement_docs_all_s.NEXTVAL
5380: FROM DUAL;
5381:
5382: CURSOR c_id_exists(cv_id IN NUMBER) IS
5383: SELECT COUNT(settlement_doc_id)

Line 5384: FROM ozf_settlement_docs_all

5380: FROM DUAL;
5381:
5382: CURSOR c_id_exists(cv_id IN NUMBER) IS
5383: SELECT COUNT(settlement_doc_id)
5384: FROM ozf_settlement_docs_all
5385: WHERE settlement_doc_id = cv_id;
5386:
5387: CURSOR csr_claim_currency(cv_claim_id IN NUMBER) IS
5388: SELECT set_of_books_id,

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

5520: END IF;
5521:
5522:
5523: BEGIN
5524: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Insert_Row)
5525: OZF_SETTLEMENT_DOCS_PKG.Insert_Row(
5526: px_settlement_doc_id => l_settlement_doc_rec.settlement_doc_id,
5527: px_object_version_number => l_settlement_doc_rec.object_version_number,
5528: p_last_update_date => SYSDATE,

Line 5525: OZF_SETTLEMENT_DOCS_PKG.Insert_Row(

5521:
5522:
5523: BEGIN
5524: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Insert_Row)
5525: OZF_SETTLEMENT_DOCS_PKG.Insert_Row(
5526: px_settlement_doc_id => l_settlement_doc_rec.settlement_doc_id,
5527: px_object_version_number => l_settlement_doc_rec.object_version_number,
5528: p_last_update_date => SYSDATE,
5529: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 5671: FROM ozf_settlement_docs_all

5667: l_org_id NUMBER;
5668:
5669: CURSOR csr_settle_obj_ver(cv_settle_doc_id IN NUMBER) IS
5670: SELECT object_version_number
5671: FROM ozf_settlement_docs_all
5672: WHERE settlement_doc_id = cv_settle_doc_id;
5673:
5674: CURSOR csr_claim_currency(cv_claim_id IN NUMBER) IS
5675: SELECT set_of_books_id,

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

5826:
5827:
5828: -------------------------- update --------------------
5829: BEGIN
5830: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Update_Row)
5831: OZF_SETTLEMENT_DOCS_PKG.Update_Row(
5832: p_settlement_doc_id => l_complete_doc_rec.settlement_doc_id,
5833: p_object_version_number => l_object_version_number,
5834: p_last_update_date => SYSDATE,

Line 5831: OZF_SETTLEMENT_DOCS_PKG.Update_Row(

5827:
5828: -------------------------- update --------------------
5829: BEGIN
5830: -- Invoke table handler(OZF_SETTLEMENT_DOCS_PKG.Update_Row)
5831: OZF_SETTLEMENT_DOCS_PKG.Update_Row(
5832: p_settlement_doc_id => l_complete_doc_rec.settlement_doc_id,
5833: p_object_version_number => l_object_version_number,
5834: p_last_update_date => SYSDATE,
5835: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 5888: UPDATE ozf_settlement_docs_all SET

5884: END;
5885:
5886:
5887: /*
5888: UPDATE ozf_settlement_docs_all SET
5889: object_version_number = l_object_version_number,
5890: last_update_date = SYSDATE,
5891: last_updated_by = l_last_updated_by,
5892: last_update_login = l_last_update_login,

Line 6009: FROM ozf_settlement_docs_all

6005: l_object_version NUMBER;
6006:
6007: CURSOR csr_settle_obj_ver(cv_settle_doc_id IN NUMBER) IS
6008: SELECT object_version_number
6009: FROM ozf_settlement_docs_all
6010: WHERE settlement_doc_id = cv_settle_doc_id;
6011:
6012: BEGIN
6013: --------------------- initialize -----------------------

Line 6047: OZF_SETTLEMENT_DOCS_PKG.Delete_Row(

6043: END IF;
6044:
6045: IF p_object_version_number = l_object_version THEN
6046: BEGIN
6047: OZF_SETTLEMENT_DOCS_PKG.Delete_Row(
6048: p_settlement_doc_id => p_settlement_doc_id
6049: );
6050: EXCEPTION
6051: WHEN OTHERS THEN

Line 6067: DELETE FROM ozf_settlement_docs_all

6063: RAISE FND_API.g_exc_error;
6064: END IF;
6065:
6066: /*
6067: DELETE FROM ozf_settlement_docs_all
6068: WHERE settlement_doc_id = p_settlement_doc_id
6069: AND object_version_number = p_object_version_number;
6070:
6071: IF (SQL%NOTFOUND) THEN

Line 6156: FROM ozf_settlement_docs_all

6152: l_settlement_doc_id NUMBER;
6153:
6154: CURSOR c_Settlement_Doc IS
6155: SELECT settlement_doc_id
6156: FROM ozf_settlement_docs_all
6157: WHERE settlement_doc_id = p_settlement_doc_id
6158: AND object_version_number = p_object_version
6159: FOR UPDATE NOWAIT;
6160:

Line 6274: 'OZF_SETTLEMENT_DOCS_ALL',

6270: x_return_status := FND_API.g_ret_sts_success;
6271: /*
6272: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
6273: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
6274: 'OZF_SETTLEMENT_DOCS_ALL',
6275: 'SETTLEMENT_DOC_ID = ''' || p_settlement_doc_rec.SETTLEMENT_DOC_ID ||''''
6276: );
6277: ELSE
6278: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 6279: 'OZF_SETTLEMENT_DOCS_ALL',

6275: 'SETTLEMENT_DOC_ID = ''' || p_settlement_doc_rec.SETTLEMENT_DOC_ID ||''''
6276: );
6277: ELSE
6278: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
6279: 'OZF_SETTLEMENT_DOCS_ALL',
6280: 'SETTLEMENT_DOC_ID = ''' || p_settlement_doc_rec.SETTLEMENT_DOC_ID ||
6281: ''' AND SETTLEMENT_DOC_ID <> ' || p_settlement_doc_rec.SETTLEMENT_DOC_ID
6282: );
6283: END IF;

Line 6510: FROM ozf_settlement_docs_all

6506: l_return_status VARCHAR2(1);
6507:
6508: CURSOR c_complete IS
6509: SELECT *
6510: FROM ozf_settlement_docs_all
6511: WHERE settlement_doc_id = p_settlement_doc_rec.settlement_doc_id;
6512:
6513: l_settlement_doc_rec c_complete%ROWTYPE;
6514: