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 1563: wf_event.AddParameterToList(G_WF_ITM_TERMS_ID, l_terms_id, l_parameter_list);

1559: OPEN get_header_terms_id(p_chr_id, l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code);
1560: FETCH get_header_terms_id INTO l_terms_id;
1561: CLOSE get_header_terms_id;
1562: IF(l_terms_id IS NOT NULL)THEN
1563: wf_event.AddParameterToList(G_WF_ITM_TERMS_ID, l_terms_id, l_parameter_list);
1564: END IF;
1565: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAAFLG' AND process_type = 'LINE')THEN
1566: -- raise business event for Liens Title and Registration for the Assets
1567: -- set raise business event flag to true

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

1567: -- set raise business event flag to true
1568: l_raise_business_event := OKL_API.G_TRUE;
1569: -- set the event name to be raised. this event name will vary for each rule group
1570: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
1571: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1572: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAASTX' AND process_type = 'LINE')THEN
1573: -- raise business event for tax, property tax updated.
1574: l_raise_business_event := OKL_API.G_TRUE;
1575: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;

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

1572: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAASTX' AND process_type = 'LINE')THEN
1573: -- raise business event for tax, property tax updated.
1574: l_raise_business_event := OKL_API.G_TRUE;
1575: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;
1576: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1577: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAPSTH' and process_type = 'LINE')THEN
1578: OPEN get_line_style(p_line_id);
1579: FETCH get_line_style INTO l_line_style;
1580: CLOSE get_line_style;

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

1581: -- raise business event for service line update passthru
1582: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
1583: l_raise_business_event := OKL_API.G_TRUE;
1584: l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;
1585: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);
1586: -- check if the service line in context has a service contract associated with it
1587: -- if so, pass the service contract id and service contract line id as parameters
1588: OPEN get_serv_chr_from_serv(p_chr_id, p_line_id);
1589: FETCH get_serv_chr_from_serv INTO l_service_top_line_id;

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

1591: IF(l_service_top_line_id IS NOT NULL)THEN
1592: OPEN get_serv_cle_from_serv(l_service_top_line_id);
1593: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
1594: CLOSE get_serv_cle_from_serv;
1595: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1596: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1597: END IF;
1598: -- raise the business event for update passthrough for Fee Line
1599: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN

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

1592: OPEN get_serv_cle_from_serv(l_service_top_line_id);
1593: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
1594: CLOSE get_serv_cle_from_serv;
1595: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1596: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1597: END IF;
1598: -- raise the business event for update passthrough for Fee Line
1599: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1600: l_raise_business_event := OKL_API.G_TRUE;

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

1598: -- raise the business event for update passthrough for Fee Line
1599: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1600: l_raise_business_event := OKL_API.G_TRUE;
1601: l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;
1602: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);
1603: END IF;
1604: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAFEXP' and process_type = 'LINE')THEN
1605: OPEN get_line_style(p_line_id);
1606: FETCH get_line_style INTO l_line_style;

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

1608: -- raise business event for service line update expense
1609: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
1610: l_raise_business_event := OKL_API.G_TRUE;
1611: l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;
1612: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);
1613: -- check if the service line in context has a service contract associated with it
1614: -- if so, pass the service contract id and service contract line id as parameters
1615: OPEN get_serv_chr_from_serv(p_chr_id, p_line_id);
1616: FETCH get_serv_chr_from_serv INTO l_service_top_line_id;

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

1618: IF(l_service_top_line_id IS NOT NULL)THEN
1619: OPEN get_serv_cle_from_serv(l_service_top_line_id);
1620: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
1621: CLOSE get_serv_cle_from_serv;
1622: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1623: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1624: END IF;
1625: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1626: l_raise_business_event := OKL_API.G_TRUE;

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

1619: OPEN get_serv_cle_from_serv(l_service_top_line_id);
1620: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
1621: CLOSE get_serv_cle_from_serv;
1622: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1623: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1624: END IF;
1625: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1626: l_raise_business_event := OKL_API.G_TRUE;
1627: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;

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

1624: END IF;
1625: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1626: l_raise_business_event := OKL_API.G_TRUE;
1627: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;
1628: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);
1629: END IF;
1630: END IF;
1631: END IF;
1632:

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

1635: OKL_LLA_UTIL_PVT.is_lease_contract(p_chr_id)= OKL_API.G_TRUE)THEN
1636: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
1637: -- added to the parameter list here, than duplicating it in all the above if conditions
1638:
1639: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
1640: raise_business_event(p_api_version => p_api_version,
1641: p_init_msg_list => p_init_msg_list,
1642: x_return_status => x_return_status,
1643: x_msg_count => x_msg_count,