APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on OKS_K_HEADERS_B

Line 52: FROM oks_k_headers_b

48: l_api_name CONSTANT VARCHAR2(50) := 'continue_k_process';
49:
50: CURSOR l_kdetails_csr(p_chr_id NUMBER) IS
51: SELECT wf_item_key
52: FROM oks_k_headers_b
53: WHERE chr_id = p_chr_id;
54:
55: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
56: l_wf_attributes OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS;

Line 149: UPDATE oks_k_headers_b

145: -- update process status to 'Quote Accepted' coz approval workflow
146: -- is stopped so we should effectively revert back to the original
147: -- negotiation status.
148: /* IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
149: UPDATE oks_k_headers_b
150: SET object_version_number = object_version_number + 1,
151: renewal_status = 'ACT',
152: last_update_date = SYSDATE,
153: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 190: UPDATE oks_k_headers_b

186: -- update process status to 'Quote Accepted' coz approval workflow
187: -- is stopped so we should effectively revert back to the original
188: -- negotiation status.
189: /* IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
190: UPDATE oks_k_headers_b
191: SET object_version_number = object_version_number + 1,
192: renewal_status = 'REJ',
193: last_update_date = SYSDATE,
194: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 211: UPDATE oks_k_headers_b

207: 'Updating Negotiation status to Complete');
208: END IF;
209: -- We just want to update the negotiation status; NO interaction
210: -- or email or notification is sent for these scenarios
211: UPDATE oks_k_headers_b
212: SET renewal_status = 'COMPLETE',
213: object_version_number = object_version_number + 1,
214: last_update_date = SYSDATE,
215: last_updated_by = FND_GLOBAL.USER_ID,

Line 255: UPDATE oks_k_headers_b

251: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: END IF;
255: UPDATE oks_k_headers_b
256: SET object_version_number = object_version_number + 1,
257: wf_item_key = l_wf_attributes.ITEM_KEY,
258: renewal_status = l_wf_attributes.NEGOTIATION_STATUS,
259: last_update_date = SYSDATE,

Line 1044: SELECT wf_item_key FROM OKS_K_HEADERS_B

1040: and USR.USER_ID = fnd_global.user_id
1041: ;
1042:
1043: CURSOR k_process_csr(p_contract_id IN NUMBER ) IS
1044: SELECT wf_item_key FROM OKS_K_HEADERS_B
1045: WHERE chr_id = p_contract_id;
1046: --
1047: L_INITIATOR_NAME varchar2(100);
1048: L_FINAL_APPROVER_UNAME varchar2(100);

Line 1489: UPDATE oks_k_headers_b

1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: UPDATE oks_k_headers_b
1490: SET object_version_number = object_version_number + 1,
1491: wf_item_key = l_wf_attributes.ITEM_KEY,
1492: renewal_status = l_wf_attributes.NEGOTIATION_STATUS,
1493: last_update_date = SYSDATE,