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

Line 334: FROM okc_rep_party_contacts opc

330: p_process_complete OUT NOCOPY VARCHAR2 ) IS
331:
332: CURSOR cur_contacts_seq is
333: SELECT Min(SIGNATURE_SEQUENCE)
334: FROM okc_rep_party_contacts opc
335: WHERE opc.contract_id=p_contract_id
336: AND NOT EXISTS
337: (SELECT 1 FROM okc_rep_signature_details orsd, okc_rep_contracts_all orca
338: WHERE orsd.contract_id=opc.contract_id AND sequence_level=opc.SIGNATURE_SEQUENCE

Line 344: FROM okc_rep_party_contacts opc

340: AND orca.contract_version_num = orsd.contract_version_num);
341:
342: CURSOR cur_contacts(p_seq IN NUMBER ) is
343: SELECT contact_id,party_id,PARTY_ROLE_CODE,SIGNATURE_SEQUENCE,ESIGNATURE_TYPE
344: FROM okc_rep_party_contacts opc
345: WHERE opc.contract_id=p_contract_id
346: AND signature_sequence=p_seq;
347:
348: