APPS.OKC_WF_K_APPROVE dependencies on OKC_API

Line 1163: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1159:
1160: l_contract_id NUMBER;
1161: l_scs_code VARCHAR2(30);
1162: l_wf_item_key VARCHAR2(240);
1163: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1164: l_msg_count NUMBER;
1165: l_msg_data VARCHAR2(2000);
1166:
1167: CURSOR csr_k_details (p_chr_id NUMBER) IS

Line 1207: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1203: p_contract_id => l_contract_id,
1204: p_wf_item_key => NULL,
1205: p_called_from => 'REJECTED'
1206: );
1207: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1208: load_mess(itemtype, itemkey );
1209: END IF;
1210: END IF;
1211: END IF;

Line 1232: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1228: resultout out nocopy varchar2) is
1229:
1230: l_contract_id NUMBER;
1231: l_scs_code VARCHAR2(30);
1232: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1233: l_msg_count NUMBER;
1234: l_msg_data VARCHAR2(2000);
1235:
1236: CURSOR csr_class_code(p_chr_id NUMBER) IS

Line 1277: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1273: p_contract_id => l_contract_id,
1274: p_wf_item_key => NULL,
1275: p_called_from => 'APPROVE'
1276: );
1277: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1278: load_mess(itemtype, itemkey );
1279: END IF;
1280: END IF;
1281: END IF;

Line 1302: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1298:
1299: l_contract_id NUMBER;
1300: l_scs_code VARCHAR2(30);
1301: l_wf_item_key VARCHAR2(240);
1302: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1303: l_msg_count NUMBER;
1304: l_msg_data VARCHAR2(2000);
1305:
1306: CURSOR csr_k_details (p_chr_id NUMBER) IS

Line 1346: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1342: p_contract_id => l_contract_id,
1343: p_wf_item_key => NULL,
1344: p_called_from => 'REJECTED'
1345: );
1346: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1347: load_mess(itemtype, itemkey );
1348: END IF;
1349: END IF;
1350: END IF;

Line 1395: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)

1391: aname => 'CONTRACT_ID');
1392: OKC_CONTRACT_APPROVAL_PUB.k_approved(
1393: p_contract_id => L_CONTRACT_ID,
1394: x_return_status => x_return_status);
1395: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1396: then
1397: --
1398: wf_engine.SetItemAttrDate (
1399: itemtype => itemtype,

Line 1476: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)

1472: aname => 'CONTRACT_ID');
1473: OKC_CONTRACT_APPROVAL_PUB.k_erase_approved(
1474: p_contract_id => L_CONTRACT_ID,
1475: x_return_status => x_return_status);
1476: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1477: then
1478: --
1479: resultout := 'COMPLETE:T';
1480: return;

Line 1559: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)

1555: p_contract_id => L_CONTRACT_ID,
1556: p_date_signed => NVL(L_DATE_SIGNED,sysdate),
1557: x_return_status => x_return_status
1558: );
1559: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1560: then
1561: --
1562: resultout := 'COMPLETE:T';
1563: return;

Line 1675: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1671: funcmode in varchar2,
1672: resultout out nocopy varchar2 )
1673: IS
1674: --Local Variables
1675: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1676: l_contract_id number :=NULL;
1677: l_msg_count number :=NULL;
1678: l_msg_data varchar2(1000) :=NULL;
1679:

Line 1707: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) then

1703: ,x_msg_count => l_msg_count
1704: ,x_msg_data => l_msg_data
1705: ,x_return_status => l_return_status ) ;
1706:
1707: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
1708: --
1709: resultout := 'COMPLETE:T';
1710: return;
1711: --

Line 1766: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)

1762: aname => 'CONTRACT_ID');
1763: OKC_CONTRACT_APPROVAL_PUB.activate_template(
1764: p_contract_id => L_CONTRACT_ID,
1765: x_return_status => x_return_status);
1766: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1767: then
1768: --
1769: resultout := 'COMPLETE:T';
1770: return;

Line 1860: ,p_commit => OKC_API.G_TRUE

1856: aname => 'CONTRACT_ID');
1857:
1858: OKC_OC_INT_PUB.update_quote_from_k(
1859: p_api_version => l_api_version
1860: ,p_commit => OKC_API.G_TRUE
1861: ,p_quote_id => NULL
1862: ,p_contract_id => l_contract_id
1863: ,p_trace_mode => NULL
1864: ,x_return_status => x_return_status

Line 1869: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)

1865: ,x_msg_count => x_msg_count
1866: ,x_msg_data => x_msg_data
1867: );
1868:
1869: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1870: then
1871: --
1872: resultout := 'COMPLETE:T';
1873: return;

Line 1949: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;

1945: l_msg_data VARCHAR2(4000);
1946: l_api_version NUMBER :=1.0 ;
1947: l_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
1948: x_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
1949: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;
1950: l_process_id NUMBER;
1951: BEGIN
1952: mo_global.init('OKC');
1953: --

Line 1980: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN

1976: x_msg_data => l_msg_data,
1977: p_cpsv_rec => l_cpsv_rec,
1978: x_cpsv_rec => x_cpsv_rec);
1979:
1980: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1981: resultout := 'COMPLETE:T';
1982: RETURN;
1983: ELSE
1984: load_mess( itemtype, itemkey );

Line 2055: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;

2051: l_msg_data VARCHAR2(4000);
2052: l_api_version NUMBER :=1.0 ;
2053: l_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2054: x_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2055: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;
2056: l_process_id NUMBER;
2057: l_in_process_yn VARCHAR2(1);
2058: BEGIN
2059: --

Line 2087: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN

2083: x_msg_data => l_msg_data,
2084: p_cpsv_rec => l_cpsv_rec,
2085: x_cpsv_rec => x_cpsv_rec);
2086:
2087: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2088: resultout := 'COMPLETE:T';
2089: RETURN;
2090: ELSE
2091: load_mess( itemtype, itemkey );