417:
418: IF l_application_id = l_trans_appl_id THEN
419: l_event_name := G_EVENT_APPROVE_AME;
420:
421: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
422: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
423: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
424: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
425: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
418: IF l_application_id = l_trans_appl_id THEN
419: l_event_name := G_EVENT_APPROVE_AME;
420:
421: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
422: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
423: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
424: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
425: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
426: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
419: l_event_name := G_EVENT_APPROVE_AME;
420:
421: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
422: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
423: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
424: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
425: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
426: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
427: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
420:
421: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
422: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
423: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
424: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
425: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
426: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
427: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
428: --added by akrangan
421: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_contract_id,l_parameter_list);
422: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
423: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
424: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
425: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
426: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
427: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
428: --added by akrangan
429: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
422: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_NUMBER,l_contract_num,l_parameter_list);
423: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
424: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
425: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
426: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
427: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
428: --added by akrangan
429: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
430:
423: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
424: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
425: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
426: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
427: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
428: --added by akrangan
429: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
430:
431: ELSE
425: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
426: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
427: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
428: --added by akrangan
429: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
430:
431: ELSE
432: OKL_API.set_message(p_app_name => G_APP_NAME,
433: p_msg_name => G_INVALID_APP);
441: LOOP
442: l_contract_num := c_fetch_k_number_rec.contract_number;
443: END LOOP;
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_REQUESTER,l_requester,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
442: l_contract_num := c_fetch_k_number_rec.contract_number;
443: END LOOP;
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_REQUESTER,l_requester,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: --added by akrangan
443: END LOOP;
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_REQUESTER,l_requester,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: --added by akrangan
451: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_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_REQUESTER,l_requester,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: --added by akrangan
451: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
452: ELSE
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_REQUESTER,l_requester,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: --added by akrangan
451: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
452: ELSE
453: RAISE OKL_API.G_EXCEPTION_ERROR;
447: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
448: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: --added by akrangan
451: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
452: ELSE
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF; -- l_approval_option
455:
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;
470:
471: -- Raise Event
472: wf_event.RAISE(p_event_name => l_event_name,
473: p_event_key => l_key,
474: p_parameters => l_parameter_list);
475: l_parameter_list.DELETE;
476: