591:
592: IF l_application_id = l_trans_appl_id THEN
593: l_event_name := G_EVENT_APPROVE_AME;
594:
595: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
596: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
597: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
598: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
592: IF l_application_id = l_trans_appl_id THEN
593: l_event_name := G_EVENT_APPROVE_AME;
594:
595: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
596: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
597: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
598: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
600: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
593: l_event_name := G_EVENT_APPROVE_AME;
594:
595: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
596: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
597: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
598: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
600: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
601: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
594:
595: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
596: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
597: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
598: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
600: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
601: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
602: --added by akrangan
595: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
596: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
597: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
598: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
600: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
601: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
602: --added by akrangan
603: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
596: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
597: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
598: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
600: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
601: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
602: --added by akrangan
603: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
604: ELSE
597: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
598: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
600: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
601: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
602: --added by akrangan
603: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
604: ELSE
605: OKL_API.set_message(p_app_name => G_APP_NAME,
599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
600: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
601: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
602: --added by akrangan
603: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
604: ELSE
605: OKL_API.set_message(p_app_name => G_APP_NAME,
606: p_msg_name => G_INVALID_APP);
607: RAISE OKL_API.G_EXCEPTION_ERROR;
609:
610: ELSIF l_approval_option = G_LEASE_FUNDING_APPROVAL_WF THEN
611: l_event_name := G_EVENT_APPROVE_WF;
612:
613: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
614: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
615: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
616: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
617: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
610: ELSIF l_approval_option = G_LEASE_FUNDING_APPROVAL_WF THEN
611: l_event_name := G_EVENT_APPROVE_WF;
612:
613: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
614: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
615: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
616: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
617: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
618: --added by akrangan
611: l_event_name := G_EVENT_APPROVE_WF;
612:
613: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
614: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
615: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
616: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
617: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
618: --added by akrangan
619: --wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
612:
613: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
614: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
615: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
616: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
617: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
618: --added by akrangan
619: --wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
620:
613: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);
614: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_number,l_parameter_list);
615: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
616: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
617: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
618: --added by akrangan
619: --wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
620:
621:
615: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
616: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
617: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
618: --added by akrangan
619: --wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
620:
621:
622:
623: ELSE
625: END IF; -- l_approval_option
626:
627: --Added by sechawla for bug 7594853
628: -- Set the User ID, Responsibility Id and Application Id as workflow attributes
629: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
630: --wf_event.AddParameterToList('ORG_ID',NVL(fnd_profile.value('ORG_ID'),-99),l_parameter_list);
631: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
632: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
633: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
626:
627: --Added by sechawla for bug 7594853
628: -- Set the User ID, Responsibility Id and Application Id as workflow attributes
629: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
630: --wf_event.AddParameterToList('ORG_ID',NVL(fnd_profile.value('ORG_ID'),-99),l_parameter_list);
631: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
632: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
633: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
634: --end sechawla for bug 7594853
627: --Added by sechawla for bug 7594853
628: -- Set the User ID, Responsibility Id and Application Id as workflow attributes
629: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
630: --wf_event.AddParameterToList('ORG_ID',NVL(fnd_profile.value('ORG_ID'),-99),l_parameter_list);
631: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
632: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
633: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
634: --end sechawla for bug 7594853
635:
628: -- Set the User ID, Responsibility Id and Application Id as workflow attributes
629: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
630: --wf_event.AddParameterToList('ORG_ID',NVL(fnd_profile.value('ORG_ID'),-99),l_parameter_list);
631: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
632: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
633: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
634: --end sechawla for bug 7594853
635:
636: -- Raise Event
629: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
630: --wf_event.AddParameterToList('ORG_ID',NVL(fnd_profile.value('ORG_ID'),-99),l_parameter_list);
631: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
632: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
633: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
634: --end sechawla for bug 7594853
635:
636: -- Raise Event
637: wf_event.RAISE(p_event_name => l_event_name,
633: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
634: --end sechawla for bug 7594853
635:
636: -- Raise Event
637: wf_event.RAISE(p_event_name => l_event_name,
638: p_event_key => l_key,
639: p_parameters => l_parameter_list);
640: l_parameter_list.DELETE;
641:
638: p_event_key => l_key,
639: p_parameters => l_parameter_list);
640: l_parameter_list.DELETE;
641:
642: /* move before raise WF event
643: l_update_funding_status(p_api_version => p_api_version,
644: p_init_msg_list => p_init_msg_list,
645: x_return_status => x_return_status,
646: x_msg_count => x_msg_count,