34: PROCEDURE Get_UID( X_pay_element_input_id IN OUT NUMBER) IS
35:
36: BEGIN
37:
38: SELECT cn_pay_element_inputs_s.nextval
39: INTO X_pay_element_input_id
40: FROM dual;
41:
42: END Get_UID;
304: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
305: l_tab_object_id cn_pay_element_inputs.tab_object_id%TYPE;
306: l_col_object_id cn_pay_element_inputs.col_object_id%TYPE;
307: l_line_number cn_pay_element_inputs.line_number%TYPE;
308: l_start_date cn_pay_element_inputs.start_date%TYPE;
309: l_end_date cn_pay_element_inputs.end_date%TYPE;
310:
311: l_attribute_category cn_pay_element_inputs.attribute_category%TYPE;
312: l_attribute1 cn_pay_element_inputs.attribute1%TYPE;