eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_COPY_CONTRACT_PVT dependencies on WF_EVENT

Line 5312: l_event_name wf_events.name%TYPE := NULL;

5308: l_tal_kle_cle_id NUMBER;
5309: l_new_object1_id1 VARCHAR2(40);
5310: l_contract_process VARCHAR2(30);
5311: l_parameter_list wf_parameter_list_t;
5312: l_event_name wf_events.name%TYPE := NULL;
5313: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
5314: l_business_event_name wf_events.name%TYPE := NULL;
5315:
5316: l_contract_number okc_k_headers_b.contract_number%TYPE;

Line 5314: l_business_event_name wf_events.name%TYPE := NULL;

5310: l_contract_process VARCHAR2(30);
5311: l_parameter_list wf_parameter_list_t;
5312: l_event_name wf_events.name%TYPE := NULL;
5313: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
5314: l_business_event_name wf_events.name%TYPE := NULL;
5315:
5316: l_contract_number okc_k_headers_b.contract_number%TYPE;
5317: l_copied_id NUMBER;
5318: l_gov_id NUMBER;

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

20149:
20150: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
20151: -- Our contract is always new. So commented following check
20152: --IF (p_source_code = 'new') THEN
20153: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
20154: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
20155: p_init_msg_list => p_init_msg_list,
20156: x_return_status => x_return_status,
20157: x_msg_count => x_msg_count,

Line 20176: p_event_name IN wf_events.name%TYPE,

20172: p_init_msg_list IN VARCHAR2,
20173: x_return_status OUT NOCOPY VARCHAR2,
20174: x_msg_count OUT NOCOPY NUMBER,
20175: x_msg_data OUT NOCOPY VARCHAR2,
20176: p_event_name IN wf_events.name%TYPE,
20177: p_parameter_list IN wf_parameter_list_t,
20178: p_contract_process IN VARCHAR2) IS
20179:
20180: l_chr_id okc_k_headers_b.id%TYPE;

Line 20187: l_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_parameter_list);

20183:
20184: BEGIN
20185: -- check to see if the the contract_id is not null, this is required since
20186: -- credit limit events do not necessarily pass a contract
20187: l_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_parameter_list);
20188: IF(l_chr_id IS NOT NULL)THEN
20189: -- if there exists a contract in context, then derive the contract process status
20190: --l_contract_process := okl_lla_util_pvt.get_contract_process(l_chr_id);
20191: IF(p_contract_process IS NOT NULL)THEN

Line 20193: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,p_contract_process,l_parameter_list);

20189: -- if there exists a contract in context, then derive the contract process status
20190: --l_contract_process := okl_lla_util_pvt.get_contract_process(l_chr_id);
20191: IF(p_contract_process IS NOT NULL)THEN
20192: -- add the contract process status to the parameter list only the value is not null
20193: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,p_contract_process,l_parameter_list);
20194: END IF;
20195: END IF;
20196: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
20197: p_init_msg_list => p_init_msg_list,

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

20225:
20226: -- wrapper API to get contract process. this API determines in which status the
20227: -- contract in question is.
20228: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20229: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20230: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20231: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_ID, p_subsidy_id, l_parameter_list);
20232: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20233: OKL_WF_PVT.raise_event(p_api_version => p_api_version,

Line 20230: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);

20226: -- wrapper API to get contract process. this API determines in which status the
20227: -- contract in question is.
20228: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20229: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20230: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20231: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_ID, p_subsidy_id, l_parameter_list);
20232: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20233: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20234: p_init_msg_list => p_init_msg_list,

Line 20231: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_ID, p_subsidy_id, l_parameter_list);

20227: -- contract in question is.
20228: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20229: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20230: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20231: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_ID, p_subsidy_id, l_parameter_list);
20232: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20233: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20234: p_init_msg_list => p_init_msg_list,
20235: x_return_status => x_return_status,

Line 20232: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);

20228: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20229: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20230: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20231: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_ID, p_subsidy_id, l_parameter_list);
20232: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20233: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20234: p_init_msg_list => p_init_msg_list,
20235: x_return_status => x_return_status,
20236: x_msg_count => x_msg_count,

Line 20252: ,p_event_name IN WF_EVENTS.NAME%TYPE

20248: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
20249: ,x_return_status OUT NOCOPY VARCHAR2
20250: ,x_msg_count OUT NOCOPY NUMBER
20251: ,x_msg_data OUT NOCOPY VARCHAR2
20252: ,p_event_name IN WF_EVENTS.NAME%TYPE
20253: ,p_event_param_list IN WF_PARAMETER_LIST_T
20254: ,p_contract_process IN VARCHAR2
20255: )IS
20256: --l_process VARCHAR2(20);

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

20256: --l_process VARCHAR2(20);
20257: --p_chr_id okc_k_headers_b.id%TYPE;
20258: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
20259: BEGIN
20260: --p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
20261: --l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);
20262: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,p_contract_process,l_parameter_list);
20263:
20264: OKL_WF_PVT.raise_event (p_api_version => p_api_version,

Line 20262: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,p_contract_process,l_parameter_list);

20258: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
20259: BEGIN
20260: --p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
20261: --l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);
20262: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS,p_contract_process,l_parameter_list);
20263:
20264: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
20265: p_init_msg_list => p_init_msg_list,
20266: x_return_status => x_return_status,

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

20291:
20292: -- wrapper API to get contract process. this API determines in which status the
20293: -- contract in question is.
20294: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20295: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20296: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20297: wf_event.AddParameterToList(G_WF_ITM_BOOK_CODE, p_book_code, l_parameter_list);
20298: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20299: OKL_WF_PVT.raise_event(p_api_version => p_api_version,

Line 20296: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);

20292: -- wrapper API to get contract process. this API determines in which status the
20293: -- contract in question is.
20294: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20295: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20296: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20297: wf_event.AddParameterToList(G_WF_ITM_BOOK_CODE, p_book_code, l_parameter_list);
20298: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20299: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20300: p_init_msg_list => p_init_msg_list,

Line 20297: wf_event.AddParameterToList(G_WF_ITM_BOOK_CODE, p_book_code, l_parameter_list);

20293: -- contract in question is.
20294: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20295: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20296: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20297: wf_event.AddParameterToList(G_WF_ITM_BOOK_CODE, p_book_code, l_parameter_list);
20298: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20299: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20300: p_init_msg_list => p_init_msg_list,
20301: x_return_status => x_return_status,

Line 20298: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);

20294: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20295: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20296: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20297: wf_event.AddParameterToList(G_WF_ITM_BOOK_CODE, p_book_code, l_parameter_list);
20298: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20299: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20300: p_init_msg_list => p_init_msg_list,
20301: x_return_status => x_return_status,
20302: x_msg_count => x_msg_count,

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

20328:
20329: -- wrapper API to get contract process. this API determines in which status the
20330: -- contract in question is.
20331: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20332: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20333: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20334: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20335:
20336: OKL_WF_PVT.raise_event(p_api_version => p_api_version,

Line 20333: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);

20329: -- wrapper API to get contract process. this API determines in which status the
20330: -- contract in question is.
20331: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20332: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20333: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20334: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20335:
20336: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20337: p_init_msg_list => p_init_msg_list,

Line 20334: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);

20330: -- contract in question is.
20331: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20332: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20333: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20334: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20335:
20336: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20337: p_init_msg_list => p_init_msg_list,
20338: x_return_status => x_return_status,

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

20361: l_parameter_list wf_parameter_list_t;
20362: BEGIN
20363: x_return_status := OKL_API.G_RET_STS_SUCCESS;
20364:
20365: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20366: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20367: wf_event.AddParameterToList(G_WF_ITM_SERIAL_NUM, p_ser_num, l_parameter_list);
20368: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20369:

Line 20366: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);

20362: BEGIN
20363: x_return_status := OKL_API.G_RET_STS_SUCCESS;
20364:
20365: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20366: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20367: wf_event.AddParameterToList(G_WF_ITM_SERIAL_NUM, p_ser_num, l_parameter_list);
20368: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20369:
20370: OKL_WF_PVT.raise_event(p_api_version => p_api_version,

Line 20367: wf_event.AddParameterToList(G_WF_ITM_SERIAL_NUM, p_ser_num, l_parameter_list);

20363: x_return_status := OKL_API.G_RET_STS_SUCCESS;
20364:
20365: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20366: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20367: wf_event.AddParameterToList(G_WF_ITM_SERIAL_NUM, p_ser_num, l_parameter_list);
20368: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20369:
20370: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20371: p_init_msg_list => p_init_msg_list,

Line 20368: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);

20364:
20365: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20366: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20367: wf_event.AddParameterToList(G_WF_ITM_SERIAL_NUM, p_ser_num, l_parameter_list);
20368: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20369:
20370: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20371: p_init_msg_list => p_init_msg_list,
20372: x_return_status => x_return_status,

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

20398:
20399: -- wrapper API to get contract process. this API determines in which status the
20400: -- contract in question is.
20401: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20402: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20403: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20404: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID, p_vendor_id, l_parameter_list);
20405: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20406:

Line 20403: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);

20399: -- wrapper API to get contract process. this API determines in which status the
20400: -- contract in question is.
20401: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20402: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20403: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20404: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID, p_vendor_id, l_parameter_list);
20405: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20406:
20407: OKL_WF_PVT.raise_event(p_api_version => p_api_version,

Line 20404: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID, p_vendor_id, l_parameter_list);

20400: -- contract in question is.
20401: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20402: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20403: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20404: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID, p_vendor_id, l_parameter_list);
20405: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20406:
20407: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20408: p_init_msg_list => p_init_msg_list,

Line 20405: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);

20401: --l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);
20402: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);
20403: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_asset_id, l_parameter_list);
20404: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID, p_vendor_id, l_parameter_list);
20405: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_parameter_list);
20406:
20407: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20408: p_init_msg_list => p_init_msg_list,
20409: x_return_status => x_return_status,

Line 20435: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_event_param_list);

20431: l_event_param_list WF_PARAMETER_LIST_T := p_event_param_list;
20432: BEGIN
20433: x_return_status := OKL_API.G_RET_STS_SUCCESS;
20434:
20435: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_PROCESS, p_contract_process, l_event_param_list);
20436:
20437: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
20438: p_init_msg_list => p_init_msg_list,
20439: x_return_status => x_return_status,

Line 21622: wf_event.AddParameterToList(G_WF_ITM_CR_LINE_ID,l_copied_id,l_parameter_list);

21618: IF l_lse_id_tab(i) = 58 THEN
21619: -- raise the business event for create credit limit, if line style code is FREE_FORM
21620: l_event_name := G_WF_EVT_CR_LMT_CREATED;
21621: l_raise_business_event := OKL_API.G_TRUE;
21622: wf_event.AddParameterToList(G_WF_ITM_CR_LINE_ID,l_copied_id,l_parameter_list);
21623: wf_event.AddParameterToList(G_WF_ITM_CR_LMT_ID,l_id_tab(i),l_parameter_list);
21624: ELSIF l_lse_id_tab(i) = 33 THEN
21625: -- raise the business event for create asset, if line style code is FREE_FORM1
21626: l_event_name := G_WF_EVT_ASSET_CREATED;

Line 21623: wf_event.AddParameterToList(G_WF_ITM_CR_LMT_ID,l_id_tab(i),l_parameter_list);

21619: -- raise the business event for create credit limit, if line style code is FREE_FORM
21620: l_event_name := G_WF_EVT_CR_LMT_CREATED;
21621: l_raise_business_event := OKL_API.G_TRUE;
21622: wf_event.AddParameterToList(G_WF_ITM_CR_LINE_ID,l_copied_id,l_parameter_list);
21623: wf_event.AddParameterToList(G_WF_ITM_CR_LMT_ID,l_id_tab(i),l_parameter_list);
21624: ELSIF l_lse_id_tab(i) = 33 THEN
21625: -- raise the business event for create asset, if line style code is FREE_FORM1
21626: l_event_name := G_WF_EVT_ASSET_CREATED;
21627: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);

Line 21627: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);

21623: wf_event.AddParameterToList(G_WF_ITM_CR_LMT_ID,l_id_tab(i),l_parameter_list);
21624: ELSIF l_lse_id_tab(i) = 33 THEN
21625: -- raise the business event for create asset, if line style code is FREE_FORM1
21626: l_event_name := G_WF_EVT_ASSET_CREATED;
21627: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21628: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,l_id_tab(i),l_parameter_list);
21629: ELSIF l_lse_id_tab(i) = 48 THEN
21630: -- raise the business event for create service, if line style code is SOLD_SERVICE
21631: l_event_name := G_WF_EVT_SERVICE_CREATED;

Line 21628: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,l_id_tab(i),l_parameter_list);

21624: ELSIF l_lse_id_tab(i) = 33 THEN
21625: -- raise the business event for create asset, if line style code is FREE_FORM1
21626: l_event_name := G_WF_EVT_ASSET_CREATED;
21627: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21628: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,l_id_tab(i),l_parameter_list);
21629: ELSIF l_lse_id_tab(i) = 48 THEN
21630: -- raise the business event for create service, if line style code is SOLD_SERVICE
21631: l_event_name := G_WF_EVT_SERVICE_CREATED;
21632: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);

Line 21632: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);

21628: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,l_id_tab(i),l_parameter_list);
21629: ELSIF l_lse_id_tab(i) = 48 THEN
21630: -- raise the business event for create service, if line style code is SOLD_SERVICE
21631: l_event_name := G_WF_EVT_SERVICE_CREATED;
21632: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21633: wf_event.AddParameterToList(G_WF_ITM_SRV_LINE_ID,l_id_tab(i),l_parameter_list);
21634: --create_fee event is raised from here rather than okl_maintain_fee_pvt
21635: --as contract import process does not call okl_maintain_fee_pvt, but directly calls
21636: --okl_contract_pvt

Line 21633: wf_event.AddParameterToList(G_WF_ITM_SRV_LINE_ID,l_id_tab(i),l_parameter_list);

21629: ELSIF l_lse_id_tab(i) = 48 THEN
21630: -- raise the business event for create service, if line style code is SOLD_SERVICE
21631: l_event_name := G_WF_EVT_SERVICE_CREATED;
21632: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21633: wf_event.AddParameterToList(G_WF_ITM_SRV_LINE_ID,l_id_tab(i),l_parameter_list);
21634: --create_fee event is raised from here rather than okl_maintain_fee_pvt
21635: --as contract import process does not call okl_maintain_fee_pvt, but directly calls
21636: --okl_contract_pvt
21637: ELSIF l_lse_id_tab(i) = 52 THEN

Line 21640: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);

21636: --okl_contract_pvt
21637: ELSIF l_lse_id_tab(i) = 52 THEN
21638: -- raise the business event for create fee, if line style code is FEE
21639: l_event_name := G_WF_EVT_FEE_CREATED;
21640: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21641: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_id_tab(i),l_parameter_list);
21642: END IF;
21643:
21644: -- raise business event only if the contract is a lease contract, the raise_event flag is on and business event

Line 21641: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_id_tab(i),l_parameter_list);

21637: ELSIF l_lse_id_tab(i) = 52 THEN
21638: -- raise the business event for create fee, if line style code is FEE
21639: l_event_name := G_WF_EVT_FEE_CREATED;
21640: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21641: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_id_tab(i),l_parameter_list);
21642: END IF;
21643:
21644: -- raise business event only if the contract is a lease contract, the raise_event flag is on and business event
21645: -- name is specified. the event should also be raised if this is a credit limit, in which case is_lease_contract

Line 21704: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_cle_id_tab(i),l_parameter_list);

21700:
21701: IF(l_lse_id_tab(i) = 53 ) THEN
21702: l_raise_business_event := OKL_API.G_TRUE;
21703: l_business_event_name := G_WF_EVT_ASSET_FEE_CREATED;
21704: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_cle_id_tab(i),l_parameter_list);
21705: ELSIF(l_lse_id_tab(i) = 49 ) THEN
21706: l_raise_business_event := OKL_API.G_TRUE;
21707: l_business_event_name := G_WF_EVT_ASSET_SERV_FEE_CRTD;
21708: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID,l_cle_id_tab(i),l_parameter_list);

Line 21708: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID,l_cle_id_tab(i),l_parameter_list);

21704: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID,l_cle_id_tab(i),l_parameter_list);
21705: ELSIF(l_lse_id_tab(i) = 49 ) THEN
21706: l_raise_business_event := OKL_API.G_TRUE;
21707: l_business_event_name := G_WF_EVT_ASSET_SERV_FEE_CRTD;
21708: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID,l_cle_id_tab(i),l_parameter_list);
21709: END IF;
21710:
21711: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN
21712: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);

Line 21712: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);

21708: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID,l_cle_id_tab(i),l_parameter_list);
21709: END IF;
21710:
21711: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN
21712: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21713: --Ashish ??? Done
21714: --wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,p_cimv_rec.object1_id1,l_parameter_list);
21715: l_new_object1_id1 := find_oid_mapping_id(l_id_tab(i));
21716: IF (l_new_object1_id1 = '-1') THEN

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

21710:
21711: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL)THEN
21712: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21713: --Ashish ??? Done
21714: --wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,p_cimv_rec.object1_id1,l_parameter_list);
21715: l_new_object1_id1 := find_oid_mapping_id(l_id_tab(i));
21716: IF (l_new_object1_id1 = '-1') THEN
21717: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Can not find mapping object1_id1 for ' || l_id_tab(i));

Line 21722: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,l_new_object1_id1,l_parameter_list);

21718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Can not find mapping object1_id1 for ' || l_id_tab(i));
21719: END IF;
21720: RAISE OKL_API.G_EXCEPTION_ERROR;
21721: END IF;
21722: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID,l_new_object1_id1,l_parameter_list);
21723:
21724: raise_business_event_itm(p_api_version => p_api_version
21725: ,p_init_msg_list => p_init_msg_list
21726: ,x_return_status => x_return_status

Line 21776: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);

21772: l_parameter_list := NULL;
21773: FOR i IN l_prid_tab.first..l_prid_tab.last
21774: LOOP
21775:
21776: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21777: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
21778: --added party_role_id to list of paramters passed to raise business event.
21779: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
21780: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);

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

21775:
21776: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21777: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
21778: --added party_role_id to list of paramters passed to raise business event.
21779: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
21780: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);
21781: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,l_probject1_id1_tab(i),l_parameter_list);
21782: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,l_prid_tab(i),l_parameter_list);
21783:

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

21776: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,l_copied_id,l_parameter_list);
21777: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
21778: --added party_role_id to list of paramters passed to raise business event.
21779: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
21780: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);
21781: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,l_probject1_id1_tab(i),l_parameter_list);
21782: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,l_prid_tab(i),l_parameter_list);
21783:
21784: raise_business_event_itm(p_api_version => p_api_version

Line 21781: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,l_probject1_id1_tab(i),l_parameter_list);

21777: --vthiruva..04-jan-2004.. Modified to pass object1_id1 as party id and
21778: --added party_role_id to list of paramters passed to raise business event.
21779: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
21780: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);
21781: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,l_probject1_id1_tab(i),l_parameter_list);
21782: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,l_prid_tab(i),l_parameter_list);
21783:
21784: raise_business_event_itm(p_api_version => p_api_version
21785: ,p_init_msg_list => p_init_msg_list

Line 21782: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,l_prid_tab(i),l_parameter_list);

21778: --added party_role_id to list of paramters passed to raise business event.
21779: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,p_cplv_rec.object1_id1,l_parameter_list);
21780: --wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,x_cplv_rec.id,l_parameter_list);
21781: wf_event.AddParameterToList(G_WF_ITM_PARTY_ID,l_probject1_id1_tab(i),l_parameter_list);
21782: wf_event.AddParameterToList(G_WF_ITM_PARTY_ROLE_ID,l_prid_tab(i),l_parameter_list);
21783:
21784: raise_business_event_itm(p_api_version => p_api_version
21785: ,p_init_msg_list => p_init_msg_list
21786: ,x_return_status => x_return_status

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

21995: l_raise_business_event := OKL_API.G_TRUE;
21996: l_business_event_name := G_WF_EVT_CONTRACT_TERM_UPDATED;
21997: l_terms_id := find_tid_mapping_id(l_rrgd_code_tab(i));
21998: IF(l_terms_id IS NOT NULL)THEN
21999: wf_event.AddParameterToList(G_WF_ITM_TERMS_ID, l_terms_id, l_parameter_list);
22000: END IF;
22001: ELSIF(l_rrgd_code_tab(i) = 'LAAFLG' AND l_rcle_id_tab(i) IS NOT NULL)
22002: THEN
22003: --raise business event for Liens Title and Registration for the Assets

Line 22006: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rcle_id_tab(i), l_parameter_list);

22002: THEN
22003: --raise business event for Liens Title and Registration for the Assets
22004: l_raise_business_event := OKL_API.G_TRUE;
22005: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
22006: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rcle_id_tab(i), l_parameter_list);
22007: ELSIF(l_rrgd_code_tab(i) = 'LAASTX' AND l_rcle_id_tab(i) IS NOT NULL)
22008: THEN
22009: -- raise business event for tax, property tax updated.
22010: l_raise_business_event := OKL_API.G_TRUE;

Line 22012: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rcle_id_tab(i), l_parameter_list);

22008: THEN
22009: -- raise business event for tax, property tax updated.
22010: l_raise_business_event := OKL_API.G_TRUE;
22011: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;
22012: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, l_rcle_id_tab(i), l_parameter_list);
22013: ELSIF(l_rrgd_code_tab(i) = 'LAPSTH' AND l_rcle_id_tab(i) IS NOT NULL)
22014: THEN
22015: l_line_style := find_sid_mapping_id(l_rcle_id_tab(i));
22016: -- raise business event for service line update passthru

Line 22020: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rcle_id_tab(i), l_parameter_list);

22016: -- raise business event for service line update passthru
22017: IF(l_line_style IS NOT NULL AND l_line_style = 48)THEN
22018: l_raise_business_event := OKL_API.G_TRUE;
22019: l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;
22020: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rcle_id_tab(i), l_parameter_list);
22021: -- check if the service line in context has a service contract associated with it
22022: -- if so, pass the service contract id and service contract line id as parameters
22023: IF (NOT(l_queried)) THEN
22024: OPEN c29(l_copied_id);

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

22040: END IF;
22041: l_service_top_line_id := find_ssid_mapping_id(l_rcle_id_tab(i));
22042: IF(l_service_top_line_id IS NOT NULL)THEN
22043: l_serv_contract_id := l_copied_id;
22044: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
22045: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
22046: END IF;
22047: -- raise the business event for update passthrough for Fee Line
22048: ELSIF(l_line_style IS NOT NULL AND l_line_style = 52)THEN

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

22041: l_service_top_line_id := find_ssid_mapping_id(l_rcle_id_tab(i));
22042: IF(l_service_top_line_id IS NOT NULL)THEN
22043: l_serv_contract_id := l_copied_id;
22044: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
22045: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
22046: END IF;
22047: -- raise the business event for update passthrough for Fee Line
22048: ELSIF(l_line_style IS NOT NULL AND l_line_style = 52)THEN
22049: l_raise_business_event := OKL_API.G_TRUE;

Line 22051: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rcle_id_tab(i), l_parameter_list);

22047: -- raise the business event for update passthrough for Fee Line
22048: ELSIF(l_line_style IS NOT NULL AND l_line_style = 52)THEN
22049: l_raise_business_event := OKL_API.G_TRUE;
22050: l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;
22051: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rcle_id_tab(i), l_parameter_list);
22052: END IF;
22053: ELSIF(l_rrgd_code_tab(i) = 'LAFEXP' AND l_rcle_id_tab(i) IS NOT NULL)
22054: THEN
22055: l_line_style := find_sid_mapping_id(l_rcle_id_tab(i));

Line 22063: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rcle_id_tab(i), l_parameter_list);

22059: -- raise business event for service line update expense
22060: IF(l_line_style IS NOT NULL AND l_line_style = 48)THEN
22061: l_raise_business_event := OKL_API.G_TRUE;
22062: l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;
22063: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, l_rcle_id_tab(i), l_parameter_list);
22064: -- check if the service line in context has a service contract associated with it
22065: -- if so, pass the service contract id and service contract line id as parameters
22066: /*OPEN get_serv_chr_from_serv(p_chr_id, p_line_id);
22067: FETCH get_serv_chr_from_serv INTO l_service_top_line_id;

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

22089: /*OPEN get_serv_cle_from_serv(l_service_top_line_id);
22090: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
22091: CLOSE get_serv_cle_from_serv; */
22092: l_serv_contract_id := l_copied_id;
22093: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
22094: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
22095: END IF;
22096: ELSIF(l_line_style IS NOT NULL AND l_line_style = 52)THEN
22097: l_raise_business_event := OKL_API.G_TRUE;

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

22090: FETCH get_serv_cle_from_serv INTO l_serv_contract_id;
22091: CLOSE get_serv_cle_from_serv; */
22092: l_serv_contract_id := l_copied_id;
22093: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
22094: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
22095: END IF;
22096: ELSIF(l_line_style IS NOT NULL AND l_line_style = 52)THEN
22097: l_raise_business_event := OKL_API.G_TRUE;
22098: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;

Line 22099: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rcle_id_tab(i), l_parameter_list);

22095: END IF;
22096: ELSIF(l_line_style IS NOT NULL AND l_line_style = 52)THEN
22097: l_raise_business_event := OKL_API.G_TRUE;
22098: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;
22099: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, l_rcle_id_tab(i), l_parameter_list);
22100: END IF;
22101: END IF;
22102:
22103: -- check if the business event needs to be raised

Line 22109: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, l_copied_id, l_parameter_list);

22105: l_business_event_name IS NOT NULL )THEN
22106: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
22107: -- added to the parameter list here, than duplicating it in all the above if conditions
22108:
22109: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, l_copied_id, l_parameter_list);
22110: raise_business_event_rules
22111: (p_api_version => p_api_version,
22112: p_init_msg_list => p_init_msg_list,
22113: x_return_status => x_return_status,