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_REP_CONTRACT_PARTIES

Line 471: DELETE FROM OKC_REP_CONTRACT_PARTIES

467: -- Initialize API return status to success
468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469:
470: -- Delete the records. The records are locked in the delete_contract API.
471: DELETE FROM OKC_REP_CONTRACT_PARTIES
472: WHERE CONTRACT_ID = p_CONTRACT_ID;
473:
474: -- Standard check of p_commit
475: IF FND_API.To_Boolean( p_commit ) THEN

Line 2516: l_created_by OKC_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;

2512: x_return_status OUT NOCOPY VARCHAR2) IS
2513:
2514: l_api_name VARCHAR2(30);
2515: l_api_version NUMBER;
2516: l_created_by OKC_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;
2517: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;
2518: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;
2519: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;
2520: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;

Line 2517: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;

2513:
2514: l_api_name VARCHAR2(30);
2515: l_api_version NUMBER;
2516: l_created_by OKC_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;
2517: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;
2518: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;
2519: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;
2520: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;
2521:

Line 2518: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;

2514: l_api_name VARCHAR2(30);
2515: l_api_version NUMBER;
2516: l_created_by OKC_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;
2517: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;
2518: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;
2519: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;
2520: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;
2521:
2522: -- Contact cursor.

Line 2519: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;

2515: l_api_version NUMBER;
2516: l_created_by OKC_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;
2517: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;
2518: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;
2519: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;
2520: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;
2521:
2522: -- Contact cursor.
2523: CURSOR party_csr IS

Line 2520: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;

2516: l_created_by OKC_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;
2517: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;
2518: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;
2519: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;
2520: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;
2521:
2522: -- Contact cursor.
2523: CURSOR party_csr IS
2524: SELECT *

Line 2525: FROM OKC_REP_CONTRACT_PARTIES

2521:
2522: -- Contact cursor.
2523: CURSOR party_csr IS
2524: SELECT *
2525: FROM OKC_REP_CONTRACT_PARTIES
2526: WHERE contract_id = p_source_contract_id;
2527: BEGIN
2528:
2529: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2568: -- INSERT THE NEW RECORDS into OKC_REP_CONTRACT_PARTIES table

2564: 'Party Role Code is: ' || party_rec.party_role_code);
2565: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2566: 'Party Location ID is: ' || party_rec.party_location_id);
2567: END IF;
2568: -- INSERT THE NEW RECORDS into OKC_REP_CONTRACT_PARTIES table
2569: INSERT INTO OKC_REP_CONTRACT_PARTIES (
2570: CONTRACT_ID,
2571: PARTY_ID,
2572: PARTY_ROLE_CODE,

Line 2569: INSERT INTO OKC_REP_CONTRACT_PARTIES (

2565: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2566: 'Party Location ID is: ' || party_rec.party_location_id);
2567: END IF;
2568: -- INSERT THE NEW RECORDS into OKC_REP_CONTRACT_PARTIES table
2569: INSERT INTO OKC_REP_CONTRACT_PARTIES (
2570: CONTRACT_ID,
2571: PARTY_ID,
2572: PARTY_ROLE_CODE,
2573: PARTY_LOCATION_ID,

Line 3117: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;

3113: x_return_status OUT NOCOPY VARCHAR2) IS
3114:
3115: l_api_name VARCHAR2(30);
3116: l_api_version NUMBER;
3117: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
3118:
3119: -- Repository Enhancement 12.1 (For Duplicate Action)
3120: x_target_contract_id OKC_REP_CONTRACTS_ALL.CONTRACT_ID%TYPE;
3121: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;

Line 3139: FROM OKC_REP_CONTRACT_PARTIES

3135:
3136:
3137: CURSOR party_csr IS
3138: SELECT party_id
3139: FROM OKC_REP_CONTRACT_PARTIES
3140: WHERE contract_id = p_source_contract_id
3141: AND party_role_code = 'INTERNAL_ORG';
3142:
3143: