560:
561: IF l_application_id = l_trans_appl_id THEN
562: l_event_name := G_EVENT_APPROVE_AME;
563:
564: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
565: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
566: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
567: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
568: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
561: IF l_application_id = l_trans_appl_id THEN
562: l_event_name := G_EVENT_APPROVE_AME;
563:
564: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
565: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
566: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
567: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
568: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
569: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
562: l_event_name := G_EVENT_APPROVE_AME;
563:
564: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
565: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
566: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
567: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
568: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
569: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
570: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
563:
564: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
565: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
566: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
567: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
568: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
569: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
570: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
571: --added by akrangan
564: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
565: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
566: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
567: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
568: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
569: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
570: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
571: --added by akrangan
572: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
565: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
566: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
567: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
568: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
569: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
570: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
571: --added by akrangan
572: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
573: ELSE
566: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
567: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
568: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
569: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
570: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
571: --added by akrangan
572: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
573: ELSE
574: OKL_API.set_message(p_app_name => G_APP_NAME,
568: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
569: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
570: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
571: --added by akrangan
572: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
573: ELSE
574: OKL_API.set_message(p_app_name => G_APP_NAME,
575: p_msg_name => G_INVALID_APP);
576: RAISE OKL_API.G_EXCEPTION_ERROR;
578:
579: ELSIF l_approval_option = G_LEASE_FUNDING_APPROVAL_WF THEN
580: l_event_name := G_EVENT_APPROVE_WF;
581:
582: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
583: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
584: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
585: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
586: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
579: ELSIF l_approval_option = G_LEASE_FUNDING_APPROVAL_WF THEN
580: l_event_name := G_EVENT_APPROVE_WF;
581:
582: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
583: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
584: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
585: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
586: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
587: --added by akrangan
580: l_event_name := G_EVENT_APPROVE_WF;
581:
582: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
583: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
584: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
585: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
586: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
587: --added by akrangan
588: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
581:
582: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
583: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
584: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
585: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
586: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
587: --added by akrangan
588: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
589:
582: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
583: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
584: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
585: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
586: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
587: --added by akrangan
588: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
589:
590: ELSE
584: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
585: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
586: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
587: --added by akrangan
588: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
589:
590: ELSE
591: RAISE OKL_API.G_EXCEPTION_ERROR;
592: END IF; -- l_approval_option
591: RAISE OKL_API.G_EXCEPTION_ERROR;
592: END IF; -- l_approval_option
593:
594: -- Raise Event
595: wf_event.RAISE(p_event_name => l_event_name,
596: p_event_key => l_key,
597: p_parameters => l_parameter_list);
598: l_parameter_list.DELETE;
599:
596: p_event_key => l_key,
597: p_parameters => l_parameter_list);
598: l_parameter_list.DELETE;
599:
600: /* move before raise WF event
601: l_update_funding_status(p_api_version => p_api_version,
602: p_init_msg_list => p_init_msg_list,
603: x_return_status => x_return_status,
604: x_msg_count => x_msg_count,