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.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_CONTRACT_RISKS

Line 613: DELETE FROM OKC_CONTRACT_RISKS

609: RAISE FND_API.G_EXC_ERROR;
610: -- RAISE NO_DATA_FOUND;
611: END IF;
612: -- Delete the records. The records are locked in the delete_contract API.
613: DELETE FROM OKC_CONTRACT_RISKS
614: WHERE BUSINESS_DOCUMENT_TYPE = contract_rec.contract_type
615: AND BUSINESS_DOCUMENT_ID = p_CONTRACT_ID
616: AND BUSINESS_DOCUMENT_VERSION = contract_rec.contract_version_num;
617: -- Close cursor

Line 2686: l_created_by OKC_CONTRACT_RISKS.CREATED_BY%TYPE;

2682: x_return_status OUT NOCOPY VARCHAR2) IS
2683:
2684: l_api_name VARCHAR2(30);
2685: l_api_version NUMBER;
2686: l_created_by OKC_CONTRACT_RISKS.CREATED_BY%TYPE;
2687: l_creation_date OKC_CONTRACT_RISKS.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_CONTRACT_RISKS.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_CONTRACT_RISKS.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_CONTRACT_RISKS.LAST_UPDATE_DATE%TYPE;

Line 2687: l_creation_date OKC_CONTRACT_RISKS.CREATION_DATE%TYPE;

2683:
2684: l_api_name VARCHAR2(30);
2685: l_api_version NUMBER;
2686: l_created_by OKC_CONTRACT_RISKS.CREATED_BY%TYPE;
2687: l_creation_date OKC_CONTRACT_RISKS.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_CONTRACT_RISKS.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_CONTRACT_RISKS.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_CONTRACT_RISKS.LAST_UPDATE_DATE%TYPE;
2691: -- l_contract_risk_id OKC_CONTRACT_RISKS.CONTRACT_RISK_ID%TYPE;

Line 2688: l_last_updated_by OKC_CONTRACT_RISKS.LAST_UPDATED_BY%TYPE;

2684: l_api_name VARCHAR2(30);
2685: l_api_version NUMBER;
2686: l_created_by OKC_CONTRACT_RISKS.CREATED_BY%TYPE;
2687: l_creation_date OKC_CONTRACT_RISKS.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_CONTRACT_RISKS.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_CONTRACT_RISKS.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_CONTRACT_RISKS.LAST_UPDATE_DATE%TYPE;
2691: -- l_contract_risk_id OKC_CONTRACT_RISKS.CONTRACT_RISK_ID%TYPE;
2692:

Line 2689: l_last_update_login OKC_CONTRACT_RISKS.LAST_UPDATE_LOGIN%TYPE;

2685: l_api_version NUMBER;
2686: l_created_by OKC_CONTRACT_RISKS.CREATED_BY%TYPE;
2687: l_creation_date OKC_CONTRACT_RISKS.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_CONTRACT_RISKS.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_CONTRACT_RISKS.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_CONTRACT_RISKS.LAST_UPDATE_DATE%TYPE;
2691: -- l_contract_risk_id OKC_CONTRACT_RISKS.CONTRACT_RISK_ID%TYPE;
2692:
2693:

Line 2690: l_last_update_date OKC_CONTRACT_RISKS.LAST_UPDATE_DATE%TYPE;

2686: l_created_by OKC_CONTRACT_RISKS.CREATED_BY%TYPE;
2687: l_creation_date OKC_CONTRACT_RISKS.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_CONTRACT_RISKS.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_CONTRACT_RISKS.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_CONTRACT_RISKS.LAST_UPDATE_DATE%TYPE;
2691: -- l_contract_risk_id OKC_CONTRACT_RISKS.CONTRACT_RISK_ID%TYPE;
2692:
2693:
2694: -- Contact cursor.

Line 2691: -- l_contract_risk_id OKC_CONTRACT_RISKS.CONTRACT_RISK_ID%TYPE;

2687: l_creation_date OKC_CONTRACT_RISKS.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_CONTRACT_RISKS.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_CONTRACT_RISKS.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_CONTRACT_RISKS.LAST_UPDATE_DATE%TYPE;
2691: -- l_contract_risk_id OKC_CONTRACT_RISKS.CONTRACT_RISK_ID%TYPE;
2692:
2693:
2694: -- Contact cursor.
2695: CURSOR risk_csr(doc_type VARCHAR2, doc_id NUMBER) IS

Line 2697: FROM OKC_CONTRACT_RISKS

2693:
2694: -- Contact cursor.
2695: CURSOR risk_csr(doc_type VARCHAR2, doc_id NUMBER) IS
2696: SELECT *
2697: FROM OKC_CONTRACT_RISKS
2698: WHERE business_document_type = doc_type
2699: AND business_document_id = doc_id;
2700:
2701: -- Contract cursor to get contract_type and version

Line 2762: -- SELECT OKC_CONTRACT_RISKS_S.nextval INTO l_contract_risk_id FROM dual;

2758:
2759:
2760: FOR risk_rec IN risk_csr(contract_rec.contract_type, p_source_contract_id) LOOP
2761: -- Get the id column.
2762: -- SELECT OKC_CONTRACT_RISKS_S.nextval INTO l_contract_risk_id FROM dual;
2763:
2764: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2765: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2766: 'Contract Type is: ' || contract_rec.CONTRACT_TYPE);

Line 2782: -- INSERT THE NEW RECORDS into OKC_CONTRACT_RISKS table

2778: 'Risk Occurred Flag is: ' || risk_rec.RISK_OCCURRED_FLAG);
2779: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2780: 'Occurence Date is: ' || to_char(risk_rec.OCCURRENCE_DATE));
2781: END IF;
2782: -- INSERT THE NEW RECORDS into OKC_CONTRACT_RISKS table
2783: INSERT INTO OKC_CONTRACT_RISKS (
2784: -- CONTRACT_RISK_ID,
2785: BUSINESS_DOCUMENT_TYPE,
2786: BUSINESS_DOCUMENT_ID,

Line 2783: INSERT INTO OKC_CONTRACT_RISKS (

2779: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2780: 'Occurence Date is: ' || to_char(risk_rec.OCCURRENCE_DATE));
2781: END IF;
2782: -- INSERT THE NEW RECORDS into OKC_CONTRACT_RISKS table
2783: INSERT INTO OKC_CONTRACT_RISKS (
2784: -- CONTRACT_RISK_ID,
2785: BUSINESS_DOCUMENT_TYPE,
2786: BUSINESS_DOCUMENT_ID,
2787: BUSINESS_DOCUMENT_VERSION,