55: BEGIN
56: --
57: -- Get the route id. Create a route if necessary.
58: --
59: hr_utility.set_location ('pay_database_items_pkg.create_db_item', 1);
60: hr_utility.trace ('p_name: ' || p_name);
61: hr_utility.trace ('p_description: ' || p_description);
62: hr_utility.trace ('p_data_type: ' || p_data_type);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
56: --
57: -- Get the route id. Create a route if necessary.
58: --
59: hr_utility.set_location ('pay_database_items_pkg.create_db_item', 1);
60: hr_utility.trace ('p_name: ' || p_name);
61: hr_utility.trace ('p_description: ' || p_description);
62: hr_utility.trace ('p_data_type: ' || p_data_type);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
57: -- Get the route id. Create a route if necessary.
58: --
59: hr_utility.set_location ('pay_database_items_pkg.create_db_item', 1);
60: hr_utility.trace ('p_name: ' || p_name);
61: hr_utility.trace ('p_description: ' || p_description);
62: hr_utility.trace ('p_data_type: ' || p_data_type);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
58: --
59: hr_utility.set_location ('pay_database_items_pkg.create_db_item', 1);
60: hr_utility.trace ('p_name: ' || p_name);
61: hr_utility.trace ('p_description: ' || p_description);
62: hr_utility.trace ('p_data_type: ' || p_data_type);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
59: hr_utility.set_location ('pay_database_items_pkg.create_db_item', 1);
60: hr_utility.trace ('p_name: ' || p_name);
61: hr_utility.trace ('p_description: ' || p_description);
62: hr_utility.trace ('p_data_type: ' || p_data_type);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
67: hr_utility.trace ('p_route_name: ' || p_route_name);
60: hr_utility.trace ('p_name: ' || p_name);
61: hr_utility.trace ('p_description: ' || p_description);
62: hr_utility.trace ('p_data_type: ' || p_data_type);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
67: hr_utility.trace ('p_route_name: ' || p_route_name);
68: hr_utility.trace ('p_route_description: ' || p_route_description);
61: hr_utility.trace ('p_description: ' || p_description);
62: hr_utility.trace ('p_data_type: ' || p_data_type);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
67: hr_utility.trace ('p_route_name: ' || p_route_name);
68: hr_utility.trace ('p_route_description: ' || p_route_description);
69: hr_utility.trace ('p_route_text: ' || p_route_text);
62: hr_utility.trace ('p_data_type: ' || p_data_type);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
67: hr_utility.trace ('p_route_name: ' || p_route_name);
68: hr_utility.trace ('p_route_description: ' || p_route_description);
69: hr_utility.trace ('p_route_text: ' || p_route_text);
70: hr_utility.trace ('p_context_name1: ' || p_context_name1);
63: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
67: hr_utility.trace ('p_route_name: ' || p_route_name);
68: hr_utility.trace ('p_route_description: ' || p_route_description);
69: hr_utility.trace ('p_route_text: ' || p_route_text);
70: hr_utility.trace ('p_context_name1: ' || p_context_name1);
71: hr_utility.trace ('p_context_name2: ' || p_context_name2);
64: hr_utility.trace ('p_definition_text: ' || p_definition_text);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
67: hr_utility.trace ('p_route_name: ' || p_route_name);
68: hr_utility.trace ('p_route_description: ' || p_route_description);
69: hr_utility.trace ('p_route_text: ' || p_route_text);
70: hr_utility.trace ('p_context_name1: ' || p_context_name1);
71: hr_utility.trace ('p_context_name2: ' || p_context_name2);
72: hr_utility.trace ('p_legislation_code: ' || p_legislation_code);
65: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
67: hr_utility.trace ('p_route_name: ' || p_route_name);
68: hr_utility.trace ('p_route_description: ' || p_route_description);
69: hr_utility.trace ('p_route_text: ' || p_route_text);
70: hr_utility.trace ('p_context_name1: ' || p_context_name1);
71: hr_utility.trace ('p_context_name2: ' || p_context_name2);
72: hr_utility.trace ('p_legislation_code: ' || p_legislation_code);
73: --
66: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
67: hr_utility.trace ('p_route_name: ' || p_route_name);
68: hr_utility.trace ('p_route_description: ' || p_route_description);
69: hr_utility.trace ('p_route_text: ' || p_route_text);
70: hr_utility.trace ('p_context_name1: ' || p_context_name1);
71: hr_utility.trace ('p_context_name2: ' || p_context_name2);
72: hr_utility.trace ('p_legislation_code: ' || p_legislation_code);
73: --
74: BEGIN
67: hr_utility.trace ('p_route_name: ' || p_route_name);
68: hr_utility.trace ('p_route_description: ' || p_route_description);
69: hr_utility.trace ('p_route_text: ' || p_route_text);
70: hr_utility.trace ('p_context_name1: ' || p_context_name1);
71: hr_utility.trace ('p_context_name2: ' || p_context_name2);
72: hr_utility.trace ('p_legislation_code: ' || p_legislation_code);
73: --
74: BEGIN
75: --
68: hr_utility.trace ('p_route_description: ' || p_route_description);
69: hr_utility.trace ('p_route_text: ' || p_route_text);
70: hr_utility.trace ('p_context_name1: ' || p_context_name1);
71: hr_utility.trace ('p_context_name2: ' || p_context_name2);
72: hr_utility.trace ('p_legislation_code: ' || p_legislation_code);
73: --
74: BEGIN
75: --
76: SELECT route_id
299: sysdate);
300: --
301: -- ELSE
302: --
303: -- hr_utility.trace('Database_item already exists, so not reinserted');
304: --
305: -- END IF;
306: --
307: END create_db_item;