APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3675: SELECT Mtl_Material_Transactions_S.nextval

3671: p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) THEN
3672:
3673: --Item is under Lot and Serial Control
3674: --Generate serial transaction Temp id.
3675: SELECT Mtl_Material_Transactions_S.nextval
3676: INTO l_Srl_Txn_Tmp_Id
3677: FROM DUAL;
3678:
3679:

Line 4189: SELECT Mtl_Material_Transactions_S.nextval

4185: CLOSE TRX_ACTION_CUR;
4186:
4187:
4188: IF(p_x_txn_hdr_id IS NULL) THEN
4189: SELECT Mtl_Material_Transactions_S.nextval
4190: INTO p_x_txn_hdr_id
4191: FROM DUAL;
4192: IF G_DEBUG='Y' THEN
4193: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');

Line 4201: SELECT Mtl_Material_Transactions_S.nextval

4197: l_loop_count := 0;
4198:
4199: WHILE (l_loop_count < p_x_ahl_mtl_txn_rec.Quantity) LOOP
4200:
4201: SELECT Mtl_Material_Transactions_S.nextval
4202: INTO p_x_txn_intf_id
4203: FROM DUAL;
4204:
4205: IF G_DEBUG='Y' THEN

Line 4340: SELECT Mtl_Material_Transactions_S.nextval

4336: CLOSE get_lot_dff_attrib;
4337: -- Fix for bug# 8607839(FP for Bug # 8575782) -- end
4338:
4339: IF(p_x_ahl_mtl_txn_rec.Serial_Number IS NOT NULL) THEN
4340: SELECT Mtl_Material_Transactions_S.nextval
4341: INTO l_txn_tmp_id
4342: FROM DUAL;
4343: ELSE
4344: l_txn_tmp_id := p_x_txn_intf_id;