175:
176: /* add validation here */
177: /* get who column information */
178: SELECT Sysdate INTO l_date FROM dual;
179: l_user_id := fnd_global.user_id;
180: l_login_id := fnd_global.login_id;
181:
182: validate_input
183: (
176: /* add validation here */
177: /* get who column information */
178: SELECT Sysdate INTO l_date FROM dual;
179: l_user_id := fnd_global.user_id;
180: l_login_id := fnd_global.login_id;
181:
182: validate_input
183: (
184: x_return_status => x_return_status
476: end if;
477:
478: /* get who column information */
479: SELECT Sysdate INTO l_date FROM dual;
480: l_user_id := fnd_global.user_id;
481: l_login_id := fnd_global.login_id;
482:
483: /* call the table handler to do the update */
484: wms_sort_criteria_pkg.update_row
477:
478: /* get who column information */
479: SELECT Sysdate INTO l_date FROM dual;
480: l_user_id := fnd_global.user_id;
481: l_login_id := fnd_global.login_id;
482:
483: /* call the table handler to do the update */
484: wms_sort_criteria_pkg.update_row
485: (