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
1598: --
1599: wf_engine.SetItemAttrDate (
1600: itemtype => itemtype,
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
1679: --
1680: resultout := 'COMPLETE:T';
1681: return;
1756: p_contract_id => L_CONTRACT_ID,
1757: p_date_signed => NVL(L_DATE_SIGNED,sysdate),
1758: x_return_status => x_return_status
1759: );
1760: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1761: then
1762: --
1763: resultout := 'COMPLETE:T';
1764: wf_engine.threshold :=50; ---Added for bug 8558419
1811: ) is
1812:
1813: l_contract_id NUMBER;
1814: l_scs_code VARCHAR2(30);
1815: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1816: l_msg_count NUMBER;
1817: l_msg_data VARCHAR2(2000);
1818:
1819: CURSOR csr_class_code(p_chr_id NUMBER) IS
1851: p_wf_item_key => NULL,
1852: p_called_from => 'REJECTED'
1853: );
1854: END IF;
1855: if (l_return_status = OKC_API.G_RET_STS_SUCCESS)
1856: then
1857: --
1858: resultout := 'COMPLETE:T';
1859: return;
1967: funcmode in varchar2,
1968: resultout out nocopy varchar2 )
1969: IS
1970: --Local Variables
1971: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1972: l_contract_id number :=NULL;
1973: l_msg_count number :=NULL;
1974: l_msg_data varchar2(1000) :=NULL;
1975:
1999: ,x_msg_count => l_msg_count
2000: ,x_msg_data => l_msg_data
2001: ,x_return_status => l_return_status ) ;
2002:
2003: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2004: --
2005: resultout := 'COMPLETE:T';
2006: return;
2007: --
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
2064: --
2065: resultout := 'COMPLETE:T';
2066: return;
2152: aname => 'CONTRACT_ID');
2153:
2154: OKC_OC_INT_PUB.update_quote_from_k(
2155: p_api_version => l_api_version
2156: ,p_commit => OKC_API.G_TRUE
2157: ,p_quote_id => NULL
2158: ,p_contract_id => l_contract_id
2159: ,p_trace_mode => NULL
2160: ,x_return_status => x_return_status
2161: ,x_msg_count => x_msg_count
2162: ,x_msg_data => x_msg_data
2163: );
2164:
2165: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
2166: then
2167: --
2168: resultout := 'COMPLETE:T';
2169: return;
2241: l_msg_data VARCHAR2(4000);
2242: l_api_version NUMBER :=1.0 ;
2243: l_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2244: x_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2245: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;
2246: l_process_id NUMBER;
2247: BEGIN
2248: mo_global.init('OKC');
2249: --
2272: x_msg_data => l_msg_data,
2273: p_cpsv_rec => l_cpsv_rec,
2274: x_cpsv_rec => x_cpsv_rec);
2275:
2276: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2277: resultout := 'COMPLETE:T';
2278: RETURN;
2279: ELSE
2280: load_mess( itemtype, itemkey );
2347: l_msg_data VARCHAR2(4000);
2348: l_api_version NUMBER :=1.0 ;
2349: l_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2350: x_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2351: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;
2352: l_process_id NUMBER;
2353: l_in_process_yn VARCHAR2(1);
2354: BEGIN
2355: --
2379: x_msg_data => l_msg_data,
2380: p_cpsv_rec => l_cpsv_rec,
2381: x_cpsv_rec => x_cpsv_rec);
2382:
2383: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2384: resultout := 'COMPLETE:T';
2385: RETURN;
2386: ELSE
2387: load_mess( itemtype, itemkey );