APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_SETTLEMENT_DOCS_ALL

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 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 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 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 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: