450:
451: IF l_application_id = l_trans_appl_id THEN
452: l_event_name := G_EVENT_APPROVE_AME;
453:
454: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
457: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
458: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
451: IF l_application_id = l_trans_appl_id THEN
452: l_event_name := G_EVENT_APPROVE_AME;
453:
454: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
457: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
458: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
459: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
452: l_event_name := G_EVENT_APPROVE_AME;
453:
454: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
457: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
458: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
459: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
460: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
453:
454: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
457: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
458: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
459: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
460: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
461: --added by akrangan
454: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
457: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
458: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
459: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
460: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
461: --added by akrangan
462: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
455: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
456: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
457: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
458: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
459: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
460: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
461: --added by akrangan
462: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
463:
456: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
457: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
458: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
459: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
460: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
461: --added by akrangan
462: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
463:
464: ELSE
458: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
459: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
460: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
461: --added by akrangan
462: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
463:
464: ELSE
465: OKL_API.set_message(p_app_name => G_APP_NAME,
466: p_msg_name => G_INVALID_APP);
474: LOOP
475: l_contract_num := c_fetch_k_number_rec.contract_number;
476: END LOOP;
477:
478: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
475: l_contract_num := c_fetch_k_number_rec.contract_number;
476: END LOOP;
477:
478: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
483: --added by akrangan
476: END LOOP;
477:
478: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
483: --added by akrangan
484: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
477:
478: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
483: --added by akrangan
484: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
485: ELSE
478: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
483: --added by akrangan
484: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
485: ELSE
486: RAISE OKL_API.G_EXCEPTION_ERROR;
480: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
483: --added by akrangan
484: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
485: ELSE
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF; -- l_approval_option
488:
501: RAISE OKL_API.G_EXCEPTION_ERROR;
502: END IF;
503:
504: -- Raise Event
505: wf_event.RAISE(p_event_name => l_event_name,
506: p_event_key => l_key,
507: p_parameters => l_parameter_list);
508: l_parameter_list.DELETE;
509: