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.

[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_PARTY_CONTACTS

Line 352: DELETE FROM OKC_REP_PARTY_CONTACTS

348: -- Initialize API return status to success
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: -- Delete the records. The records are locked in the delete_contract API.
352: DELETE FROM OKC_REP_PARTY_CONTACTS
353: WHERE CONTRACT_ID = p_CONTRACT_ID;
354:
355: -- Standard check of p_commit
356: IF FND_API.To_Boolean( p_commit ) THEN

Line 2341: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;

2337: x_return_status OUT NOCOPY VARCHAR2) IS
2338:
2339: l_api_name VARCHAR2(30);
2340: l_api_version NUMBER;
2341: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2342: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2343: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2344: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2345: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;

Line 2342: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;

2338:
2339: l_api_name VARCHAR2(30);
2340: l_api_version NUMBER;
2341: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2342: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2343: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2344: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2345: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;
2346:

Line 2343: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;

2339: l_api_name VARCHAR2(30);
2340: l_api_version NUMBER;
2341: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2342: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2343: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2344: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2345: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;
2346:
2347: -- Contact cursor.

Line 2344: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;

2340: l_api_version NUMBER;
2341: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2342: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2343: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2344: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2345: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;
2346:
2347: -- Contact cursor.
2348: CURSOR contact_csr IS

Line 2345: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;

2341: l_created_by OKC_REP_PARTY_CONTACTS.CREATED_BY%TYPE;
2342: l_creation_date OKC_REP_PARTY_CONTACTS.CREATION_DATE%TYPE;
2343: l_last_updated_by OKC_REP_PARTY_CONTACTS.LAST_UPDATED_BY%TYPE;
2344: l_last_update_login OKC_REP_PARTY_CONTACTS.LAST_UPDATE_LOGIN%TYPE;
2345: l_last_update_date OKC_REP_PARTY_CONTACTS.LAST_UPDATE_DATE%TYPE;
2346:
2347: -- Contact cursor.
2348: CURSOR contact_csr IS
2349: SELECT *

Line 2350: FROM OKC_REP_PARTY_CONTACTS

2346:
2347: -- Contact cursor.
2348: CURSOR contact_csr IS
2349: SELECT *
2350: FROM OKC_REP_PARTY_CONTACTS
2351: WHERE contract_id = p_source_contract_id;
2352: BEGIN
2353:
2354: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2391: 'Contact Id is: ' || contact_rec.contact_id);
2392: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2393: 'Contact Role Code is: ' || contact_rec.contact_role_id);
2394: END IF;
2395: -- INSERT THE NEW RECORDS into OKC_REP_PARTY_CONTACTS table
2396:
2397: INSERT INTO OKC_REP_PARTY_CONTACTS (
2398: CONTRACT_ID,
2399: PARTY_ID,

Line 2397: INSERT INTO OKC_REP_PARTY_CONTACTS (

2393: 'Contact Role Code is: ' || contact_rec.contact_role_id);
2394: END IF;
2395: -- INSERT THE NEW RECORDS into OKC_REP_PARTY_CONTACTS table
2396:
2397: INSERT INTO OKC_REP_PARTY_CONTACTS (
2398: CONTRACT_ID,
2399: PARTY_ID,
2400: PARTY_ROLE_CODE,
2401: CONTACT_ID,

Line 4758: FROM okc_rep_party_contacts

4754: l_email per_all_people_f.email_address%TYPE;
4755:
4756: CURSOR CONTRACT_CONTACTS(c_contract_id in number) IS
4757: SELECT contact_id
4758: FROM okc_rep_party_contacts
4759: WHERE contract_id = c_contract_id
4760: AND party_role_code = G_PARTY_TYPE_INTERNAL
4761: AND contact_role_id = p_notify_contact_role_id;
4762: