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