DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_SERIAL_CHECK

Line 827: l_temp_boolean := mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode);

823: l_to_number NUMBER;
824: l_errorcode NUMBER;
825: l_temp_boolean BOOLEAN;
826: BEGIN
827: l_temp_boolean := mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode);
828:
829: IF (p_dynamic_entry_flag = 1) THEN -- Dynamic entries are allowed
830: OPEN x_serials FOR
831: SELECT serial_number

Line 1324: mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix,

1320: FROM mtl_cycle_count_headers
1321: WHERE cycle_count_header_id = p_cycle_count_header_id;
1322:
1323: l_temp_boolean :=
1324: mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix,
1325: l_quantity, l_from_number, l_to_number, l_errorcode);
1326:
1327: IF (p_unscheduled_entry = 1) THEN
1328: -- Unscheduled entries are allowed

Line 2107: l_temp_boolean := mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode);

2103: l_errorcode NUMBER;
2104: l_temp_boolean BOOLEAN;
2105: BEGIN
2106: IF (p_from_serial_number IS NOT NULL) THEN
2107: l_temp_boolean := mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode);
2108: ELSE
2109: l_prefix := '';
2110: END IF;
2111:

Line 2583: l_temp_boolean := mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode);

2579: l_to_number NUMBER;
2580: l_errorcode NUMBER;
2581: l_temp_boolean BOOLEAN;
2582: BEGIN
2583: l_temp_boolean := mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode);
2584: OPEN x_serial FOR
2585: SELECT DISTINCT serial_number
2586: , 'NULL'
2587: , 0