APPS.OKL_AUTO_INSURANCE_PVT dependencies on FND_PROFILE_OPTIONS_TL

Line 397: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;

393: SELECT USER_PROFILE_OPTION_NAME
394: FROM FND_PROFILE_OPTIONS_VL
395: WHERE PROFILE_OPTION_NAME = p_profile_code;
396:
397: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;
398:
399: BEGIN
400: fnd_profile.get('OKLINNTCINSEXPREQ',ls_reminder_yn);
401: fnd_profile.get('OKLINNTCINSEXP',ls_reminder_days);

Line 770: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;

766: SELECT USER_PROFILE_OPTION_NAME
767: FROM FND_PROFILE_OPTIONS_VL
768: WHERE PROFILE_OPTION_NAME = p_profile_code;
769:
770: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;
771:
772: lx_email varchar2(240);
773: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;
774: l_msg_count NUMBER ;

Line 1050: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;

1046: CURSOR l_profile_name_csr(p_profile_code IN VARCHAR2) IS
1047: SELECT USER_PROFILE_OPTION_NAME
1048: FROM FND_PROFILE_OPTIONS_VL
1049: WHERE PROFILE_OPTION_NAME = p_profile_code;
1050: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;
1051:
1052: BEGIN
1053:
1054: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'-------------------------------------------------------------');