DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_SERIAL_CHECK

Line 890: 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);

886: l_to_number NUMBER;
887: l_errorcode NUMBER;
888: l_temp_boolean BOOLEAN;
889: BEGIN
890: 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);
891:
892: IF (p_dynamic_entry_flag = 1) THEN -- Dynamic entries are allowed
893: OPEN x_serials FOR
894: SELECT serial_number

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

1383: FROM mtl_cycle_count_headers
1384: WHERE cycle_count_header_id = p_cycle_count_header_id;
1385:
1386: l_temp_boolean :=
1387: mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix,
1388: l_quantity, l_from_number, l_to_number, l_errorcode);
1389:
1390: IF (p_unscheduled_entry = 1) THEN
1391: -- Unscheduled entries are allowed

Line 2194: 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);

2190: l_errorcode NUMBER;
2191: l_temp_boolean BOOLEAN;
2192: BEGIN
2193: IF (p_from_serial_number IS NOT NULL) THEN
2194: 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);
2195: ELSE
2196: l_prefix := '';
2197: END IF;
2198:

Line 2670: 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);

2666: l_to_number NUMBER;
2667: l_errorcode NUMBER;
2668: l_temp_boolean BOOLEAN;
2669: BEGIN
2670: 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);
2671: OPEN x_serial FOR
2672: SELECT DISTINCT serial_number
2673: , 'NULL'
2674: , 0