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