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 4523: x_invattr_tbl IN inv_lot_api_pub.char_tbl,

4519: X_Transaction_Date IN DATE,
4520: X_Source_Line_Id IN NUMBER,
4521: X_Header_Id IN NUMBER, -- added by Bala.
4522: x_lot_attributes_rec IN lot_attributes_rec_type, -- added by sisankar for bug 4920235
4523: x_invattr_tbl IN inv_lot_api_pub.char_tbl,
4524: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,
4525: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,
4526: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,
4527: x_err_code OUT NOCOPY NUMBER ,

Line 4524: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,

4520: X_Source_Line_Id IN NUMBER,
4521: X_Header_Id IN NUMBER, -- added by Bala.
4522: x_lot_attributes_rec IN lot_attributes_rec_type, -- added by sisankar for bug 4920235
4523: x_invattr_tbl IN inv_lot_api_pub.char_tbl,
4524: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,
4525: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,
4526: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,
4527: x_err_code OUT NOCOPY NUMBER ,
4528: x_err_msg OUT NOCOPY VARCHAR2) IS

Line 4525: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,

4521: X_Header_Id IN NUMBER, -- added by Bala.
4522: x_lot_attributes_rec IN lot_attributes_rec_type, -- added by sisankar for bug 4920235
4523: x_invattr_tbl IN inv_lot_api_pub.char_tbl,
4524: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,
4525: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,
4526: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,
4527: x_err_code OUT NOCOPY NUMBER ,
4528: x_err_msg OUT NOCOPY VARCHAR2) IS
4529:

Line 4526: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,

4522: x_lot_attributes_rec IN lot_attributes_rec_type, -- added by sisankar for bug 4920235
4523: x_invattr_tbl IN inv_lot_api_pub.char_tbl,
4524: x_Cattr_tbl IN inv_lot_api_pub.char_tbl,
4525: x_Dattr_tbl IN inv_lot_api_pub.date_tbl,
4526: x_Nattr_tbl IN inv_lot_api_pub.number_tbl,
4527: x_err_code OUT NOCOPY NUMBER ,
4528: x_err_msg OUT NOCOPY VARCHAR2) IS
4529:
4530: X_Temp_Id NUMBER;