61: BEGIN
62: --
63: -- Get the route id. Create a route if necessary.
64: --
65: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
66: hr_utility.trace ('p_name: ' || p_name);
67: hr_utility.trace ('p_description: ' || p_description);
68: hr_utility.trace ('p_data_type: ' || p_data_type);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
62: --
63: -- Get the route id. Create a route if necessary.
64: --
65: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
66: hr_utility.trace ('p_name: ' || p_name);
67: hr_utility.trace ('p_description: ' || p_description);
68: hr_utility.trace ('p_data_type: ' || p_data_type);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
63: -- Get the route id. Create a route if necessary.
64: --
65: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
66: hr_utility.trace ('p_name: ' || p_name);
67: hr_utility.trace ('p_description: ' || p_description);
68: hr_utility.trace ('p_data_type: ' || p_data_type);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
64: --
65: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
66: hr_utility.trace ('p_name: ' || p_name);
67: hr_utility.trace ('p_description: ' || p_description);
68: hr_utility.trace ('p_data_type: ' || p_data_type);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
65: hr_utility.set_location ('pay_us_create_col_dbi.create_table_column_dbi', 1);
66: hr_utility.trace ('p_name: ' || p_name);
67: hr_utility.trace ('p_description: ' || p_description);
68: hr_utility.trace ('p_data_type: ' || p_data_type);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
73: hr_utility.trace ('p_route_name: ' || p_route_name);
66: hr_utility.trace ('p_name: ' || p_name);
67: hr_utility.trace ('p_description: ' || p_description);
68: hr_utility.trace ('p_data_type: ' || p_data_type);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
73: hr_utility.trace ('p_route_name: ' || p_route_name);
74: hr_utility.trace ('p_route_description: ' || p_route_description);
67: hr_utility.trace ('p_description: ' || p_description);
68: hr_utility.trace ('p_data_type: ' || p_data_type);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
73: hr_utility.trace ('p_route_name: ' || p_route_name);
74: hr_utility.trace ('p_route_description: ' || p_route_description);
75: hr_utility.trace ('p_route_text: ' || p_route_text);
68: hr_utility.trace ('p_data_type: ' || p_data_type);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
73: hr_utility.trace ('p_route_name: ' || p_route_name);
74: hr_utility.trace ('p_route_description: ' || p_route_description);
75: hr_utility.trace ('p_route_text: ' || p_route_text);
76: hr_utility.trace ('p_context_name1: ' || p_context_name1);
69: hr_utility.trace ('p_null_allowed: ' || p_null_allowed);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
73: hr_utility.trace ('p_route_name: ' || p_route_name);
74: hr_utility.trace ('p_route_description: ' || p_route_description);
75: hr_utility.trace ('p_route_text: ' || p_route_text);
76: hr_utility.trace ('p_context_name1: ' || p_context_name1);
77: hr_utility.trace ('p_context_name2: ' || p_context_name2);
70: hr_utility.trace ('p_definition_text: ' || p_definition_text);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
73: hr_utility.trace ('p_route_name: ' || p_route_name);
74: hr_utility.trace ('p_route_description: ' || p_route_description);
75: hr_utility.trace ('p_route_text: ' || p_route_text);
76: hr_utility.trace ('p_context_name1: ' || p_context_name1);
77: hr_utility.trace ('p_context_name2: ' || p_context_name2);
78: hr_utility.trace ('p_context_name3: ' || p_context_name3);
71: hr_utility.trace ('p_user_entity_name: ' || p_user_entity_name);
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
73: hr_utility.trace ('p_route_name: ' || p_route_name);
74: hr_utility.trace ('p_route_description: ' || p_route_description);
75: hr_utility.trace ('p_route_text: ' || p_route_text);
76: hr_utility.trace ('p_context_name1: ' || p_context_name1);
77: hr_utility.trace ('p_context_name2: ' || p_context_name2);
78: hr_utility.trace ('p_context_name3: ' || p_context_name3);
79: --
72: hr_utility.trace ('p_user_entity_description: ' || p_user_entity_description);
73: hr_utility.trace ('p_route_name: ' || p_route_name);
74: hr_utility.trace ('p_route_description: ' || p_route_description);
75: hr_utility.trace ('p_route_text: ' || p_route_text);
76: hr_utility.trace ('p_context_name1: ' || p_context_name1);
77: hr_utility.trace ('p_context_name2: ' || p_context_name2);
78: hr_utility.trace ('p_context_name3: ' || p_context_name3);
79: --
80: BEGIN
73: hr_utility.trace ('p_route_name: ' || p_route_name);
74: hr_utility.trace ('p_route_description: ' || p_route_description);
75: hr_utility.trace ('p_route_text: ' || p_route_text);
76: hr_utility.trace ('p_context_name1: ' || p_context_name1);
77: hr_utility.trace ('p_context_name2: ' || p_context_name2);
78: hr_utility.trace ('p_context_name3: ' || p_context_name3);
79: --
80: BEGIN
81: --
74: hr_utility.trace ('p_route_description: ' || p_route_description);
75: hr_utility.trace ('p_route_text: ' || p_route_text);
76: hr_utility.trace ('p_context_name1: ' || p_context_name1);
77: hr_utility.trace ('p_context_name2: ' || p_context_name2);
78: hr_utility.trace ('p_context_name3: ' || p_context_name3);
79: --
80: BEGIN
81: --
82: SELECT route_id