406: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)
407: IS
408: SELECT B.TRANSACTION_TYPE_ID,
409: B.FND_APPLICATION_ID
410: FROM AME_CALLING_APPS B,
411: AME_CALLING_APPS_TL T
412: WHERE B.APPLICATION_ID = T.APPLICATION_ID
413: AND T.LANGUAGE = 'US'
414: AND T.APPLICATION_NAME = c_trx_type;
407: IS
408: SELECT B.TRANSACTION_TYPE_ID,
409: B.FND_APPLICATION_ID
410: FROM AME_CALLING_APPS B,
411: AME_CALLING_APPS_TL T
412: WHERE B.APPLICATION_ID = T.APPLICATION_ID
413: AND T.LANGUAGE = 'US'
414: AND T.APPLICATION_NAME = c_trx_type;
415:
433: l_key VARCHAR2(240);
434: l_event_name VARCHAR2(240);
435:
436: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
437: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
438: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
439:
440: l_invoice_number OKL_TRX_AP_INVOICES_B.VENDOR_INVOICE_NUMBER%TYPE;
441: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
434: l_event_name VARCHAR2(240);
435:
436: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
437: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
438: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
439:
440: l_invoice_number OKL_TRX_AP_INVOICES_B.VENDOR_INVOICE_NUMBER%TYPE;
441: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
442: