DBA Data[Home] [Help]

APPS.OKL_RGRP_RULES_PROCESS_PVT dependencies on WF_EVENT

Line 71: p_chr_id => wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID, l_event_param_list)

67:
68: -- wrapper API to get contract process. this API determines in which status the
69: -- contract in question is.
70: l_contract_process := okl_lla_util_pvt.get_contract_process(
71: p_chr_id => wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID, l_event_param_list)
72: );
73: -- add the contract status to the event parameter list
74: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, l_contract_process, l_event_param_list);
75:

Line 74: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, l_contract_process, l_event_param_list);

70: l_contract_process := okl_lla_util_pvt.get_contract_process(
71: p_chr_id => wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID, l_event_param_list)
72: );
73: -- add the contract status to the event parameter list
74: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, l_contract_process, l_event_param_list);
75:
76: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
77: p_init_msg_list => p_init_msg_list,
78: x_return_status => x_return_status,

Line 1270: l_business_event_name wf_events.name%TYPE;

1266:
1267: -- sjalasut: aug 30, 04 added variables to support business events. BEGIN
1268:
1269: l_raise_business_event VARCHAR2(1);
1270: l_business_event_name wf_events.name%TYPE;
1271: l_terms_id okc_rule_groups_b.id%TYPE;
1272: l_parameter_list WF_PARAMETER_LIST_T;
1273: -- cursor to get the rule group id from the header.
1274: -- if the Lien Terms and Conditions are updated at the contract level, then the cle_id is null

Line 1516: wf_event.AddParameterToList(G_WF_ITM_TERMS_ID, l_terms_id, l_parameter_list);

1512: OPEN get_header_terms_id(p_chr_id, l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code);
1513: FETCH get_header_terms_id INTO l_terms_id;
1514: CLOSE get_header_terms_id;
1515: IF(l_terms_id IS NOT NULL)THEN
1516: wf_event.AddParameterToList(G_WF_ITM_TERMS_ID, l_terms_id, l_parameter_list);
1517: END IF;
1518: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAAFLG' AND process_type = 'LINE')THEN
1519: -- raise business event for Liens Title and Registration for the Assets
1520: -- set raise business event flag to true

Line 1524: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);

1520: -- set raise business event flag to true
1521: l_raise_business_event := OKL_API.G_TRUE;
1522: -- set the event name to be raised. this event name will vary for each rule group
1523: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
1524: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1525: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAASTX' AND process_type = 'LINE')THEN
1526: -- raise business event for tax, property tax updated.
1527: l_raise_business_event := OKL_API.G_TRUE;
1528: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;

Line 1529: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);

1525: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAASTX' AND process_type = 'LINE')THEN
1526: -- raise business event for tax, property tax updated.
1527: l_raise_business_event := OKL_API.G_TRUE;
1528: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;
1529: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1530: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAPSTH' and process_type = 'LINE')THEN
1531: OPEN get_line_style(p_line_id);
1532: FETCH get_line_style INTO l_line_style;
1533: CLOSE get_line_style;

Line 1538: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);

1534: -- raise business event for service line update passthru
1535: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
1536: l_raise_business_event := OKL_API.G_TRUE;
1537: l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;
1538: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);
1539: -- check if the service line in context has a service contract associated with it
1540: -- if so, pass the service contract id and service contract line id as parameters
1541: OPEN get_serv_chr_from_serv(p_chr_id, p_line_id);
1542: FETCH get_serv_chr_from_serv INTO l_service_top_line_id;

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

1544: IF(l_service_top_line_id IS NOT NULL)THEN
1545: OPEN get_serv_cle_from_serv(l_service_top_line_id);
1546: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
1547: CLOSE get_serv_cle_from_serv;
1548: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1549: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1550: END IF;
1551: -- raise the business event for update passthrough for Fee Line
1552: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN

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

1545: OPEN get_serv_cle_from_serv(l_service_top_line_id);
1546: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
1547: CLOSE get_serv_cle_from_serv;
1548: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1549: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1550: END IF;
1551: -- raise the business event for update passthrough for Fee Line
1552: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1553: l_raise_business_event := OKL_API.G_TRUE;

Line 1555: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);

1551: -- raise the business event for update passthrough for Fee Line
1552: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1553: l_raise_business_event := OKL_API.G_TRUE;
1554: l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;
1555: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);
1556: END IF;
1557: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAFEXP' and process_type = 'LINE')THEN
1558: OPEN get_line_style(p_line_id);
1559: FETCH get_line_style INTO l_line_style;

Line 1565: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);

1561: -- raise business event for service line update expense
1562: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
1563: l_raise_business_event := OKL_API.G_TRUE;
1564: l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;
1565: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);
1566: -- check if the service line in context has a service contract associated with it
1567: -- if so, pass the service contract id and service contract line id as parameters
1568: OPEN get_serv_chr_from_serv(p_chr_id, p_line_id);
1569: FETCH get_serv_chr_from_serv INTO l_service_top_line_id;

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

1571: IF(l_service_top_line_id IS NOT NULL)THEN
1572: OPEN get_serv_cle_from_serv(l_service_top_line_id);
1573: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
1574: CLOSE get_serv_cle_from_serv;
1575: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1576: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1577: END IF;
1578: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1579: l_raise_business_event := OKL_API.G_TRUE;

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

1572: OPEN get_serv_cle_from_serv(l_service_top_line_id);
1573: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
1574: CLOSE get_serv_cle_from_serv;
1575: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1576: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1577: END IF;
1578: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1579: l_raise_business_event := OKL_API.G_TRUE;
1580: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;

Line 1581: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);

1577: END IF;
1578: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1579: l_raise_business_event := OKL_API.G_TRUE;
1580: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;
1581: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);
1582: END IF;
1583: END IF;
1584: END IF;
1585:

Line 1592: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);

1588: OKL_LLA_UTIL_PVT.is_lease_contract(p_chr_id)= OKL_API.G_TRUE)THEN
1589: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
1590: -- added to the parameter list here, than duplicating it in all the above if conditions
1591:
1592: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
1593: raise_business_event(p_api_version => p_api_version,
1594: p_init_msg_list => p_init_msg_list,
1595: x_return_status => x_return_status,
1596: x_msg_count => x_msg_count,