APPS.OKC_REP_SIGN_WF_PVT dependencies on OKC_REP_SIGNATURE_DETAILS

Line 337: (SELECT 1 FROM okc_rep_signature_details orsd, okc_rep_contracts_all orca

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
339: AND orca.contract_id = orsd.contract_id
340: AND orca.contract_version_num = orsd.contract_version_num);
341:

Line 904: l_contract_id okc_rep_signature_details.contract_id%type;

900: funcmode IN varchar2,
901: resultout OUT nocopy varchar2
902: ) IS
903:
904: l_contract_id okc_rep_signature_details.contract_id%type;
905: l_contract_version okc_rep_signature_details.contract_version_num%type;
906: l_signer_id number;
907: l_sign_status VARCHAR2(30);
908: l_recipient_name FND_USER.user_name%type;

Line 905: l_contract_version okc_rep_signature_details.contract_version_num%type;

901: resultout OUT nocopy varchar2
902: ) IS
903:
904: l_contract_id okc_rep_signature_details.contract_id%type;
905: l_contract_version okc_rep_signature_details.contract_version_num%type;
906: l_signer_id number;
907: l_sign_status VARCHAR2(30);
908: l_recipient_name FND_USER.user_name%type;
909: l_action_code okc_rep_signature_details.action_code%type;

Line 909: l_action_code okc_rep_signature_details.action_code%type;

905: l_contract_version okc_rep_signature_details.contract_version_num%type;
906: l_signer_id number;
907: l_sign_status VARCHAR2(30);
908: l_recipient_name FND_USER.user_name%type;
909: l_action_code okc_rep_signature_details.action_code%type;
910: l_wf_note VARCHAR2(2000);
911: l_api_name VARCHAR2(30);
912: l_return_status VARCHAR2(1);
913: l_msg_count NUMBER;