APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_SETTLEMENT_DOCS_ALL

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