54: BEGIN
55: --
56: -- Get the route id. Create a route if necessary.
57: --
58: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
59: hr_utility.trace ('p_name: ' || p_name);
60: hr_utility.trace ('p_description: ' || p_description);
61: hr_utility.trace ('p_data_type: ' || p_data_type);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
55: --
56: -- Get the route id. Create a route if necessary.
57: --
58: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
59: hr_utility.trace ('p_name: ' || p_name);
60: hr_utility.trace ('p_description: ' || p_description);
61: hr_utility.trace ('p_data_type: ' || p_data_type);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
56: -- Get the route id. Create a route if necessary.
57: --
58: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
59: hr_utility.trace ('p_name: ' || p_name);
60: hr_utility.trace ('p_description: ' || p_description);
61: hr_utility.trace ('p_data_type: ' || p_data_type);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
57: --
58: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
59: hr_utility.trace ('p_name: ' || p_name);
60: hr_utility.trace ('p_description: ' || p_description);
61: hr_utility.trace ('p_data_type: ' || p_data_type);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
58: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
59: hr_utility.trace ('p_name: ' || p_name);
60: hr_utility.trace ('p_description: ' || p_description);
61: hr_utility.trace ('p_data_type: ' || p_data_type);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
66: hr_utility.trace ('p_route_name: ' || p_route_name);
59: hr_utility.trace ('p_name: ' || p_name);
60: hr_utility.trace ('p_description: ' || p_description);
61: hr_utility.trace ('p_data_type: ' || p_data_type);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
66: hr_utility.trace ('p_route_name: ' || p_route_name);
67: hr_utility.trace ('p_route_description: ' || p_route_description);
60: hr_utility.trace ('p_description: ' || p_description);
61: hr_utility.trace ('p_data_type: ' || p_data_type);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
66: hr_utility.trace ('p_route_name: ' || p_route_name);
67: hr_utility.trace ('p_route_description: ' || p_route_description);
68: hr_utility.trace ('p_route_text: ' || p_route_text);
61: hr_utility.trace ('p_data_type: ' || p_data_type);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
66: hr_utility.trace ('p_route_name: ' || p_route_name);
67: hr_utility.trace ('p_route_description: ' || p_route_description);
68: hr_utility.trace ('p_route_text: ' || p_route_text);
69: hr_utility.trace ('p_context_name1: ' || p_context_name1);
62: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
66: hr_utility.trace ('p_route_name: ' || p_route_name);
67: hr_utility.trace ('p_route_description: ' || p_route_description);
68: hr_utility.trace ('p_route_text: ' || p_route_text);
69: hr_utility.trace ('p_context_name1: ' || p_context_name1);
70: hr_utility.trace ('p_context_name2: ' || p_context_name2);
63: hr_utility.trace ('p_definition_text: ' || p_definition_text);
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
66: hr_utility.trace ('p_route_name: ' || p_route_name);
67: hr_utility.trace ('p_route_description: ' || p_route_description);
68: hr_utility.trace ('p_route_text: ' || p_route_text);
69: hr_utility.trace ('p_context_name1: ' || p_context_name1);
70: hr_utility.trace ('p_context_name2: ' || p_context_name2);
71: --
64: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
66: hr_utility.trace ('p_route_name: ' || p_route_name);
67: hr_utility.trace ('p_route_description: ' || p_route_description);
68: hr_utility.trace ('p_route_text: ' || p_route_text);
69: hr_utility.trace ('p_context_name1: ' || p_context_name1);
70: hr_utility.trace ('p_context_name2: ' || p_context_name2);
71: --
72: BEGIN
65: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
66: hr_utility.trace ('p_route_name: ' || p_route_name);
67: hr_utility.trace ('p_route_description: ' || p_route_description);
68: hr_utility.trace ('p_route_text: ' || p_route_text);
69: hr_utility.trace ('p_context_name1: ' || p_context_name1);
70: hr_utility.trace ('p_context_name2: ' || p_context_name2);
71: --
72: BEGIN
73: --
66: hr_utility.trace ('p_route_name: ' || p_route_name);
67: hr_utility.trace ('p_route_description: ' || p_route_description);
68: hr_utility.trace ('p_route_text: ' || p_route_text);
69: hr_utility.trace ('p_context_name1: ' || p_context_name1);
70: hr_utility.trace ('p_context_name2: ' || p_context_name2);
71: --
72: BEGIN
73: --
74: SELECT route_id