48: );
49:
50: PROCEDURE open_period(
51: p_calling_module IN VARCHAR2
52: , p_date_tbl IN PO_TBL_DATE
53: , p_org_id_tbl IN PO_TBL_NUMBER
54: , p_entity_id_tbl IN PO_TBL_NUMBER
55: , p_entity_type IN VARCHAR2
56: , p_column_name IN VARCHAR2
134:
135: PROCEDURE no_timecards_exist(
136: p_calling_module IN VARCHAR2
137: , p_line_id_tbl IN PO_TBL_NUMBER
138: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
139: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
140: , p_column_name IN VARCHAR2
141: , p_message_name IN VARCHAR2
142: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
135: PROCEDURE no_timecards_exist(
136: p_calling_module IN VARCHAR2
137: , p_line_id_tbl IN PO_TBL_NUMBER
138: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
139: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
140: , p_column_name IN VARCHAR2
141: , p_message_name IN VARCHAR2
142: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
143: , x_result_type OUT NOCOPY VARCHAR2
179: );
180:
181: PROCEDURE start_date_le_end_date(
182: p_calling_module IN VARCHAR2
183: , p_start_date_tbl IN PO_TBL_DATE
184: , p_end_date_tbl IN PO_TBL_DATE
185: , p_entity_id_tbl IN PO_TBL_NUMBER
186: , p_entity_type IN VARCHAR2
187: , p_column_name IN VARCHAR2
180:
181: PROCEDURE start_date_le_end_date(
182: p_calling_module IN VARCHAR2
183: , p_start_date_tbl IN PO_TBL_DATE
184: , p_end_date_tbl IN PO_TBL_DATE
185: , p_entity_id_tbl IN PO_TBL_NUMBER
186: , p_entity_type IN VARCHAR2
187: , p_column_name IN VARCHAR2
188: , p_column_val_selector IN VARCHAR2
312:
313: --UCA Project - CLMR4 Changes Begin
314: PROCEDURE start_date_ge_sys_date(
315: p_calling_module IN VARCHAR2
316: , p_start_date_tbl IN PO_TBL_DATE
317: , p_entity_id_tbl IN PO_TBL_NUMBER
318: , p_entity_type IN VARCHAR2
319: , p_column_name IN VARCHAR2
320: , p_message_name IN VARCHAR2