441:
442: IF l_application_id = l_trans_appl_id THEN
443: l_event_name := G_EVENT_APPROVE_AME;
444:
445: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
446: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
447: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
442: IF l_application_id = l_trans_appl_id THEN
443: l_event_name := G_EVENT_APPROVE_AME;
444:
445: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
446: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
447: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
443: l_event_name := G_EVENT_APPROVE_AME;
444:
445: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
446: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
447: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
444:
445: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
446: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
447: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
452: --added by akrangan
445: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
446: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
447: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
452: --added by akrangan
453: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
446: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
447: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
452: --added by akrangan
453: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
454:
447: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
452: --added by akrangan
453: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
454:
455: ELSE
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
452: --added by akrangan
453: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
454:
455: ELSE
456: OKL_API.set_message(p_app_name => G_APP_NAME,
457: p_msg_name => G_INVALID_APP);
465: LOOP
466: l_contract_num := c_fetch_k_number_rec.contract_number;
467: END LOOP;
468:
469: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
470: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
471: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
472: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
473: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
466: l_contract_num := c_fetch_k_number_rec.contract_number;
467: END LOOP;
468:
469: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
470: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
471: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
472: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
473: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
474: --added by akrangan
467: END LOOP;
468:
469: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
470: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
471: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
472: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
473: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
474: --added by akrangan
475: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
468:
469: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
470: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
471: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
472: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
473: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
474: --added by akrangan
475: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
476: --added by jjuneja for Bug# 15991081
469: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
470: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
471: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
472: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
473: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
474: --added by akrangan
475: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
476: --added by jjuneja for Bug# 15991081
477: wf_event.AddParameterToList(G_WF_ITM_FROM_ROLE,l_requester ,l_parameter_list);
471: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
472: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
473: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
474: --added by akrangan
475: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
476: --added by jjuneja for Bug# 15991081
477: wf_event.AddParameterToList(G_WF_ITM_FROM_ROLE,l_requester ,l_parameter_list);
478: ELSE
479: RAISE OKL_API.G_EXCEPTION_ERROR;
473: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
474: --added by akrangan
475: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
476: --added by jjuneja for Bug# 15991081
477: wf_event.AddParameterToList(G_WF_ITM_FROM_ROLE,l_requester ,l_parameter_list);
478: ELSE
479: RAISE OKL_API.G_EXCEPTION_ERROR;
480: END IF; -- l_approval_option
481:
494: RAISE OKL_API.G_EXCEPTION_ERROR;
495: END IF;
496:
497: -- Raise Event
498: wf_event.RAISE(p_event_name => l_event_name,
499: p_event_key => l_key,
500: p_parameters => l_parameter_list);
501: l_parameter_list.DELETE;
502: