DBA Data[Home] [Help]

APPS.OKL_FUNDING_WF dependencies on WF_EVENT

Line 595: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);

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);

Line 596: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_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);

Line 597: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,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);

Line 598: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_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

Line 599: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);

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);

Line 600: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,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

Line 601: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,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
605: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 603: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_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,
606: p_msg_name => G_INVALID_APP);
607: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 613: wf_event.AddParameterToList(G_WF_ITM_FUNDING_ID,p_funding_id,l_parameter_list);

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);

Line 614: wf_event.AddParameterToList(G_WF_ITM_FUNDING_NUMBER,l_invoice_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

Line 615: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);

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);

Line 616: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_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:

Line 617: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);

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:

Line 619: --wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,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:
622:
623: ELSE

Line 629: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

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);

Line 630: --wf_event.AddParameterToList('ORG_ID',NVL(fnd_profile.value('ORG_ID'),-99),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

Line 631: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);

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:

Line 632: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);

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

Line 633: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);

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,

Line 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:

Line 642: /* move before raise WF event

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,