DBA Data[Home] [Help]

APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_UTILITY

Line 911: -- l_obj_off varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);

907: v_start_date date;
908: v_end_date date;
909: v_proc varchar2(72) := g_package||'check_dates_update_evt';
910: --Modified for bug 11075903
911: -- l_obj_off varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);
912: --l_obj_act varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
913:
914: l_obj_off hr_lookups.meaning%type;
915: l_obj_act hr_lookups.meaning%type;

Line 912: --l_obj_act varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);

908: v_end_date date;
909: v_proc varchar2(72) := g_package||'check_dates_update_evt';
910: --Modified for bug 11075903
911: -- l_obj_off varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);
912: --l_obj_act varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
913:
914: l_obj_off hr_lookups.meaning%type;
915: l_obj_act hr_lookups.meaning%type;
916:

Line 954: l_obj_off := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);

950: If ota_general.check_par_child_dates_fun( p_start_date
951: , p_end_date
952: , v_start_date
953: , v_end_date ) then
954: l_obj_off := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);
955: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
956: --
957: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
958: fnd_message.set_token('OBJECT_NAME', l_obj_act );

Line 955: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);

951: , p_end_date
952: , v_start_date
953: , v_end_date ) then
954: l_obj_off := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);
955: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
956: --
957: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
958: fnd_message.set_token('OBJECT_NAME', l_obj_act );
959: fnd_message.set_token('CHILD_OBJECT', l_obj_off);