707:
708: UPDATE MTL_CC_SERIAL_NUMBERS
709: SET
710: last_update_date = SYSDATE,
711: last_updated_by = fnd_global.user_id,
712: last_update_login = fnd_global.login_id,
713: -- number_of_counts = nvl(l_number_of_counts,0) + 1, commented for bug 9681558
714: unit_status_current = l_unit_status_current,
715: unit_status_prior = l_unit_status_prior,
708: UPDATE MTL_CC_SERIAL_NUMBERS
709: SET
710: last_update_date = SYSDATE,
711: last_updated_by = fnd_global.user_id,
712: last_update_login = fnd_global.login_id,
713: -- number_of_counts = nvl(l_number_of_counts,0) + 1, commented for bug 9681558
714: unit_status_current = l_unit_status_current,
715: unit_status_prior = l_unit_status_prior,
716: unit_status_first = l_unit_status_first,
750: ) VALUES (
751: l_cycle_count_entry_id,
752: p_serial_number,
753: SYSDATE,
754: FND_GLOBAL.USER_ID,
755: SYSDATE,
756: FND_GLOBAL.USER_ID,
757: FND_GLOBAL.LOGIN_ID,
758: l_number_of_counts,
752: p_serial_number,
753: SYSDATE,
754: FND_GLOBAL.USER_ID,
755: SYSDATE,
756: FND_GLOBAL.USER_ID,
757: FND_GLOBAL.LOGIN_ID,
758: l_number_of_counts,
759: l_unit_status_current,
760: l_unit_status_prior,
753: SYSDATE,
754: FND_GLOBAL.USER_ID,
755: SYSDATE,
756: FND_GLOBAL.USER_ID,
757: FND_GLOBAL.LOGIN_ID,
758: l_number_of_counts,
759: l_unit_status_current,
760: l_unit_status_prior,
761: l_unit_status_first,
860: ) VALUES (
861: p_inventory_item_id,
862: p_serial_number,
863: SYSDATE,
864: FND_GLOBAL.USER_ID,
865: SYSDATE,
866: FND_GLOBAL.USER_ID,
867: FND_GLOBAL.LOGIN_ID,
868: SYSDATE,
862: p_serial_number,
863: SYSDATE,
864: FND_GLOBAL.USER_ID,
865: SYSDATE,
866: FND_GLOBAL.USER_ID,
867: FND_GLOBAL.LOGIN_ID,
868: SYSDATE,
869: 1,
870: p_revision,
863: SYSDATE,
864: FND_GLOBAL.USER_ID,
865: SYSDATE,
866: FND_GLOBAL.USER_ID,
867: FND_GLOBAL.LOGIN_ID,
868: SYSDATE,
869: 1,
870: p_revision,
871: p_lot_number,