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 572: DELETE FROM OKC_REP_CONTRACT_PARTIES

568: -- Initialize API return status to success
569: x_return_status := FND_API.G_RET_STS_SUCCESS;
570:
571: -- Delete the records. The records are locked in the delete_contract API.
572: DELETE FROM OKC_REP_CONTRACT_PARTIES
573: WHERE CONTRACT_ID = p_CONTRACT_ID;
574:
575: -- Standard check of p_commit
576: IF FND_API.To_Boolean( p_commit ) THEN

Line 2686: l_created_by OKC_REP_CONTRACT_PARTIES.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_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;
2687: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;

Line 2687: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;

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

Line 2688: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;

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

Line 2689: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;

2685: l_api_version NUMBER;
2686: l_created_by OKC_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;
2687: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;
2691:
2692: -- Contact cursor.
2693: CURSOR party_csr IS

Line 2690: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;

2686: l_created_by OKC_REP_CONTRACT_PARTIES.CREATED_BY%TYPE;
2687: l_creation_date OKC_REP_CONTRACT_PARTIES.CREATION_DATE%TYPE;
2688: l_last_updated_by OKC_REP_CONTRACT_PARTIES.LAST_UPDATED_BY%TYPE;
2689: l_last_update_login OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_LOGIN%TYPE;
2690: l_last_update_date OKC_REP_CONTRACT_PARTIES.LAST_UPDATE_DATE%TYPE;
2691:
2692: -- Contact cursor.
2693: CURSOR party_csr IS
2694: SELECT *

Line 2695: FROM OKC_REP_CONTRACT_PARTIES

2691:
2692: -- Contact cursor.
2693: CURSOR party_csr IS
2694: SELECT *
2695: FROM OKC_REP_CONTRACT_PARTIES
2696: WHERE contract_id = p_source_contract_id;
2697: BEGIN
2698:
2699: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2734: 'Party Role Code is: ' || party_rec.party_role_code);
2735: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2736: 'Party Location ID is: ' || party_rec.party_location_id);
2737: END IF;
2738: -- INSERT THE NEW RECORDS into OKC_REP_CONTRACT_PARTIES table
2739: INSERT INTO OKC_REP_CONTRACT_PARTIES (
2740: CONTRACT_ID,
2741: PARTY_ID,
2742: PARTY_ROLE_CODE,

Line 2739: INSERT INTO OKC_REP_CONTRACT_PARTIES (

2735: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2736: 'Party Location ID is: ' || party_rec.party_location_id);
2737: END IF;
2738: -- INSERT THE NEW RECORDS into OKC_REP_CONTRACT_PARTIES table
2739: INSERT INTO OKC_REP_CONTRACT_PARTIES (
2740: CONTRACT_ID,
2741: PARTY_ID,
2742: PARTY_ROLE_CODE,
2743: PARTY_LOCATION_ID,

Line 3287: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;

3283: x_return_status OUT NOCOPY VARCHAR2) IS
3284:
3285: l_api_name VARCHAR2(30);
3286: l_api_version NUMBER;
3287: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
3288:
3289: -- Repository Enhancement 12.1 (For Duplicate Action)
3290: x_target_contract_id OKC_REP_CONTRACTS_ALL.CONTRACT_ID%TYPE;
3291: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;

Line 3309: FROM OKC_REP_CONTRACT_PARTIES

3305:
3306:
3307: CURSOR party_csr IS
3308: SELECT party_id
3309: FROM OKC_REP_CONTRACT_PARTIES
3310: WHERE contract_id = p_source_contract_id
3311: AND party_role_code = 'INTERNAL_ORG';
3312:
3313: