DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_CONTRACT_USAGES

Line 874: DELETE FROM OKC_REP_CONTRACT_USAGES

870: -- RAISE NO_DATA_FOUND;
871: END IF;
872:
873: -- Delete the records. The records are locked in the delete_contract API.
874: DELETE FROM OKC_REP_CONTRACT_USAGES
875: WHERE contract_TYPE = contract_rec.contract_type
876: AND contract_ID = p_CONTRACT_ID
877: AND contract_VERSION = contract_rec.contract_version_num;
878:

Line 3718: l_created_by OKC_REP_CONTRACT_USAGES.CREATED_BY%TYPE;

3714: x_return_status OUT NOCOPY VARCHAR2) IS
3715:
3716: l_api_name VARCHAR2(30);
3717: l_api_version NUMBER;
3718: l_created_by OKC_REP_CONTRACT_USAGES.CREATED_BY%TYPE;
3719: l_creation_date OKC_REP_CONTRACT_USAGES.CREATION_DATE%TYPE;
3720: l_last_updated_by OKC_REP_CONTRACT_USAGES.LAST_UPDATED_BY%TYPE;
3721: l_last_update_login OKC_REP_CONTRACT_USAGES.LAST_UPDATE_LOGIN%TYPE;
3722: l_last_update_date OKC_REP_CONTRACT_USAGES.LAST_UPDATE_DATE%TYPE;

Line 3719: l_creation_date OKC_REP_CONTRACT_USAGES.CREATION_DATE%TYPE;

3715:
3716: l_api_name VARCHAR2(30);
3717: l_api_version NUMBER;
3718: l_created_by OKC_REP_CONTRACT_USAGES.CREATED_BY%TYPE;
3719: l_creation_date OKC_REP_CONTRACT_USAGES.CREATION_DATE%TYPE;
3720: l_last_updated_by OKC_REP_CONTRACT_USAGES.LAST_UPDATED_BY%TYPE;
3721: l_last_update_login OKC_REP_CONTRACT_USAGES.LAST_UPDATE_LOGIN%TYPE;
3722: l_last_update_date OKC_REP_CONTRACT_USAGES.LAST_UPDATE_DATE%TYPE;
3723: -- l_contract_risk_id OKC_REP_CONTRACT_USAGES.CONTRACT_RISK_ID%TYPE;

Line 3720: l_last_updated_by OKC_REP_CONTRACT_USAGES.LAST_UPDATED_BY%TYPE;

3716: l_api_name VARCHAR2(30);
3717: l_api_version NUMBER;
3718: l_created_by OKC_REP_CONTRACT_USAGES.CREATED_BY%TYPE;
3719: l_creation_date OKC_REP_CONTRACT_USAGES.CREATION_DATE%TYPE;
3720: l_last_updated_by OKC_REP_CONTRACT_USAGES.LAST_UPDATED_BY%TYPE;
3721: l_last_update_login OKC_REP_CONTRACT_USAGES.LAST_UPDATE_LOGIN%TYPE;
3722: l_last_update_date OKC_REP_CONTRACT_USAGES.LAST_UPDATE_DATE%TYPE;
3723: -- l_contract_risk_id OKC_REP_CONTRACT_USAGES.CONTRACT_RISK_ID%TYPE;
3724:

Line 3721: l_last_update_login OKC_REP_CONTRACT_USAGES.LAST_UPDATE_LOGIN%TYPE;

3717: l_api_version NUMBER;
3718: l_created_by OKC_REP_CONTRACT_USAGES.CREATED_BY%TYPE;
3719: l_creation_date OKC_REP_CONTRACT_USAGES.CREATION_DATE%TYPE;
3720: l_last_updated_by OKC_REP_CONTRACT_USAGES.LAST_UPDATED_BY%TYPE;
3721: l_last_update_login OKC_REP_CONTRACT_USAGES.LAST_UPDATE_LOGIN%TYPE;
3722: l_last_update_date OKC_REP_CONTRACT_USAGES.LAST_UPDATE_DATE%TYPE;
3723: -- l_contract_risk_id OKC_REP_CONTRACT_USAGES.CONTRACT_RISK_ID%TYPE;
3724:
3725:

Line 3722: l_last_update_date OKC_REP_CONTRACT_USAGES.LAST_UPDATE_DATE%TYPE;

3718: l_created_by OKC_REP_CONTRACT_USAGES.CREATED_BY%TYPE;
3719: l_creation_date OKC_REP_CONTRACT_USAGES.CREATION_DATE%TYPE;
3720: l_last_updated_by OKC_REP_CONTRACT_USAGES.LAST_UPDATED_BY%TYPE;
3721: l_last_update_login OKC_REP_CONTRACT_USAGES.LAST_UPDATE_LOGIN%TYPE;
3722: l_last_update_date OKC_REP_CONTRACT_USAGES.LAST_UPDATE_DATE%TYPE;
3723: -- l_contract_risk_id OKC_REP_CONTRACT_USAGES.CONTRACT_RISK_ID%TYPE;
3724:
3725:
3726: -- Contact cursor.

Line 3723: -- l_contract_risk_id OKC_REP_CONTRACT_USAGES.CONTRACT_RISK_ID%TYPE;

3719: l_creation_date OKC_REP_CONTRACT_USAGES.CREATION_DATE%TYPE;
3720: l_last_updated_by OKC_REP_CONTRACT_USAGES.LAST_UPDATED_BY%TYPE;
3721: l_last_update_login OKC_REP_CONTRACT_USAGES.LAST_UPDATE_LOGIN%TYPE;
3722: l_last_update_date OKC_REP_CONTRACT_USAGES.LAST_UPDATE_DATE%TYPE;
3723: -- l_contract_risk_id OKC_REP_CONTRACT_USAGES.CONTRACT_RISK_ID%TYPE;
3724:
3725:
3726: -- Contact cursor.
3727: CURSOR usages_csr(doc_type VARCHAR2, doc_id NUMBER, doc_ver number) IS

Line 3729: FROM OKC_REP_CONTRACT_USAGES

3725:
3726: -- Contact cursor.
3727: CURSOR usages_csr(doc_type VARCHAR2, doc_id NUMBER, doc_ver number) IS
3728: SELECT *
3729: FROM OKC_REP_CONTRACT_USAGES
3730: WHERE contract_type = doc_type
3731: AND contract_id = doc_id
3732: AND contract_version = doc_ver;
3733:

Line 3807: -- INSERT THE NEW RECORDS into OKC_REP_CONTRACT_USAGES table

3803: 'business_document_id is: ' || usages_rec.business_document_id);
3804: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3805: 'business_document_version: ' || usages_rec.business_document_version);
3806: END IF;
3807: -- INSERT THE NEW RECORDS into OKC_REP_CONTRACT_USAGES table
3808:
3809: INSERT INTO okc_rep_contract_usages ( sequence_id,
3810: contract_type,
3811: contract_id,

Line 3809: INSERT INTO okc_rep_contract_usages ( sequence_id,

3805: 'business_document_version: ' || usages_rec.business_document_version);
3806: END IF;
3807: -- INSERT THE NEW RECORDS into OKC_REP_CONTRACT_USAGES table
3808:
3809: INSERT INTO okc_rep_contract_usages ( sequence_id,
3810: contract_type,
3811: contract_id,
3812: contract_version,
3813: business_document_type,

Line 3832: VALUES (okc_rep_contract_usages_s.NEXTVAL,

3828: created_by,
3829: last_updated_by,
3830: last_update_date
3831: )
3832: VALUES (okc_rep_contract_usages_s.NEXTVAL,
3833: contract_rec.contract_type,
3834: p_contract_id,
3835: contract_rec.contract_version_num +1 ,
3836: usages_rec.business_document_type,

Line 3845: -- if the previous version contract relationships data is migrated from okc_rep_contrcat_rels to okc_rep_contract_usages

3841: usages_rec.pk2_value,
3842: usages_rec.pk3_value,
3843: usages_rec.pk4_value,
3844: usages_rec.pk5_value,
3845: -- if the previous version contract relationships data is migrated from okc_rep_contrcat_rels to okc_rep_contract_usages
3846: -- then, source_code value is 'MIGRATION', we should not copy as MIGRATION, copying it as INTERNAL
3847: decode(usages_rec.source_code, 'MIGRATION', 'INTERNAL', usages_rec.source_code),
3848: usages_rec.relationship_id,
3849: usages_rec.display_in_contract,