APPS.OKC_REP_WF_PVT dependencies on OKC_CONTRACT_DOCS

Line 191: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||contract_rec.contract_type

187: WF_ENGINE.SetItemAttrText (
188: itemtype => itemtype,
189: itemkey => itemkey,
190: aname => 'CONTRACT_ATTACHMENTS',
191: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||contract_rec.contract_type
192: ||'&pk2name=BusinessDocumentId&pk2value='||l_contract_id
193: ||'&pk3name=BusinessDocumentVersion&pk3value=-99&categories=OKC_REPO_CONTRACT,OKC_REPO_APP_ABSTRACT');
194:
195: -- Repository Contracts ER's - Calling this after approval

Line 759: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||l_contract_type

755: WF_ENGINE.SetItemAttrText (
756: itemtype => itemtype,
757: itemkey => l_item_key,
758: aname => 'CONTRACT_ATTACHMENTS',
759: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||l_contract_type
760: ||'&pk2name=BusinessDocumentId&pk2value='||l_contract_id
761: ||'&pk3name=BusinessDocumentVersion&pk3value=-99&categories=OKC_REPO_CONTRACT,OKC_REPO_APP_ABSTRACT');
762:
763: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2807: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;

2803: ) IS
2804:
2805: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2806: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2807: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2808: l_api_name VARCHAR2(30);
2809: l_return_status VARCHAR2(1);
2810: l_msg_count NUMBER;
2811: l_msg_data VARCHAR2(2000);

Line 2817: from okc_contract_docs

2813: l_value VARCHAR2(1);
2814:
2815: CURSOR contract_attachment_exists(l_contract_id IN NUMBER,l_contract_type IN VARCHAR2, l_con_req_id IN NUMBER) IS
2816: select 'Y'
2817: from okc_contract_docs
2818: where business_document_type = l_contract_type
2819: and business_document_id = l_contract_id
2820: AND request_id = l_con_req_id;
2821:

Line 2973: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;

2969: ) IS
2970:
2971: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2972: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2973: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2974: l_api_name VARCHAR2(30);
2975: l_return_status VARCHAR2(1);
2976: l_msg_count NUMBER;
2977: l_msg_data VARCHAR2(2000);

Line 3057: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;

3053: ) IS
3054:
3055: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
3056: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
3057: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
3058: l_api_name VARCHAR2(30);
3059: l_return_status VARCHAR2(1);
3060: l_msg_count NUMBER;
3061: l_msg_data VARCHAR2(2000);