DBA Data[Home] [Help]

APPS.OKL_CREDIT_LINE_WF dependencies on AME_CALLING_APPS

Line 301: FROM AME_CALLING_APPS

297:
298: /* --commented for performance issue#5484903
299: SELECT transaction_type_id,
300: fnd_application_id
301: FROM AME_CALLING_APPS
302: WHERE application_name = c_trx_type; */
303:
304: CURSOR l_wf_item_key_csr IS
305: SELECT okl_wf_item_s.NEXTVAL item_key

Line 324: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;

320: l_parameter_list wf_parameter_list_t;
321: l_key VARCHAR2(240);
322: l_event_name VARCHAR2(240);
323: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
324: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
325: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
326: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
327: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;
328: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

Line 325: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;

321: l_key VARCHAR2(240);
322: l_event_name VARCHAR2(240);
323: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
324: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
325: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
326: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
327: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;
328: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
329: l_requester VARCHAR2(200);