462:
463: UPDATE MTL_CC_SERIAL_NUMBERS
464: SET
465: last_update_date = SYSDATE,
466: last_updated_by = fnd_global.user_id,
467: last_update_login = fnd_global.login_id,
468: number_of_counts = nvl(l_number_of_counts,0) + 1,
469: unit_status_current = l_unit_status_current,
470: unit_status_prior = l_unit_status_prior,
463: UPDATE MTL_CC_SERIAL_NUMBERS
464: SET
465: last_update_date = SYSDATE,
466: last_updated_by = fnd_global.user_id,
467: last_update_login = fnd_global.login_id,
468: number_of_counts = nvl(l_number_of_counts,0) + 1,
469: unit_status_current = l_unit_status_current,
470: unit_status_prior = l_unit_status_prior,
471: unit_status_first = l_unit_status_first,
505: ) VALUES (
506: l_cycle_count_entry_id,
507: p_serial_number,
508: SYSDATE,
509: FND_GLOBAL.USER_ID,
510: SYSDATE,
511: FND_GLOBAL.USER_ID,
512: FND_GLOBAL.LOGIN_ID,
513: l_number_of_counts,
507: p_serial_number,
508: SYSDATE,
509: FND_GLOBAL.USER_ID,
510: SYSDATE,
511: FND_GLOBAL.USER_ID,
512: FND_GLOBAL.LOGIN_ID,
513: l_number_of_counts,
514: l_unit_status_current,
515: l_unit_status_prior,
508: SYSDATE,
509: FND_GLOBAL.USER_ID,
510: SYSDATE,
511: FND_GLOBAL.USER_ID,
512: FND_GLOBAL.LOGIN_ID,
513: l_number_of_counts,
514: l_unit_status_current,
515: l_unit_status_prior,
516: l_unit_status_first,
544: ) VALUES (
545: p_inventory_item_id,
546: p_serial_number,
547: SYSDATE,
548: FND_GLOBAL.USER_ID,
549: SYSDATE,
550: FND_GLOBAL.USER_ID,
551: FND_GLOBAL.LOGIN_ID,
552: SYSDATE,
546: p_serial_number,
547: SYSDATE,
548: FND_GLOBAL.USER_ID,
549: SYSDATE,
550: FND_GLOBAL.USER_ID,
551: FND_GLOBAL.LOGIN_ID,
552: SYSDATE,
553: 1,
554: p_revision,
547: SYSDATE,
548: FND_GLOBAL.USER_ID,
549: SYSDATE,
550: FND_GLOBAL.USER_ID,
551: FND_GLOBAL.LOGIN_ID,
552: SYSDATE,
553: 1,
554: p_revision,
555: p_lot_number,