DBA Data[Home] [Help]

APPS.OKC_RENEW_PVT dependencies on FND_USER

Line 2465: is select fnd.user_name from okx_resources_v res, fnd_user fnd where

2461: is select pdf_id from okc_k_processes kp, okc_process_defs_b pd where
2462: kp.chr_id=p_chr_id and kp.pdf_id=pd.id and pd.usage='APPROVE';
2463:
2464: CURSOR cur_user(p_user_id number)
2465: is select fnd.user_name from okx_resources_v res, fnd_user fnd where
2466: fnd.user_id=res.user_id and res.id1=p_user_id;
2467:
2468: CURSOR cur_header_aa IS
2469: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code

Line 2466: fnd.user_id=res.user_id and res.id1=p_user_id;

2462: kp.chr_id=p_chr_id and kp.pdf_id=pd.id and pd.usage='APPROVE';
2463:
2464: CURSOR cur_user(p_user_id number)
2465: is select fnd.user_name from okx_resources_v res, fnd_user fnd where
2466: fnd.user_id=res.user_id and res.id1=p_user_id;
2467:
2468: CURSOR cur_header_aa IS
2469: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
2470: FROM OKC_K_HEADERS_B K,

Line 2502: l_user_name fnd_user.user_name%type :=OKC_API.G_MISS_CHAR;

2498: cur_header_rec cur_header%rowtype;
2499:
2500: --FUNCTION notify(p_msg_tbl okc_async_pvt.par_tbl_typ,p_user varchar2) RETURN varchar2 IS
2501: FUNCTION notify(p_user varchar2) RETURN varchar2 IS
2502: l_user_name fnd_user.user_name%type :=OKC_API.G_MISS_CHAR;
2503: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
2504: l_exception_stop exception;
2505: l_proc varchar2(4000);
2506: l_api_name Varchar2(30) := 'notify';