DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on WF_EVENT

Line 73: ,p_event_name IN WF_EVENTS.NAME%TYPE

69: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,x_msg_count OUT NOCOPY NUMBER
72: ,x_msg_data OUT NOCOPY VARCHAR2
73: ,p_event_name IN WF_EVENTS.NAME%TYPE
74: ,p_event_param_list IN WF_PARAMETER_LIST_T
75: )IS
76: l_process VARCHAR2(20);
77: p_chr_id okc_k_headers_b.id%TYPE;

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

76: l_process VARCHAR2(20);
77: p_chr_id okc_k_headers_b.id%TYPE;
78: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
79: BEGIN
80: p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
81: l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);
82: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,l_process,l_parameter_list);
83:
84: OKL_WF_PVT.raise_event (p_api_version => p_api_version,

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

78: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
79: BEGIN
80: p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
81: l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);
82: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,l_process,l_parameter_list);
83:
84: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
85: p_init_msg_list => p_init_msg_list,
86: x_return_status => x_return_status,

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

1107: l_lty_code okc_line_styles_b.lty_code%TYPE;
1108: l_parent_line_id okc_k_lines_b.id%TYPE;
1109: l_parameter_list wf_parameter_list_t;
1110: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
1111: l_business_event_name WF_EVENTS.NAME%TYPE := NULL;
1112: --vthiruva end, 15-Sep-2004
1113:
1114: BEGIN
1115: x_return_status := OKC_API.G_RET_STS_SUCCESS;

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

1188: okl_lla_util_pvt.is_lease_contract(p_cimv_rec.dnz_chr_id) = OKL_API.G_TRUE)THEN
1189:
1190: l_raise_business_event := OKL_API.G_TRUE;
1191: l_business_event_name := G_WF_EVT_ASSET_FEE_CREATED;
1192: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_parent_line_id,l_parameter_list);
1193:
1194: ELSIF(l_lty_code = 'LINK_SERV_ASSET' AND
1195: okl_lla_util_pvt.is_lease_contract(p_cimv_rec.dnz_chr_id) = OKL_API.G_TRUE)THEN
1196:

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

1195: okl_lla_util_pvt.is_lease_contract(p_cimv_rec.dnz_chr_id) = OKL_API.G_TRUE)THEN
1196:
1197: l_raise_business_event := OKL_API.G_TRUE;
1198: l_business_event_name := G_WF_EVT_ASSET_SERV_FEE_CRTD;
1199: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID,l_parent_line_id,l_parameter_list);
1200:
1201: END IF;
1202:
1203: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN

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

1200:
1201: END IF;
1202:
1203: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN
1204: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cimv_rec.dnz_chr_id,l_parameter_list);
1205: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,p_cimv_rec.object1_id1,l_parameter_list);
1206:
1207: raise_business_event(p_api_version => p_api_version
1208: ,p_init_msg_list => p_init_msg_list

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

1201: END IF;
1202:
1203: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN
1204: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cimv_rec.dnz_chr_id,l_parameter_list);
1205: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,p_cimv_rec.object1_id1,l_parameter_list);
1206:
1207: raise_business_event(p_api_version => p_api_version
1208: ,p_init_msg_list => p_init_msg_list
1209: ,x_return_status => x_return_status

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

1758: -- mvasudev, 09/09/2004
1759: -- Code change to enable Business Event
1760: */
1761: IF (okl_lla_util_pvt.is_lease_contract(p_cplv_rec.dnz_chr_id) = OKL_API.G_TRUE) THEN
1762: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cplv_rec.dnz_chr_id,l_parameter_list);
1763: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
1764: --added party_role_id to list of paramters passed to raise business event.
1765: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
1766: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);

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

1761: IF (okl_lla_util_pvt.is_lease_contract(p_cplv_rec.dnz_chr_id) = OKL_API.G_TRUE) THEN
1762: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cplv_rec.dnz_chr_id,l_parameter_list);
1763: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
1764: --added party_role_id to list of paramters passed to raise business event.
1765: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
1766: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);
1767:
1768: raise_business_event(p_api_version => p_api_version
1769: ,p_init_msg_list => p_init_msg_list

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

1762: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_cplv_rec.dnz_chr_id,l_parameter_list);
1763: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
1764: --added party_role_id to list of paramters passed to raise business event.
1765: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
1766: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);
1767:
1768: raise_business_event(p_api_version => p_api_version
1769: ,p_init_msg_list => p_init_msg_list
1770: ,x_return_status => x_return_status

Line 4452: l_business_event_name wf_events.name%TYPE;

4448: l_process_type VARCHAR2(20);
4449: l_request_id NUMBER := -1;
4450: l_parameter_list wf_parameter_list_t;
4451: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
4452: l_business_event_name wf_events.name%TYPE;
4453:
4454: BEGIN
4455: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4456: p_init_msg_list,

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

4502: -- set raise business event flag to true
4503: l_raise_business_event := OKL_API.G_TRUE;
4504: -- set the event name to be raised. this event name will vary for each rule group
4505: l_business_event_name := G_WF_EVT_CONTRACT_TERM_UPDATED;
4506: wf_event.AddParameterToList(G_WF_ITM_TERMS_ID, x_rgpv_rec.id, l_parameter_list);
4507: END IF;
4508: ELSIF(l_process_type IS NOT NULL AND l_process_type = 'LINE')THEN
4509: IF(l_rgpv_rec.rgd_code = 'LAAFLG')THEN
4510: -- raise business event for Liens Title and Registration for the Assets

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

4511: -- set raise business event flag to true
4512: l_raise_business_event := OKL_API.G_TRUE;
4513: -- set the event name to be raised. this event name will vary for each rule group
4514: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
4515: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rgpv_rec.cle_id, l_parameter_list);
4516: ELSIF(l_rgpv_rec.rgd_code = 'LAASTX')THEN
4517: -- raise business event for tax, property tax updated.
4518: l_raise_business_event := OKL_API.G_TRUE;
4519: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;

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

4516: ELSIF(l_rgpv_rec.rgd_code = 'LAASTX')THEN
4517: -- raise business event for tax, property tax updated.
4518: l_raise_business_event := OKL_API.G_TRUE;
4519: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;
4520: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rgpv_rec.cle_id, l_parameter_list);
4521: ELSIF(l_rgpv_rec.rgd_code = 'LAPSTH')THEN
4522: OPEN get_line_style(l_rgpv_rec.cle_id);
4523: FETCH get_line_style INTO l_line_style;
4524: CLOSE get_line_style;

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

4525: -- raise business event for service line update passthru
4526: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
4527: l_raise_business_event := OKL_API.G_TRUE;
4528: l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;
4529: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);
4530: -- check if the service line in context has a service contract associated with it
4531: -- if so, pass the service contract id and service contract line id as parameters
4532: -- is this valid for contract open interface ?
4533: OPEN get_serv_chr_from_serv(l_rgpv_rec.dnz_chr_id, l_rgpv_rec.cle_id);

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

4536: IF(l_service_top_line_id IS NOT NULL)THEN
4537: OPEN get_serv_cle_from_serv(l_service_top_line_id);
4538: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
4539: CLOSE get_serv_cle_from_serv;
4540: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
4541: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
4542: END IF;
4543: -- raise the business event for update passthrough for Fee Line
4544: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN

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

4537: OPEN get_serv_cle_from_serv(l_service_top_line_id);
4538: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
4539: CLOSE get_serv_cle_from_serv;
4540: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
4541: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
4542: END IF;
4543: -- raise the business event for update passthrough for Fee Line
4544: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4545: l_raise_business_event := OKL_API.G_TRUE;

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

4543: -- raise the business event for update passthrough for Fee Line
4544: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4545: l_raise_business_event := OKL_API.G_TRUE;
4546: l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;
4547: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);
4548: END IF;
4549: ELSIF(l_rgpv_rec.rgd_code = 'LAFEXP')THEN
4550: OPEN get_line_style(l_rgpv_rec.cle_id);
4551: FETCH get_line_style INTO l_line_style;

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

4553: -- raise business event for service line update expense
4554: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
4555: l_raise_business_event := OKL_API.G_TRUE;
4556: l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;
4557: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);
4558: -- check if the service line in context has a service contract associated with it
4559: -- if so, pass the service contract id and service contract line id as parameters
4560: OPEN get_serv_chr_from_serv(l_rgpv_rec.dnz_chr_id, l_rgpv_rec.cle_id);
4561: FETCH get_serv_chr_from_serv INTO l_service_top_line_id;

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

4563: IF(l_service_top_line_id IS NOT NULL)THEN
4564: OPEN get_serv_cle_from_serv(l_service_top_line_id);
4565: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
4566: CLOSE get_serv_cle_from_serv;
4567: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
4568: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
4569: END IF;
4570: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4571: l_raise_business_event := OKL_API.G_TRUE;

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

4564: OPEN get_serv_cle_from_serv(l_service_top_line_id);
4565: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
4566: CLOSE get_serv_cle_from_serv;
4567: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
4568: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
4569: END IF;
4570: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4571: l_raise_business_event := OKL_API.G_TRUE;
4572: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;

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

4569: END IF;
4570: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
4571: l_raise_business_event := OKL_API.G_TRUE;
4572: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;
4573: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rgpv_rec.cle_id, l_parameter_list);
4574: END IF; -- end if for l_line_style is not null
4575: END IF; -- end if for rgd_code
4576: END IF; -- end if for l_process_type
4577: -- check if the business event needs to be raised

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

4578: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL AND
4579: OKL_LLA_UTIL_PVT.is_lease_contract(l_rgpv_rec.dnz_chr_id)= OKL_API.G_TRUE)THEN
4580: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
4581: -- added to the parameter list here, than duplicating it in all the above if conditions
4582: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, l_rgpv_rec.dnz_chr_id, l_parameter_list);
4583: raise_business_event(p_api_version => p_api_version,
4584: p_init_msg_list => p_init_msg_list,
4585: x_return_status => x_return_status,
4586: x_msg_count => x_msg_count,