446:
447: IF l_application_id = l_trans_appl_id THEN
448: l_event_name := G_EVENT_APPROVE_AME;
449:
450: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
452: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
453: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
454: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
447: IF l_application_id = l_trans_appl_id THEN
448: l_event_name := G_EVENT_APPROVE_AME;
449:
450: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
452: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
453: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
454: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
448: l_event_name := G_EVENT_APPROVE_AME;
449:
450: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
452: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
453: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
454: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
449:
450: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
452: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
453: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
454: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
457: --added by akrangan
450: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
452: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
453: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
454: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
457: --added by akrangan
458: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
451: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
452: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
453: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
454: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
457: --added by akrangan
458: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
459:
452: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
453: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
454: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
457: --added by akrangan
458: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
459:
460: ELSE
454: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
457: --added by akrangan
458: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
459:
460: ELSE
461: OKL_API.set_message(p_app_name => G_APP_NAME,
462: p_msg_name => G_INVALID_APP);
470: LOOP
471: l_contract_num := c_fetch_k_number_rec.contract_number;
472: END LOOP;
473:
474: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
475: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
476: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
471: l_contract_num := c_fetch_k_number_rec.contract_number;
472: END LOOP;
473:
474: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
475: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
476: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
479: --added by akrangan
472: END LOOP;
473:
474: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
475: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
476: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
479: --added by akrangan
480: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
473:
474: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
475: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
476: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
479: --added by akrangan
480: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
481: ELSE
474: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
475: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
476: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
479: --added by akrangan
480: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
481: ELSE
482: RAISE OKL_API.G_EXCEPTION_ERROR;
476: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
479: --added by akrangan
480: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
481: ELSE
482: RAISE OKL_API.G_EXCEPTION_ERROR;
483: END IF; -- l_approval_option
484:
497: RAISE OKL_API.G_EXCEPTION_ERROR;
498: END IF;
499:
500: -- Raise Event
501: wf_event.RAISE(p_event_name => l_event_name,
502: p_event_key => l_key,
503: p_parameters => l_parameter_list);
504: l_parameter_list.DELETE;
505: