APPS.OKL_KBK_APPROVALS_WF dependencies on AME_CALLING_APPS

Line 252: FROM AME_CALLING_APPS B,

248: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)
249: IS
250: SELECT B.TRANSACTION_TYPE_ID,
251: B.FND_APPLICATION_ID
252: FROM AME_CALLING_APPS B,
253: AME_CALLING_APPS_TL T
254: WHERE B.APPLICATION_ID = T.APPLICATION_ID
255: AND T.LANGUAGE = 'US'
256: AND T.APPLICATION_NAME = c_trx_type;

Line 253: AME_CALLING_APPS_TL T

249: IS
250: SELECT B.TRANSACTION_TYPE_ID,
251: B.FND_APPLICATION_ID
252: FROM AME_CALLING_APPS B,
253: AME_CALLING_APPS_TL T
254: WHERE B.APPLICATION_ID = T.APPLICATION_ID
255: AND T.LANGUAGE = 'US'
256: AND T.APPLICATION_NAME = c_trx_type;
257:

Line 286: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;

282: l_key VARCHAR2(240);
283: l_event_name VARCHAR2(240);
284:
285: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
286: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
287: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
288:
289: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
290: l_chrv_id OKC_K_HEADERS_V.ID%TYPE := p_contract_id;

Line 287: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;

283: l_event_name VARCHAR2(240);
284:
285: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
286: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
287: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
288:
289: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
290: l_chrv_id OKC_K_HEADERS_V.ID%TYPE := p_contract_id;
291: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;