[Home] [Help]
65:
66: PROCEDURE set_firstscan(p_firstscan BOOLEAN);
67:
68: /**
69: * This procedure inserts a lot into the MTL_LOT_NUMBERS table.
70: * It does all the necessary validation before inserting the lot.
71: * It derives the expiration date depending on the controls set
72: * for shelf_life_code and shelf_life_days for the item.
73: * Returns success if it is able to insert the lot.
252:
253: This is a procedure that accepts the lot attributes as input parameters.
254: This procedure validates some the input parameters like lot_number, expiration date,
255: INV attributes, C_ATTRIBUTES, N_ATTRIBUTES and D_ATTRIBUTES.
256: If all the validations go through fine, data is inserted into mtl_lot_numbers
257: */
258: -- This procedure has now be converted into a stub and it internally calls
259: -- the overloaded create_inv_lot procedure.
260:
354: /*
355: This is a procedure that accepts the lot attributes as input parameters.
356: This procedure validates some the input parameters like lot_number, expiration_date,
357: INV attributes, C_ATTRIBUTES, N_ATTRIBUTES and D_ATTRIBUTES.
358: If all the validations go through fine, data is updated in mtl_lot_numbers table
359: */
360: PROCEDURE update_inv_lot(
361: x_return_status OUT NOCOPY VARCHAR2
362: , x_msg_count OUT NOCOPY NUMBER
403: /*
404: This is a procedure that accepts the lot record as input parameters.
405: This procedure validates some the input parameters like lot_number, expiration_date,
406: INV attributes, C_ATTRIBUTES, N_ATTRIBUTES and D_ATTRIBUTES.
407: If all the validations go through fine, data is updated in mtl_lot_numbers table
408: */
409:
410: PROCEDURE update_inv_lot(
411: x_return_status OUT NOCOPY VARCHAR2
410: PROCEDURE update_inv_lot(
411: x_return_status OUT NOCOPY VARCHAR2
412: , x_msg_count OUT NOCOPY NUMBER
413: , x_msg_data OUT NOCOPY VARCHAR2
414: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
415: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
416: , p_source IN NUMBER
417: , p_api_version IN NUMBER
418: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
411: x_return_status OUT NOCOPY VARCHAR2
412: , x_msg_count OUT NOCOPY NUMBER
413: , x_msg_data OUT NOCOPY VARCHAR2
414: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
415: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
416: , p_source IN NUMBER
417: , p_api_version IN NUMBER
418: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
419: , p_commit IN VARCHAR2 := fnd_api.g_false);
532:
533:
534: /* INVCONV, NSRIVAST, Start*/
535: -- This is the overloaded procedure for the exisiting Create_Inv_Lot procedure.
536: -- It inserts a record in mtl_lot_numbers table. Apart from this, it creates a
537: -- UOM Conversion record based on the value of copy_lot_uom_conversion.
538:
539: PROCEDURE Create_Inv_lot(
540: x_return_status OUT NOCOPY VARCHAR2
540: x_return_status OUT NOCOPY VARCHAR2
541: , x_msg_count OUT NOCOPY NUMBER
542: , x_msg_data OUT NOCOPY VARCHAR2
543: , x_row_id OUT NOCOPY ROWID
544: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
545: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
546: , p_source IN NUMBER
547: , p_api_version IN NUMBER
548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
541: , x_msg_count OUT NOCOPY NUMBER
542: , x_msg_data OUT NOCOPY VARCHAR2
543: , x_row_id OUT NOCOPY ROWID
544: , x_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
545: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
546: , p_source IN NUMBER
547: , p_api_version IN NUMBER
548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
549: , p_commit IN VARCHAR2 := fnd_api.g_false