APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_SETTLEMENT_DOCS_ALL_S

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