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_PARTY_CONTACTS

Line 453: DELETE FROM OKC_REP_PARTY_CONTACTS

449: -- Initialize API return status to success
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451:
452: -- Delete the records. The records are locked in the delete_contract API.
453: DELETE FROM OKC_REP_PARTY_CONTACTS
454: WHERE CONTRACT_ID = p_CONTRACT_ID;
455:
456: -- Standard check of p_commit
457: IF FND_API.To_Boolean( p_commit ) THEN

Line 2507: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;

2503: x_return_status OUT NOCOPY VARCHAR2) IS
2504:
2505: l_api_name VARCHAR2(30);
2506: l_api_version NUMBER;
2507: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2508: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2509: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2510: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2511: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;

Line 2508: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;

2504:
2505: l_api_name VARCHAR2(30);
2506: l_api_version NUMBER;
2507: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2508: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2509: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2510: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2511: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;
2512:

Line 2509: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;

2505: l_api_name VARCHAR2(30);
2506: l_api_version NUMBER;
2507: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2508: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2509: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2510: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2511: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;
2512:
2513: -- Contact cursor.

Line 2510: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;

2506: l_api_version NUMBER;
2507: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2508: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2509: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2510: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2511: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;
2512:
2513: -- Contact cursor.
2514: CURSOR contact_csr IS

Line 2511: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;

2507: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2508: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2509: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2510: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2511: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;
2512:
2513: -- Contact cursor.
2514: CURSOR contact_csr IS
2515: SELECT *

Line 2516: FROM OKC_REP_PARTY_CONTACTS

2512:
2513: -- Contact cursor.
2514: CURSOR contact_csr IS
2515: SELECT *
2516: FROM OKC_REP_PARTY_CONTACTS
2517: WHERE contract_id = p_source_contract_id;
2518: BEGIN
2519:
2520: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2561: -- INSERT THE NEW RECORDS into OKC_REP_PARTY_CONTACTS table

2557: 'Contact Id is: ' || contact_rec.contact_id);
2558: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2559: 'Contact Role Code is: ' || contact_rec.contact_role_id);
2560: END IF;
2561: -- INSERT THE NEW RECORDS into OKC_REP_PARTY_CONTACTS table
2562:
2563: INSERT INTO OKC_REP_PARTY_CONTACTS (
2564: CONTRACT_ID,
2565: PARTY_ID,

Line 2563: INSERT INTO OKC_REP_PARTY_CONTACTS (

2559: 'Contact Role Code is: ' || contact_rec.contact_role_id);
2560: END IF;
2561: -- INSERT THE NEW RECORDS into OKC_REP_PARTY_CONTACTS table
2562:
2563: INSERT INTO OKC_REP_PARTY_CONTACTS (
2564: CONTRACT_ID,
2565: PARTY_ID,
2566: PARTY_ROLE_CODE,
2567: CONTACT_ID,

Line 5660: FROM okc_rep_party_contacts

5656: l_email per_all_people_f.email_address%TYPE;
5657:
5658: CURSOR CONTRACT_CONTACTS(c_contract_id in number) IS
5659: SELECT contact_id
5660: FROM okc_rep_party_contacts
5661: WHERE contract_id = c_contract_id
5662: AND party_role_code = G_PARTY_TYPE_INTERNAL
5663: AND contact_role_id = p_notify_contact_role_id;
5664: