498: --
499: -- SET_CTX mode - set context for new DB session
500: --
501: if (command = 'SET_CTX') then
502: OKC_CONTRACT_APPROVAL_PUB.wf_copy_env(
503: p_item_type => item_type,
504: p_item_key => item_key);
505: return;
506: end if;
1589: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1590: itemtype => itemtype,
1591: itemkey => itemkey,
1592: aname => 'CONTRACT_ID');
1593: OKC_CONTRACT_APPROVAL_PUB.k_approved(
1594: p_contract_id => L_CONTRACT_ID,
1595: x_return_status => x_return_status);
1596: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1597: then
1670: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1671: itemtype => itemtype,
1672: itemkey => itemkey,
1673: aname => 'CONTRACT_ID');
1674: OKC_CONTRACT_APPROVAL_PUB.k_erase_approved(
1675: p_contract_id => L_CONTRACT_ID,
1676: x_return_status => x_return_status);
1677: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1678: then
1751: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1752: itemtype => itemtype,
1753: itemkey => itemkey,
1754: aname => 'CONTRACT_ID');
1755: OKC_CONTRACT_APPROVAL_PUB.k_signed(
1756: p_contract_id => L_CONTRACT_ID,
1757: p_date_signed => NVL(L_DATE_SIGNED,sysdate),
1758: x_return_status => x_return_status
1759: );
2055: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
2056: itemtype => itemtype,
2057: itemkey => itemkey,
2058: aname => 'CONTRACT_ID');
2059: OKC_CONTRACT_APPROVAL_PUB.activate_template(
2060: p_contract_id => L_CONTRACT_ID,
2061: x_return_status => x_return_status);
2062: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
2063: then