DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on WF_EVENT

Line 82: ,p_event_name IN WF_EVENTS.NAME%TYPE

78: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_msg_count OUT NOCOPY NUMBER
81: ,x_msg_data OUT NOCOPY VARCHAR2
82: ,p_event_name IN WF_EVENTS.NAME%TYPE
83: ,p_event_param_list IN WF_PARAMETER_LIST_T
84: )IS
85: l_process VARCHAR2(20);
86: p_chr_id okc_k_headers_b.id%TYPE;

Line 89: p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);

85: l_process VARCHAR2(20);
86: p_chr_id okc_k_headers_b.id%TYPE;
87: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
88: BEGIN
89: p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
90: l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);
91: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,l_process,l_parameter_list);
92:
93: OKL_WF_PVT.raise_event (p_api_version => p_api_version,

Line 91: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,l_process,l_parameter_list);

87: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
88: BEGIN
89: p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
90: l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);
91: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,l_process,l_parameter_list);
92:
93: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
94: p_init_msg_list => p_init_msg_list,
95: x_return_status => x_return_status,

Line 1164: l_business_event_name WF_EVENTS.NAME%TYPE := NULL;

1160: l_lty_code okc_line_styles_b.lty_code%TYPE;
1161: l_parent_line_id okc_k_lines_b.id%TYPE;
1162: l_parameter_list wf_parameter_list_t;
1163: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
1164: l_business_event_name WF_EVENTS.NAME%TYPE := NULL;
1165: --vthiruva end, 15-Sep-2004
1166:
1167: BEGIN
1168: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1245: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_parent_line_id,l_parameter_list);

1241: okl_lla_util_pvt.is_lease_contract(p_cimv_rec.dnz_chr_id) = OKL_API.G_TRUE)THEN
1242:
1243: l_raise_business_event := OKL_API.G_TRUE;
1244: l_business_event_name := G_WF_EVT_ASSET_FEE_CREATED;
1245: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_parent_line_id,l_parameter_list);
1246:
1247: ELSIF(l_lty_code = 'LINK_SERV_ASSET' AND
1248: okl_lla_util_pvt.is_lease_contract(p_cimv_rec.dnz_chr_id) = OKL_API.G_TRUE)THEN
1249:

Line 1252: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID,l_parent_line_id,l_parameter_list);

1248: okl_lla_util_pvt.is_lease_contract(p_cimv_rec.dnz_chr_id) = OKL_API.G_TRUE)THEN
1249:
1250: l_raise_business_event := OKL_API.G_TRUE;
1251: l_business_event_name := G_WF_EVT_ASSET_SERV_FEE_CRTD;
1252: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID,l_parent_line_id,l_parameter_list);
1253:
1254: END IF;
1255:
1256: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN

Line 1257: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cimv_rec.dnz_chr_id,l_parameter_list);

1253:
1254: END IF;
1255:
1256: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN
1257: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cimv_rec.dnz_chr_id,l_parameter_list);
1258: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,p_cimv_rec.object1_id1,l_parameter_list);
1259:
1260: raise_business_event(p_api_version => p_api_version
1261: ,p_init_msg_list => p_init_msg_list

Line 1258: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,p_cimv_rec.object1_id1,l_parameter_list);

1254: END IF;
1255:
1256: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN
1257: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cimv_rec.dnz_chr_id,l_parameter_list);
1258: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,p_cimv_rec.object1_id1,l_parameter_list);
1259:
1260: raise_business_event(p_api_version => p_api_version
1261: ,p_init_msg_list => p_init_msg_list
1262: ,x_return_status => x_return_status

Line 1815: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cplv_rec.dnz_chr_id,l_parameter_list);

1811: -- mvasudev, 09/09/2004
1812: -- Code change to enable Business Event
1813: */
1814: IF (okl_lla_util_pvt.is_lease_contract(p_cplv_rec.dnz_chr_id) = OKL_API.G_TRUE) THEN
1815: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cplv_rec.dnz_chr_id,l_parameter_list);
1816: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
1817: --added party_role_id to list of paramters passed to raise business event.
1818: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
1819: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);

Line 1818: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);

1814: IF (okl_lla_util_pvt.is_lease_contract(p_cplv_rec.dnz_chr_id) = OKL_API.G_TRUE) THEN
1815: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cplv_rec.dnz_chr_id,l_parameter_list);
1816: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
1817: --added party_role_id to list of paramters passed to raise business event.
1818: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
1819: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);
1820:
1821: raise_business_event(p_api_version => p_api_version
1822: ,p_init_msg_list => p_init_msg_list

Line 1819: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);

1815: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cplv_rec.dnz_chr_id,l_parameter_list);
1816: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
1817: --added party_role_id to list of paramters passed to raise business event.
1818: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
1819: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);
1820:
1821: raise_business_event(p_api_version => p_api_version
1822: ,p_init_msg_list => p_init_msg_list
1823: ,x_return_status => x_return_status

Line 4505: l_business_event_name wf_events.name%TYPE;

4501: l_process_type VARCHAR2(20);
4502: l_request_id NUMBER := -1;
4503: l_parameter_list wf_parameter_list_t;
4504: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
4505: l_business_event_name wf_events.name%TYPE;
4506:
4507: BEGIN
4508: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4509: p_init_msg_list,

Line 4559: wf_event.AddParameterToList(G_WF_ITM_TERMS_ID, x_rgpv_rec.id, l_parameter_list);

4555: -- set raise business event flag to true
4556: l_raise_business_event := OKL_API.G_TRUE;
4557: -- set the event name to be raised. this event name will vary for each rule group
4558: l_business_event_name := G_WF_EVT_CONTRACT_TERM_UPDATED;
4559: wf_event.AddParameterToList(G_WF_ITM_TERMS_ID, x_rgpv_rec.id, l_parameter_list);
4560: END IF;
4561: ELSIF(l_process_type IS NOT NULL AND l_process_type = 'LINE')THEN
4562: IF(l_rgpv_rec.rgd_code = 'LAAFLG')THEN
4563: -- raise business event for Liens Title and Registration for the Assets

Line 4568: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rgpv_rec.cle_id, l_parameter_list);

4564: -- set raise business event flag to true
4565: l_raise_business_event := OKL_API.G_TRUE;
4566: -- set the event name to be raised. this event name will vary for each rule group
4567: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
4568: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rgpv_rec.cle_id, l_parameter_list);
4569: ELSIF(l_rgpv_rec.rgd_code = 'LAASTX')THEN
4570: -- raise business event for tax, property tax updated.
4571: l_raise_business_event := OKL_API.G_TRUE;
4572: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;

Line 4573: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rgpv_rec.cle_id, l_parameter_list);

4569: ELSIF(l_rgpv_rec.rgd_code = 'LAASTX')THEN
4570: -- raise business event for tax, property tax updated.
4571: l_raise_business_event := OKL_API.G_TRUE;
4572: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;
4573: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rgpv_rec.cle_id, l_parameter_list);
4574: ELSIF(l_rgpv_rec.rgd_code = 'LAPSTH')THEN
4575: OPEN get_line_style(l_rgpv_rec.cle_id);
4576: FETCH get_line_style INTO l_line_style;
4577: CLOSE get_line_style;

Line 4582: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);

4578: -- raise business event for service line update passthru
4579: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
4580: l_raise_business_event := OKL_API.G_TRUE;
4581: l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;
4582: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);
4583: -- check if the service line in context has a service contract associated with it
4584: -- if so, pass the service contract id and service contract line id as parameters
4585: -- is this valid for contract open interface ?
4586: OPEN get_serv_chr_from_serv(l_rgpv_rec.dnz_chr_id, l_rgpv_rec.cle_id);

Line 4593: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);

4589: IF(l_service_top_line_id IS NOT NULL)THEN
4590: OPEN get_serv_cle_from_serv(l_service_top_line_id);
4591: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
4592: CLOSE get_serv_cle_from_serv;
4593: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
4594: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
4595: END IF;
4596: -- raise the business event for update passthrough for Fee Line
4597: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN

Line 4594: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);

4590: OPEN get_serv_cle_from_serv(l_service_top_line_id);
4591: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
4592: CLOSE get_serv_cle_from_serv;
4593: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
4594: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
4595: END IF;
4596: -- raise the business event for update passthrough for Fee Line
4597: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4598: l_raise_business_event := OKL_API.G_TRUE;

Line 4600: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);

4596: -- raise the business event for update passthrough for Fee Line
4597: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4598: l_raise_business_event := OKL_API.G_TRUE;
4599: l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;
4600: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);
4601: END IF;
4602: ELSIF(l_rgpv_rec.rgd_code = 'LAFEXP')THEN
4603: OPEN get_line_style(l_rgpv_rec.cle_id);
4604: FETCH get_line_style INTO l_line_style;

Line 4610: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);

4606: -- raise business event for service line update expense
4607: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
4608: l_raise_business_event := OKL_API.G_TRUE;
4609: l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;
4610: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);
4611: -- check if the service line in context has a service contract associated with it
4612: -- if so, pass the service contract id and service contract line id as parameters
4613: OPEN get_serv_chr_from_serv(l_rgpv_rec.dnz_chr_id, l_rgpv_rec.cle_id);
4614: FETCH get_serv_chr_from_serv INTO l_service_top_line_id;

Line 4620: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);

4616: IF(l_service_top_line_id IS NOT NULL)THEN
4617: OPEN get_serv_cle_from_serv(l_service_top_line_id);
4618: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
4619: CLOSE get_serv_cle_from_serv;
4620: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
4621: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
4622: END IF;
4623: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4624: l_raise_business_event := OKL_API.G_TRUE;

Line 4621: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);

4617: OPEN get_serv_cle_from_serv(l_service_top_line_id);
4618: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
4619: CLOSE get_serv_cle_from_serv;
4620: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
4621: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
4622: END IF;
4623: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4624: l_raise_business_event := OKL_API.G_TRUE;
4625: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;

Line 4626: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);

4622: END IF;
4623: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4624: l_raise_business_event := OKL_API.G_TRUE;
4625: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;
4626: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);
4627: END IF; -- end if for l_line_style is not null
4628: END IF; -- end if for rgd_code
4629: END IF; -- end if for l_process_type
4630: -- check if the business event needs to be raised

Line 4635: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, l_rgpv_rec.dnz_chr_id, l_parameter_list);

4631: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL AND
4632: OKL_LLA_UTIL_PVT.is_lease_contract(l_rgpv_rec.dnz_chr_id)= OKL_API.G_TRUE)THEN
4633: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
4634: -- added to the parameter list here, than duplicating it in all the above if conditions
4635: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, l_rgpv_rec.dnz_chr_id, l_parameter_list);
4636: raise_business_event(p_api_version => p_api_version,
4637: p_init_msg_list => p_init_msg_list,
4638: x_return_status => x_return_status,
4639: x_msg_count => x_msg_count,