DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on INV_LOT_API_PUB

Line 3427: l_invattr_tbl inv_lot_api_pub.char_tbl;

3423: x_lot_attr_entered NUMBER:=0;
3424: l_status_id NUMBER;
3425:
3426: lot_attributes_rec lot_attributes_rec_type;
3427: l_invattr_tbl inv_lot_api_pub.char_tbl;
3428: l_Cattr_tbl inv_lot_api_pub.char_tbl;
3429: l_Nattr_tbl inv_lot_api_pub.number_tbl;
3430: l_Dattr_tbl inv_lot_api_pub.date_tbl;
3431:

Line 3428: l_Cattr_tbl inv_lot_api_pub.char_tbl;

3424: l_status_id NUMBER;
3425:
3426: lot_attributes_rec lot_attributes_rec_type;
3427: l_invattr_tbl inv_lot_api_pub.char_tbl;
3428: l_Cattr_tbl inv_lot_api_pub.char_tbl;
3429: l_Nattr_tbl inv_lot_api_pub.number_tbl;
3430: l_Dattr_tbl inv_lot_api_pub.date_tbl;
3431:
3432: l_qoh Number;

Line 3429: l_Nattr_tbl inv_lot_api_pub.number_tbl;

3425:
3426: lot_attributes_rec lot_attributes_rec_type;
3427: l_invattr_tbl inv_lot_api_pub.char_tbl;
3428: l_Cattr_tbl inv_lot_api_pub.char_tbl;
3429: l_Nattr_tbl inv_lot_api_pub.number_tbl;
3430: l_Dattr_tbl inv_lot_api_pub.date_tbl;
3431:
3432: l_qoh Number;
3433: l_atr Number;

Line 3430: l_Dattr_tbl inv_lot_api_pub.date_tbl;

3426: lot_attributes_rec lot_attributes_rec_type;
3427: l_invattr_tbl inv_lot_api_pub.char_tbl;
3428: l_Cattr_tbl inv_lot_api_pub.char_tbl;
3429: l_Nattr_tbl inv_lot_api_pub.number_tbl;
3430: l_Dattr_tbl inv_lot_api_pub.date_tbl;
3431:
3432: l_qoh Number;
3433: l_atr Number;
3434: l_att Number;

Line 4192: inv_lot_api_pub.Update_inv_lot(

4188: /* Updating lot attributes when resulting lot is one of the existing lots */
4189:
4190: IF (x_lot_exists='Y' AND l_intf_rec_found) THEN
4191:
4192: inv_lot_api_pub.Update_inv_lot(
4193: x_return_status => x_return_status,
4194: x_msg_count => x_msg_count,
4195: x_msg_data => x_err_msg,
4196: p_inventory_item_id => rlot.inventory_item_id,

Line 4691: x_invattr_tbl IN inv_lot_api_pub.char_tbl,

4687: X_Transaction_Date IN DATE,
4688: X_Source_Line_Id IN NUMBER,
4689: X_Header_Id IN NUMBER, -- added by Bala.
4690: x_lot_attributes_rec IN lot_attributes_rec_type, -- added by sisankar for bug 4920235
4691: x_invattr_tbl IN inv_lot_api_pub.char_tbl,
4692: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,
4693: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,
4694: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,
4695: x_err_code OUT NOCOPY NUMBER ,

Line 4692: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,

4688: X_Source_Line_Id IN NUMBER,
4689: X_Header_Id IN NUMBER, -- added by Bala.
4690: x_lot_attributes_rec IN lot_attributes_rec_type, -- added by sisankar for bug 4920235
4691: x_invattr_tbl IN inv_lot_api_pub.char_tbl,
4692: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,
4693: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,
4694: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,
4695: x_err_code OUT NOCOPY NUMBER ,
4696: x_err_msg OUT NOCOPY VARCHAR2) IS

Line 4693: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,

4689: X_Header_Id IN NUMBER, -- added by Bala.
4690: x_lot_attributes_rec IN lot_attributes_rec_type, -- added by sisankar for bug 4920235
4691: x_invattr_tbl IN inv_lot_api_pub.char_tbl,
4692: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,
4693: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,
4694: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,
4695: x_err_code OUT NOCOPY NUMBER ,
4696: x_err_msg OUT NOCOPY VARCHAR2) IS
4697:

Line 4694: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,

4690: x_lot_attributes_rec IN lot_attributes_rec_type, -- added by sisankar for bug 4920235
4691: x_invattr_tbl IN inv_lot_api_pub.char_tbl,
4692: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,
4693: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,
4694: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,
4695: x_err_code OUT NOCOPY NUMBER ,
4696: x_err_msg OUT NOCOPY VARCHAR2) IS
4697:
4698: X_Temp_Id NUMBER;