DBA Data[Home] [Help]

APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on OKS_WF_K_PROCESS_PVT

Line 56: l_wf_attributes OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS;

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;
57: l_wf_item_key VARCHAR2(240);
58:
59: BEGIN
60:

Line 92: ' OKS_WF_K_PROCESS_PVT.complete_activity with APPROVED result');

88: IF l_wf_item_key IS NOT NULL THEN
89: IF NVL(p_called_from,'!') = 'APPROVE' THEN
90: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
91: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
92: ' OKS_WF_K_PROCESS_PVT.complete_activity with APPROVED result');
93: END IF;
94: OKS_WF_K_PROCESS_PVT.complete_activity
95: (
96: p_api_version => l_api_version,

Line 94: OKS_WF_K_PROCESS_PVT.complete_activity

90: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
91: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
92: ' OKS_WF_K_PROCESS_PVT.complete_activity with APPROVED result');
93: END IF;
94: OKS_WF_K_PROCESS_PVT.complete_activity
95: (
96: p_api_version => l_api_version,
97: p_init_msg_list => OKC_API.G_FALSE,
98: p_contract_id => p_contract_id,

Line 120: ' OKS_WF_K_PROCESS_PVT.complete_activity with STOPPED result');

116:
117: ELSIF NVL(p_called_from,'!') = 'STOP' THEN
118: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
119: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
120: ' OKS_WF_K_PROCESS_PVT.complete_activity with STOPPED result');
121: END IF;
122: OKS_WF_K_PROCESS_PVT.complete_activity
123: (
124: p_api_version => l_api_version,

Line 122: OKS_WF_K_PROCESS_PVT.complete_activity

118: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
119: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
120: ' OKS_WF_K_PROCESS_PVT.complete_activity with STOPPED result');
121: END IF;
122: OKS_WF_K_PROCESS_PVT.complete_activity
123: (
124: p_api_version => l_api_version,
125: p_init_msg_list => OKC_API.G_FALSE,
126: p_contract_id => p_contract_id,

Line 161: ' OKS_WF_K_PROCESS_PVT.complete_activity with REJECTED result');

157: */
158: ELSIF NVL(p_called_from,'!') = 'REJECTED' THEN
159: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
160: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
161: ' OKS_WF_K_PROCESS_PVT.complete_activity with REJECTED result');
162: END IF;
163: OKS_WF_K_PROCESS_PVT.complete_activity
164: (
165: p_api_version => l_api_version,

Line 163: OKS_WF_K_PROCESS_PVT.complete_activity

159: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
160: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
161: ' OKS_WF_K_PROCESS_PVT.complete_activity with REJECTED result');
162: END IF;
163: OKS_WF_K_PROCESS_PVT.complete_activity
164: (
165: p_api_version => l_api_version,
166: p_init_msg_list => OKC_API.G_FALSE,
167: p_contract_id => p_contract_id,

Line 233: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||

229: l_wf_attributes.IRR_FLAG := 'Y';
230: l_wf_attributes.PROCESS_TYPE := 'MANUAL';
231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
233: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||
234: p_contract_id);
235: END IF;
236: OKS_WF_K_PROCESS_PVT.launch_k_process_wf
237: (

Line 236: OKS_WF_K_PROCESS_PVT.launch_k_process_wf

232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
233: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||
234: p_contract_id);
235: END IF;
236: OKS_WF_K_PROCESS_PVT.launch_k_process_wf
237: (
238: p_api_version => 1.0,
239: p_init_msg_list => 'T',
240: p_wf_attributes => l_wf_attributes,

Line 247: 'OKS_WF_K_PROCESS_PVT.launch_k_process_wf x_return_status=>'||

243: x_msg_data => x_msg_data
244: ) ;
245: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
246: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
247: 'OKS_WF_K_PROCESS_PVT.launch_k_process_wf x_return_status=>'||
248: x_return_status);
249: END IF;
250: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1051: l_wf_attributes OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS;

1047: L_INITIATOR_NAME varchar2(100);
1048: L_FINAL_APPROVER_UNAME varchar2(100);
1049: L_INITIATOR_DISPLAY_NAME varchar2(200);
1050: l_rownotfound BOOLEAN := FALSE;
1051: l_wf_attributes OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS;
1052: l_wf_item_key VARCHAR2(240);
1053: --
1054: begin
1055: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1469: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||p_contract_id);

1465: l_wf_attributes.PROCESS_TYPE := 'MANUAL';
1466: x_return_status := 'S';
1467: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
1469: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||p_contract_id);
1470: END IF;
1471: OKS_WF_K_PROCESS_PVT.launch_k_process_wf
1472: (
1473: p_api_version => 1.0,

Line 1471: OKS_WF_K_PROCESS_PVT.launch_k_process_wf

1467: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
1469: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||p_contract_id);
1470: END IF;
1471: OKS_WF_K_PROCESS_PVT.launch_k_process_wf
1472: (
1473: p_api_version => 1.0,
1474: p_init_msg_list => 'T',
1475: p_wf_attributes => l_wf_attributes,

Line 1482: 'OKS_WF_K_PROCESS_PVT.launch_k_process_wf l_return_status=>'||l_return_status);

1478: x_msg_data => x_msg_data
1479: ) ;
1480: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1481: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
1482: 'OKS_WF_K_PROCESS_PVT.launch_k_process_wf l_return_status=>'||l_return_status);
1483: END IF;
1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN