396:
397: ===========================================================================*/
398:
399: PROCEDURE derive_employee_info (
400: p_emp_record IN OUT NOCOPY RCV_SHIPMENT_OBJECT_SV.Employee_id_record_type) IS
401:
402: cid INTEGER;
403: rows_processed INTEGER;
404: sql_str VARCHAR2(2000);
515:
516: ===========================================================================*/
517:
518: PROCEDURE validate_employee_info (
519: p_emp_record IN OUT NOCOPY RCV_SHIPMENT_OBJECT_SV.Employee_id_record_type) IS
520:
521: X_cid INTEGER;
522: X_rows_processed INTEGER;
523: X_sql_str VARCHAR2(2000);