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_QA_CHECK_PVT dependencies on OKC_REP_PARTY_CONTACTS

Line 575: SELECT Count(*) contact_count FROM okc_rep_party_contacts WHERE contract_id=p_contract_id AND

571: FROM okc_bus_doc_types_b
572: WHERE document_type = p_contract_type;
573:
574: CURSOR contacts_csr IS
575: SELECT Count(*) contact_count FROM okc_rep_party_contacts WHERE contract_id=p_contract_id AND
576: ESIGNATURE_TYPE IS NOT NULL AND SIGNATURE_SEQUENCE IS NOT NULL ;
577:
578: CURSOR contact_detail_csr IS
579: select contact_id,party_id,PARTY_ROLE_CODE,SIGNATURE_SEQUENCE,ESIGNATURE_TYPE

Line 581: okc_rep_party_contacts opc WHERE contract_id=p_contract_id AND

577:
578: CURSOR contact_detail_csr IS
579: select contact_id,party_id,PARTY_ROLE_CODE,SIGNATURE_SEQUENCE,ESIGNATURE_TYPE
580: from
581: okc_rep_party_contacts opc WHERE contract_id=p_contract_id AND
582: ESIGNATURE_TYPE IS NOT NULL AND SIGNATURE_SEQUENCE IS NOT NULL ;
583:
584:
585: CURSOR cur_supplier_user(p_contact_id IN number) IS

Line 1868: FROM (SELECT Count(contact_id) AS contact_count FROM OKC_REP_PARTY_CONTACTS

1864:
1865: --Contacts to Role count
1866: CURSOR c_Contact_role_count IS
1867: SELECT Count(*)
1868: FROM (SELECT Count(contact_id) AS contact_count FROM OKC_REP_PARTY_CONTACTS
1869: WHERE contract_id = p_contract_id
1870: GROUP BY contact_role_id)
1871: WHERE contact_count >1;
1872:

Line 1944: SELECT Count(contact_id) INTO l_con_count FROM OKC_REP_PARTY_CONTACTS

1940: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1941: 'Check for Role and Contacts ');
1942: END IF;
1943:
1944: SELECT Count(contact_id) INTO l_con_count FROM OKC_REP_PARTY_CONTACTS
1945: WHERE contract_id = p_contract_id ;
1946:
1947: IF(l_con_count > 0) THEN
1948: OPEN c_contact_role_count;

Line 2441: FROM okc_rep_party_contacts

2437: party_rec party_csr%ROWTYPE;
2438: -- Contract contacts cursor, used for validating contacts, contact roles
2439: CURSOR party_contact_csr IS
2440: SELECT party_id, party_role_code, contact_id, contact_role_id
2441: FROM okc_rep_party_contacts
2442: WHERE contract_id = p_contract_id;
2443: party_contact_rec party_contact_csr%ROWTYPE;
2444: -- Contract risks cursor, used for validating risk events
2445: CURSOR risk_csr IS