APPS.OKC_REP_SIGN_WF_PVT dependencies on OKC_CONTRACT_DOCS

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

214: WF_ENGINE.SetItemAttrText (
215: itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'CONTRACT_ATTACHMENTS',
218: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||contract_rec.contract_type
219: ||'&pk2name=BusinessDocumentId&pk2value='||l_contract_id
220: ||'&pk3name=BusinessDocumentVersion&pk3value=-99&categories=OKC_REPO_CONTRACT,OKC_REPO_APP_ABSTRACT');
221:
222:

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

783: WF_ENGINE.SetItemAttrText (
784: itemtype => itemtype,
785: itemkey => itemkey,
786: aname => 'CONTRACT_ATTACHMENTS',
787: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||l_contract_type
788: ||'&pk2name=BusinessDocumentId&pk2value='||l_contract_id
789: ||'&pk3name=BusinessDocumentVersion&pk3value=-99&categories=OKC_REPO_CONTRACT,OKC_REPO_APP_ABSTRACT');
790:
791:

Line 1921: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;

1917: ) IS
1918:
1919: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1920: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
1921: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
1922: l_api_name VARCHAR2(30);
1923: l_return_status VARCHAR2(1);
1924: l_msg_count NUMBER;
1925: l_msg_data VARCHAR2(2000);

Line 1931: from okc_contract_docs

1927: l_value VARCHAR2(1);
1928:
1929: CURSOR contract_attachment_exists(l_contract_id IN NUMBER,l_contract_type IN VARCHAR2, l_con_req_id IN NUMBER) IS
1930: select 'Y'
1931: from okc_contract_docs
1932: where business_document_type = l_contract_type
1933: and business_document_id = l_contract_id
1934: AND request_id = l_con_req_id;
1935:

Line 2020: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;

2016: ) IS
2017:
2018: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2019: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2020: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2021: l_api_name VARCHAR2(30);
2022: l_return_status VARCHAR2(1);
2023: l_msg_count NUMBER;
2024: l_msg_data VARCHAR2(2000);