216:
217: /* add validation here */
218: /* get who column information */
219: SELECT Sysdate INTO l_date FROM dual;
220: l_user_id := fnd_global.user_id;
221: l_login_id := fnd_global.login_id;
222:
223: validate_input
224: (
217: /* add validation here */
218: /* get who column information */
219: SELECT Sysdate INTO l_date FROM dual;
220: l_user_id := fnd_global.user_id;
221: l_login_id := fnd_global.login_id;
222:
223: validate_input
224: (
225: x_return_status => x_return_status
587: end if;
588:
589: /* get who column information */
590: SELECT Sysdate INTO l_date FROM dual;
591: l_user_id := fnd_global.user_id;
592: l_login_id := fnd_global.login_id;
593:
594: /* call the table handler to do the update */
595: wms_restrictions_pkg.update_row
588:
589: /* get who column information */
590: SELECT Sysdate INTO l_date FROM dual;
591: l_user_id := fnd_global.user_id;
592: l_login_id := fnd_global.login_id;
593:
594: /* call the table handler to do the update */
595: wms_restrictions_pkg.update_row
596: (