APPS.FFDICT dependencies on FF_ROUTE_PARAMETER_VALUES

Line 2401: insert into ff_route_parameter_values

2397: hr_utility.set_location('ffdict.create_global_dbitem',8);
2398: --
2399: -- insert parameter value for this user entity. Don't forget to add quotes
2400: -- for parameter value (global name)
2401: insert into ff_route_parameter_values
2402: (route_parameter_id,
2403: user_entity_id,
2404: value,
2405: created_by,

Line 2463: -- child records in ff_database_items and ff_route_parameter_values

2459: -- set error tracking information
2460: hr_utility.set_location('ffdict.delete_global_dbitem',1);
2461: --
2462: -- Delete user entity created for this global with a cascade delete of
2463: -- child records in ff_database_items and ff_route_parameter_values
2464: --
2465: delete from ff_user_entities
2466: where creator_id = p_global_id
2467: and creator_type = 'S';

Line 2689: delete from ff_route_parameter_values where user_entity_id= l_pur_del(i).user_entity_id;

2685: delete from ff_database_items where user_entity_id= l_pur_del(i).user_entity_id;
2686: clear_ue_details;
2687: end if;
2688: close c_pur_del ;
2689: delete from ff_route_parameter_values where user_entity_id= l_pur_del(i).user_entity_id;
2690: end loop ;
2691: l_pur_del.delete;
2692: hr_utility.set_location('Leaving -'||l_proc,50 ) ;
2693: exception